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...
The current fill and stroke colors can be found on the Tools panel.
Answer the following statement true (T) or false (F)
Computer Science & Information Technology
Help screens were written after finalization of actual commands, menus, and buttons, so they are always accurate
Indicate whether the statement is true or false
Computer Science & Information Technology
In 2005, the estimated number of e-mail users in the United States was
A) 105 million B) 1.5 billion C) 1.5 million D) 105 billion
Computer Science & Information Technology
A ____ provides a detailed description of all data used in the database.
a. network model b. data dictionary c. data model d. schema
Computer Science & Information Technology