The SELECT statement SELECT 'Hi' FROM DUAL WHERE NULL = NULL; Outputs
A. Hi
B. FLASE
C. TRUE
D. Nothing
Answer: Option D
Solution (By Examveda Team)
The SELECT statement SELECT 'Hi' FROM DUAL WHERE NULL = NULL; outputs Nothing.In SQL, NULL represents an unknown or missing value. When comparing NULL to NULL using the = operator, the result is neither TRUE nor FALSE; it's unknown. Therefore, the condition NULL = NULL doesn't evaluate to TRUE, and the row is not selected. Hence, the query returns no results, which can be represented as Nothing.

Join The Discussion