🎴 Flashcard Mode

Oracle

Card1 / 20
Mastered0
Review0
QuestionClick to flip

Find the odd man out.

  1. PRIMARY KEY Constraint
  2. UNIQUE KEY Constraint
  3. CHECK Constraint
  4. FOREIGN KEY Constraint
  5. NOT NULL Constraint
    Note: While finding the odd man out from the above choices, consider the general scenarios, ignore the rare scenario.
AnswerClick to flip back
A
FOREIGN KEY Constraint
💡 Explanation:

All the Constraints can be applied when you have only one table. But to apply FOREIGN KEY Constraint, two tables are required. Option 4 is the correct choice.

FYI - Rare scenario is A Foreign Key can be applied on single table on its primary key, which is very rare in reality.

Change Mode