Question

What operator tests column for absence of data

Select the correct answer from below options:

a) NOT Operator

b) Exists Operator

c) IS NULL Operator

d) None of the above

Answer 1

c) IS NULL Operator

The IS NULL operator is used to testing the empty values in the table's column. It returns true if column values are NULL.

The NOT operator gives the result only when the specified condition is not true.

The EXISTS operator used in combination with a subquery, and if a subquery returns any record, this operator returns true. Otherwise, it will return false.