11.) What is the purpose of the BETWEEN operator?
A) Matches a range of values
B) Joins tables
C) Filters NULL values
D) Sorts rows
12.) Which keyword is used to match patterns in SQL?
A) MATCH
B) LIKE
C) PATTERN
D) SEARCH
13.) How do you rename a column in the result set?
A) USING
B) AS
C) RENAME
D) ALIAS
14.) Which operator is used to combine the results of two queries?
A) CONNECT
B) JOIN
C) MERGE
D) UNION
15.) What does the NOT IN operator do?
A) Excludes values from a list
B) Filters rows
C) Joins tables
D) Sorts rows
16.) How do you retrieve unique values from a column?
A) FILTER
B) UNIQUE
C) DISTINCT
D) GROUP BY
17.) How do you find the highest value in a column?
A) MIN()
B) MAX()
C) TOP()
D) HIGHEST()
18.) What does the IN operator do?
A) Matches a value within a set
B) Filters rows
C) Sorts rows
D) Deletes rows
19.) How do you check if a column contains NULL values?
A) CHECK NULL
B) = NULL
C) HAS NULL
D) IS NULL
20.) What is the result of a CROSS JOIN?
A) Cartesian product of two tables
B) Intersection of two tables
C) Difference of two tables
D) Union of two tables
Related
