What happens once the following command is executed? ALTER TABLE ORDERS
ADD FOREIGN KEY (CLIENT_ID) REFERENCES CLIENT (CLIENT_ID);
A) The DBMS will reject updates to the ORDERS table with CLIENT_ID values missing from the CLIENT table.
B) The DBMS will reject the insertion of rows that have different primary keys but are otherwise identical into the ORDERS table.
C) The DBMS will reject updates to the CLIENT table with CLIENT_ID values missing from the ORDERS table.
D) The DBMS will ensure that only legal values are entered into the CLIENT_ID column in the ORDERS table.

Question

Quizplus · Accepted Answer

The Answer of What happens once the following command is executed? ALTER TABLE ORDERS
ADD FOREIGN KEY (CLIENT_ID) REFERENCES CLIENT (CLIENT_ID);
A) The DBMS will reject updates to the ORDERS table with CLIENT_ID values missing from the CLIENT table.
B) The DBMS will reject the insertion of rows that have different primary keys but are otherwise identical into the ORDERS table.
C) The DBMS will reject updates to the CLIENT table with CLIENT_ID values missing from the ORDERS table.
D) The DBMS will ensure that only legal values are entered into the CLIENT_ID column in the ORDERS table.

What Happens Once the Following Command Is Executed? ALTER TABLE