What happens once the following command is executed?

ALTER TABLE ORDERS

ADD FOREIGN KEY $($CLIENT$\_$ID$)$ REFERENCES CLIENT $($CLIENT$\_$ID$)$;

The DBMS will reject updates to the ORDERS table with CLIENT$\_$ID values missing from the CLIENT table.

The DBMS will reject the insertion of rows that have different primary keys but are otherwise identical into the ORDERS table.

The DBMS will reject updates to the CLIENT table with CLIENT$\_$ID values missing from the ORDERS table.

The DBMS will ensure that only legal values are entered into the CLIENT$\_$ID column in the ORDERS table.