If a DBMS enforces in the HAPPY INSURANCE database a DELETE RESTRICT option on the referential integrity constraint between AGENT and AGENT (i.e., circular referential integrity constraint for table AGENT) in the HAPPY INSURANCE database, and a DELETE CASCADE between AGENT and CLIENT, the second record in the table AGENT can be deleted.
Indicate whether the statement is true or false.
Answer: False.
Explanation: This is because A2 in AGENT table is referenced in CLIENT table . So CLIENT table child records become orphan.
Computer Science & Information Technology
You might also like to view...
You have to name your database and select a location to save your database file before you can create a blank database
Indicate whether the statement is true or false
Computer Science & Information Technology
The ________ function returns the position of a value in a list
Fill in the blank(s) with correct word
Computer Science & Information Technology