SQL Logical Operators Interview Questions in MCQ Format

Wildcard characters are used with the ______ operator?

a) LIKE
b) IN
c) BETWEEN
d) HAVING

Answer: a) LIKE

Wildcard characters are used with the LIKE operator to search for a specific pattern in a column.

Which of the following is true for the IN operator?

a) Specify multiple values in a WHERE clause.
b) Selects value in a given range.
c) Give the table a temporary name.
d) Search for a specified pattern.

Answer: a) Specify multiple values in a WHERE clause.

The IN operator is a shorthand for multiple OR conditions.

Example
SELECT * FROM Employees
WHERE Country IN ('India', 'Australia');

Which operator is used to compare a value to a specified list of values?

a) ANY
b) BETWEEN
c) ALL
d) IN

Answer: d) IN

Which operator is used to compare the NULL values in SQL?

a) Equal
b) IN
c) IS
d) None of Above

Answer: c) IS