QuestenaPractice that shows what to review next
SearchCreate a test
Question 1

In PostgreSQL 18, what does SELECT 'b' NOT IN ('a', NULL); return?

  1. NULLCorrect answer
  2. false
  3. It raises an error
  4. true

Explanation

NOT IN over a value list expands to 'b' <> 'a' AND 'b' <> NULL. The first comparison is true, the second is null, and true AND null is null. The tempting answer true comes from reasoning that 'b' is clearly not 'a', but the unknown comparison cannot be ruled out, and a row filtered by a null predicate is not returned.

Continue with this test

Start practice
Back to test
Question 1: In PostgreSQL 18, what does SELECT 'b' NOT IN ('a', NULL);… · SQL: NULL, Joins and Aggregates · Questena