IBM
C2090-558 · Question #78
Click the Exhibit button. In the exhibit, which ALTER TABLE statement is used to add the foreign key constraint where customer_num column in the orders table is a foreign key that references the…
The correct answer is D. ALTER TABLE orders ADD CONSTRAINT (FOREIGN KEY (customer_num) REFERENCES. See the full explanation below for the reasoning.
Question
Click the Exhibit button. In the exhibit, which ALTER TABLE statement is used to add the foreign key constraint where customer_num column in the orders table is a foreign key that references the customer_num column in the customer table?
Exhibit
Options
- AALTER TABLE customer ADD CONSTRAINT (FOREIGN KEY (order_num) REFERENCES
- BALTER TABLE orders ADD CONSTRAINT (FOREIGN KEY (order_num) REFERENCES
- CALTER TABLE customer ADD CONSTRAINT (FOREIGN KEY (customer_num) REFERENCES
- DALTER TABLE orders ADD CONSTRAINT (FOREIGN KEY (customer_num) REFERENCES
How the community answered
(61 responses)- A8% (5)
- B3% (2)
- C15% (9)
- D74% (45)
Community Discussion
No community discussion yet for this question.