1
Question
What operator tests the column for the absence of data?
What operator tests the column for the absence of data?
Open in App
Solution
The correct option is B IS NULL operator
The operator that tests column for the absence of data is an option b) is NULL operator. The NULL operator is used in the database for representing that a particular field is empty.
SELECT ‘column_name’
FROM ‘table_name’
WHERE ‘column_name’ IS NULL
IS NULL operator
The operator that tests column for the absence of data is an option b) is NULL operator. The NULL operator is used in the database for representing that a particular field is empty.
SELECT ‘column_name’
FROM ‘table_name’
WHERE ‘column_name’ IS NULL
Suggest Corrections
0
Join BYJU'S Learning Program
Explore more
Join BYJU'S Learning Program
