Multiple choice

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.

  1. PRIMARY KEY Constraint

  2. UNIQUE KEY Constraint

  3. CHECK Constraint

  4. FOREIGN KEY Constraint

  5. NOT NULL Constraint
Reveal answer Fill a bubble to check yourself
D Correct answer
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.

Keep practicing — related questions