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.


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

Join The Discussion

Related Questions on Sql Miscellaneous

SQL can be used to:

A. create database structures only.

B. query database data only.

C. modify database data only.

D. All of the above can be done by SQL.