« previous next »

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

Mollykgkg

  • Hero Member
  • *****
  • Posts: 529
on: Jul 7, 2018
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
Reply #1 on: Jul 7, 2018
Answer to Question 1

C

Answer to Question 2

D


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
« previous next »
 

Did you know?

It is believed that humans initially contracted crabs from gorillas about 3 million years ago from either sleeping in gorilla nests or eating the apes.

Did you know?

Acetaminophen (Tylenol) in overdose can seriously damage the liver. It should never be taken by people who use alcohol heavily; it can result in severe liver damage and even a condition requiring a liver transplant.

Did you know?

As many as 20% of Americans have been infected by the fungus known as Histoplasmosis. While most people are asymptomatic or only have slight symptoms, infection can progress to a rapid and potentially fatal superinfection.

Did you know?

Chronic marijuana use can damage the white blood cells and reduce the immune system's ability to respond to disease by as much as 40%. Without a strong immune system, the body is vulnerable to all kinds of degenerative and infectious diseases.

Did you know?

Drug abusers experience the following scenario: The pleasure given by their drug (or drugs) of choice is so strong that it is difficult to eradicate even after years of staying away from the substances involved. Certain triggers may cause a drug abuser to relapse. Research shows that long-term drug abuse results in significant changes in brain function that persist long after an individual stops using drugs. It is most important to realize that the same is true of not just illegal substances but alcohol and tobacco as well.

Constraint-Induced Movement Therapy Constraint-Induced Movement Therapy
In countries where water can be contaminated, breastfeeding is an important option for the health of ... In countries where water can be contaminated, breastfeeding is an important option for the health of ...
Is it ethical to break the law to defend our personal integrity? Is it ethical to break the law to defend our personal integrity?
reaction and option reaction and option
Video: Major Elements in Biological Molecules: Nucleic acids

For a complete list of videos, visit our video library