Question discussion

Which of the following SQL expressions evaluates to TRUE, according to SQL-99?

359207Medium DSSSB TGT Computer Science 0 replies 0 views
0
Which of the following SQL expressions evaluates to TRUE, according to SQL-99?
  • ANULL <= NULL returns UNKNOWN
  • BNULL >= NULL returns UNKNOWN
  • CNULL IS NULL returns FALSE
  • DNULL IS NULL returns TRUE
Correct answer: D

Explanation

In SQL, NULL IS NULL returns TRUE, whereas comparisons such as NULL <= NULL give UNKNOWN (not TRUE).

Discussion 0

Nobody has replied yet. Start the discussion!