Multiple choice technology databases

The columns with unique constraint allows more than one null values to be inserted.

  1. True

  2. False

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In Oracle, a UNIQUE constraint allows multiple NULL values. Oracle treats NULL as incomparable (NULL != NULL), so each row with NULL in the unique column is considered distinct. This is standard SQL behavior.