Examveda
Examveda

What operator tests column for the absence of data?

A. EXISTS operator

B. NOT operator

C. IS NULL operator

D. None of these

Answer: Option C

Solution(By Examveda Team)

Always use IS NULL to look for NULL values.

Syntax:

SELECT "column_name"
FROM "table_name"
WHERE "column_name" IS NULL

Join The Discussion

Related Questions on Sql Miscellaneous

If a query involves NOT, AND, OR with no parenthesis

A. NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last.

B. NOT will be evaluated first; OR will be evaluated second; AND will be evaluated last.

C. AND will be evaluated first; OR will be evaluated second; NOT will be evaluated last.

D. The order of occurrence determines the order of evaluation.