Question

If a DBMS enforces a DELETE CASCADE option on the referential integrity constraint between CLIENT and AGENT in the HAPPY INSURANCE database, what will be the outcome after a user tries to delete the last record (A4, James, 3, 90, 2010, A3) from AGENT?A) CLIENT will have 7 records, AGENT will have 4 records
B) CLIENT will have 6 records, AGENT will have 3 records
C) CLIENT will have 7 records, AGENT will have 3 records
D) CLIENT will have 6 records, AGENT will have 4 records

Answer 1

Answer:

The correct option is option C.

Explanation:

As the referential integrity constraint between the CLIENT and AGENT so the CLIENT will have 7 records while AGENT will have 3 records.

Option A is not correct that CLIENT will have 7 records but AGENT will not have 4 records

Option B is not correct that CLIENT will  not have 6 records but AGENT will have 3 records

Option C is correct that CLIENT will  have 7 records but AGENT will have 3 records

Option D is not correct that CLIENT will  not have 6 records but AGENT will not have 4 records