Multiple choice technology databases

IGNORE DUPLICATE ROWS does not apply if there are any unique indexes in the table.

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

IGNORE DUPLICATE ROWS is ignored when a table has unique indexes because the unique index constraint still enforces uniqueness at the database level. The option only applies to tables without unique indexes.

Keep practicing — related questions