Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 69 of 79

MySQL SQL Revision Tour — Question 12

Back to all questions
12
Question

Question 12

Consider the following query :

SELECT name FROM class WHERE subject ............... NULL;

Which comparison operator may be used to fill the blank space in above query ?

  1. =
  2. LIKE
  3. IS
  4. IS NOT
Answer

IS, IS NOT

Reason — In SQL, to check for NULL values, we must use the IS NULL or IS NOT NULL comparison operators. The "=" operator cannot be used for NULL because NULL represents an unknown value, and comparisons using = (equal to) will not work as expected. The LIKE operator is used for pattern matching with strings.