Solved

​Structure of the ORDERITEMS Table

Question 11

Multiple Choice

​Structure of the ORDERITEMS table
​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;
-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;

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions