Home » MCQs » Oracle MCQs » Oracle Change Password, Check Constraints, Comments, and Primary Key MCQs

Syntax to Disable Primary Key is –

14. Syntax to Disable Primary Key is -

1. ALTER TABLE DISABLE CONSTRAINT constraint_name;
2. ALTER TABLE table_name DISABLE CONSTRAINT;
3. ALTER TABLE DISABLE CONSTRAINT;
4. ALTER TABLE table_name DISABLE CONSTRAINT constraint_name;

Answer: D) ALTER TABLE table_name DISABLE CONSTRAINT constraint_name;

Explanation:

Syntax to Disable Primary Key is

ALTER TABLE table_name DISABLE CONSTRAINT constraint_name;