Examveda
Examveda

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

Join The Discussion

Comments ( 2 )

  1. Shahad Al-zahrani
    Shahad Al-zahrani :
    5 months ago


    Which of the following join is also called as an 'inner-join'?
    Equijoin
    Self-Join
    Non-Equijoin
    None of these

  2. Shahad Al-zahrani
    Shahad Al-zahrani :
    5 months ago


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

Related Questions on Sql Miscellaneous