Multiple choice

Which of the following statements is true?

i. For enabling primary key constraint, ALTER TABLE is used. ii. For enabling primary key constraint, ENABLE keyword is used all alone. iii. For disabling primary key, index will be dropped. iv. For disabling primary key, index will not be dropped.

  1. i. and iii. are true

  2. i. and iv. are true

  3. ii. and iii. are true

  4. ii. and iv. are true

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

This answer is correct because for enabling primary key constraint, ALTER TABLE is used followed by ENABLE key word. Similarly, for disabling primary key constraint, index will be dropped because the index comes along with primary key by default and since primary key constraint is not applied on the records, the index is also dropped.