Multiple choice

Which of the following statements is correct about UNIQUE key in Oracle?

  1. Two rows for a given column having UNIQUE key can have same values

  2. Two rows for a given column having UNIQUE key can have nulls

  3. Both option 1 and option 2 are correct.

  4. Neither option 1 nor option 2 is correct.
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

This answer is correct. Two rows for a given column having UNIQUE key can have nulls. In Oracle, there is an exception that two rows can have nulls though the UNIQUE key is defined for the given column.

Keep practicing — related questions