🎴 Flashcard Mode
SQL Functions and Joins
Card1 / 20
Mastered0
Review0
QuestionClick to flip
IGNORE DUPLICATE ROWS does not apply if there are any unique indexes in the table.
AnswerClick to flip back
A
True
💡 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.