Structure of the ORDERITEMS table

-If a PRIMARY KEY constraint,named ORDERITEMS_PK,for the ORDER# and ITEM# columns of the ORDERITEMS table have been disabled,which of the following commands will enable the constraint?
A) ALTER TABLE orderitems ENABLE PRIMARY KEY CONSTRAINT;
B) ALTER TABLE orderitems ENABLE CONSTRAINT orderitems_pk;
C) ALTER TABLE orderitems MODIFY PRIMARY KEY CONSTRAINT;
D) ALTER TABLE orderitems MODIFY PRIMARY KEY CONSTRAINT ENABLE;

Question

​Structure of the ORDERITEMS table
 
-If a PRIMARY KEY constraint,named ORDERITEMS_PK,for the ORDER# and ITEM# columns of the ORDERITEMS table have been disabled,which of the following commands will enable the constraint?​
A) ALTER TABLE orderitems ENABLE PRIMARY KEY CONSTRAINT; 
B) ALTER TABLE orderitems ENABLE CONSTRAINT orderitems_pk; 
C) ALTER TABLE orderitems MODIFY PRIMARY KEY CONSTRAINT; 
D) ​ALTER TABLE orderitems MODIFY PRIMARY KEY CONSTRAINT ENABLE;

Quizplus · Accepted Answer

Option B is the correct syntax to enable a disabled named primary key constraint in Oracle. Option A is incorrect because it does not specify the constraint name. Option C is incorrect because MODIFY is not a valid keyword for enabling a constraint. Option D is incorrect because ENABLE should come before MODIFY in the ALTER TABLE syntax.

​Structure of the ORDERITEMS Table

Structure of the ORDERITEMS Table