Quiz for Comparison Operators

Q1: Which of the following is a comparison operator in SQL?

A. BETWEEN B. = C. LIKE D. AND

Q2: Which comparison operator checks for equality?

A. = B. != C. > D. <

Q3: Which operator is used to check if a value is not equal in most SQL dialects?

A. == B. != C. <> D. both B and C

Q4: What does the ">" operator do?

A. Compares if greater than B. Compares if equal C. Compares if less than D. Compares if not equal

Q5: Which operator checks if a value is less than or equal to another?

A. <= B. =< C. >= D. !=

Q6: What is the result of 5 < 3?

A. True B. False C. Error D. Null

Q7: Which of the following is not a comparison operator?

A. = B. IN C. > D. <=

Q8: How do you check for inequality in standard SQL?

A. != B. <> C. = D. ==

Q9: What does the "<" operator do in SQL?

A. Compares for less than B. Checks equality C. Performs division D. Joins tables

Q10: What does the ">=" operator check?

A. Less than B. Greater than or equal C. Equal only D. None of the above

Q11: Which value does SQL return when a comparison involves NULL?

A. TRUE B. FALSE C. NULL D. 0

Q12: What is the result of "10 >= 10"?

A. TRUE B. FALSE C. NULL D. ERROR

Q13: Which comparison operator would be used to find values not equal to 5?

A. <> B. = C. IN D. IS

Q14: What is the output of the SQL expression: 3 <> 3?

A. TRUE B. FALSE C. NULL D. ERROR

Q15: Which operator is equivalent to "NOT ="?

A. != B. = C. > D. <

Q16: What does SQL return if comparison is TRUE?

A. 1 B. TRUE C. Yes D. Depends on the DBMS

Q17: How can you compare a column to a constant value?

A. column = value B. column == value C. column != value D. both A and C

Q18: What is the purpose of comparison operators in SQL?

A. Sorting B. Filtering based on conditions C. Joining tables D. Altering tables

Q19: Which expression is used to find salaries more than 50000?

A. salary < 50000 B. salary = 50000 C. salary > 50000 D. salary != 50000

Q20: Which operator is used to check equality with NULL?

A. == B. = C. IS NULL D. IS NOT NULL

Q21: Which operator is valid for comparing strings in SQL?

A. = B. LIKE C. != D. All of the above