Why one should not use NULL / NOT NULL operator on indexed columns?

  1. Using NULL / NOT NULL on indexed columns won’t use INDEX

  2. Using NULL / NOT NULL on indexed columns gives ERROR

  3. Using NULL / NOT NULL on indexed columns disables INDEX

  4. Using NULL / NOT NULL on indexed columns makes the INDEX unusable


Correct Option: A

Find more quizzes: