Structure of the ORDERITEMS table

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

Question

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

Quizplus · Accepted Answer

The correct command to disable a specific primary key constraint in a table is "ALTER TABLE DISABLE CONSTRAINT ;". Therefore, option B is the correct command to disable the "ORDERITEMS_PK" primary key constraint in the "ORDERITEMS" table. Options A, C, and D are all incorrect and do not represent valid SQL syntax for disabling a primary key constraint.

​Structure of the ORDERITEMS Table

Structure of the ORDERITEMS Table