Multiple choice technology databases

In Oracle, the result of comparison conditions can be (choose all that apply):

  1. TRUE

  2. UNKNOWN

  3. ERROR

  4. NULL

  5. FALSE
Reveal answer Fill a bubble to check yourself
A,B,E Correct answer
Explanation

Oracle comparison operators return three possible values: TRUE, FALSE, or UNKNOWN. UNKNOWN is returned when any operand in the comparison is NULL (not the same as NULL itself). ERROR is not a valid result for comparison conditions - errors occur from invalid operations, not comparisons. NULL is a value, not a comparison result.

AI explanation

In Oracle SQL, a comparison condition (like =, <, >) evaluates to TRUE or FALSE, or to UNKNOWN when one of the operands being compared is NULL (since NULL represents an unknown value, any comparison involving it is itself unknown rather than true or false). There's no "ERROR" or "NULL" result type for a comparison condition itself — those aren't valid outcomes of the comparison operation.

Keep practicing — related questions