If a DBMS enforces a DELETE SET-TO-NULL option on the referential ...

[Mollykgkg]

If a DBMS enforces a DELETE SET-TO-NULL option on the referential integrity constraint betweenCLIENT and AGENT in the HAPPY INSURANCE database, what will be the outcome after auser 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

Question 2

The data dictionary created by the ________ is often referred to as the catalog.
 
  A) TCL
  B) DML
  C) DCL
  D) DBMS

[DHRUVSHAH]

Answer to Question 1

C

Answer to Question 2

D