ExamVeda
Login
Home
This question belongs to SQL Sql Miscellaneous
Sql Miscellaneous
?

What operator tests column for the absence of data?

Answer & Solution
Correct Answer: Option C

Always use IS NULL to look for NULL values.

Syntax:

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

Examveda
Question posted by Examveda
Community

Join the Discussion

2 Comments
Shahad Al-zahrani
Shahad Al-zahrani 6 years ago

Which of the following join is also called as an 'inner-join'?
Equijoin
Self-Join
Non-Equijoin
None of these
Shahad Al-zahrani
Shahad Al-zahrani 6 years ago

Cartesian product in relational algebra is
a Binary operator
a Unary operator
a Ternary operator
not defined