Q4
What operator tests column for the absence of data?
A.
EXISTS operator
B.
NOT operator
C.
IS NULL operator
AnswerD.
None of these
Answer: Option C
Solution
Answer: Option C
Solution:
Always use IS NULL to look for NULL values.
Syntax:
SELECT "column_name"
FROM "table_name"
WHERE "column_name" IS NULL