1. If a DBMS enforces an UPDATE CASCADE option on the referential integrity constraint between SELLER and REALTOR in the HOMETOWN REALESTATE database, what will be the outcome after a user tries to update the RealtorID value in third record in table REALTOR from R3 to R5?

A. Value R5 appears once in column RealtorID in REALTOR, and value R5 does not appear in column RealtorID in table SELLER.

B. Value R5 appears once in column RealtorID in REALTOR, and value R5 appears twice in column RealtorID in table SELLER.

C. Value R5 appears once in column RealtorID in REALTOR, and value R5 appears once in column RealtorID in table SELLER.

D. Value R5 does not appear in column RealtorID in REALTOR, and value R5 appears once in column RealtorID in table SELLER.

E. Value R5 does not appear in column RealtorID in REALTOR, and value R5 does not appear in column RealtorID in table SELLER

2. If a DBMS enforces an UPDATE SET-TO-NULL option on the referential integrity constraint between SELLER and REALTOR in the HOMETOWN REALESTATE database, what will be the outcome after a user tries to update the RealtorID value in third record in table REALTOR from R3 to R5?

A. Value R5 appears once in column RealtorID in REALTOR, and value R5 does not appear in column RealtorID in table SELLER

B. Value R5 does not appear in column RealtorID in REALTOR, and value R5 does not appear in column RealtorID in table SELLER

C. Value R5 appears once in column RealtorID in REALTOR, and value R5 appears once in column RealtorID in table SELLER

D. Value R5 does not appear in column RealtorID in REALTOR, and value R5 appears once in column RealtorID in table SELLER

E. Value R5 appears once in column RealtorID in REALTOR, and value R5 appears twice in column RealtorID in table SELLER

HOMETOWN REALESTATE Observe the HOMETOWN REALESTATE database: SELLER REALTOR