Multiple Choice
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;
Correct Answer:

Verified
Correct Answer:
Verified
Q6: A constraint for a composite primary key
Q7: A PRIMARY KEY constraint will make certain
Q8: Which of the following is a valid
Q9: A UNIQUE constraint is the same as
Q10: A constraint name can consist of up
Q12: A constraint is created at the _
Q13: The _ constraint requires that a specific
Q14: Which of the following is the standard
Q15: If the Oracle 12c server assigns a
Q16: Structure of the PROMOTION table<br> <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB1929/.jpg"