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

Syntax to Enable Primary Key is –

15. Syntax to Enable Primary Key is -

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

Answer: D) ALTER TABLE table_name ENABLE CONSTRAINT constraint_name;

Explanation:

Syntax to Enable Primary Key is:

ALTER TABLE table_name ENABLE CONSTRAINT constraint_name;