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
This Question Belongs to SQL >> Sql Miscellaneous
Join The Discussion
Comments ( 2 )
Related Questions on Sql Miscellaneous
A. Structured Query Language
B. Structured Query List
C. Simple Query Language
D. None of these
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
A. Data Definition Language(DDL)
B. Data Manipulation Language(DML)
C. Both of above
D. None
Which operator performs pattern matching?
A. BETWEEN operator
B. LIKE operator
C. EXISTS operator
D. None of these
What operator tests column for the absence of data?
A. EXISTS operator
B. NOT operator
C. IS NULL operator
D. None of these
Which of the following join is also called as an 'inner-join'?
Equijoin
Self-Join
Non-Equijoin
None of these
Cartesian product in relational algebra is
a Binary operator
a Unary operator
a Ternary operator
not defined