🎴 Flashcard Mode
Database Fundamentals and SQL Quiz
Card1 / 20
Mastered0
Review0
QuestionClick to flip
Which of the following is used to indicate a column will not accept NULL values and can be referenced in another table's foreign key specification?
AnswerClick to flip back
A
Unique constraint
💡 Explanation:
A UNIQUE constraint ensures a column will not accept NULL values (in most DBMS implementations) and creates an index that can be referenced by a foreign key. CHECK constraints only validate data values, DEFAULT constraints provide fallback values, and INFORMATIONAL is not a standard constraint type.