Author Question: If a DBMS enforces a DELETE SET-TO-NULL option on the referential integrity constraint betweenCLIENT ... (Read 59 times)

Mollykgkg

  • Hero Member
  • *****
  • Posts: 529
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

  • Sr. Member
  • ****
  • Posts: 317
Answer to Question 1

C

Answer to Question 2

D



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
 

Did you know?

The longest a person has survived after a heart transplant is 24 years.

Did you know?

On average, the stomach produces 2 L of hydrochloric acid per day.

Did you know?

The tallest man ever known was Robert Wadlow, an American, who reached the height of 8 feet 11 inches. He died at age 26 years from an infection caused by the immense weight of his body (491 pounds) and the stress on his leg bones and muscles.

Did you know?

Asthma is the most common chronic childhood disease in the world. Most children who develop asthma have symptoms before they are 5 years old.

Did you know?

Street names for barbiturates include reds, red devils, yellow jackets, blue heavens, Christmas trees, and rainbows. They are commonly referred to as downers.

For a complete list of videos, visit our video library