Author Question: Describe the update restrict option (for implementing a referential integrity constraint). What ... (Read 72 times)

CORALGRILL2014

  • Hero Member
  • *****
  • Posts: 525
Describe the update restrict option (for implementing a referential integrity constraint).
 
  What will be an ideal response?

Question 2

What is database recovery?
 
  What will be an ideal response?



ErinKing

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

The update restrict option does not allow the primary key value of a record to be changed if its primary key value is referred to by a foreign key value.

Answer to Question 2

Database recovery refers to recovering the content of the database after a failure.



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
 

Did you know?

According to the American College of Allergy, Asthma & Immunology, more than 50 million Americans have some kind of food allergy. Food allergies affect between 4 and 6% of children, and 4% of adults, according to the CDC. The most common food allergies include shellfish, peanuts, walnuts, fish, eggs, milk, and soy.

Did you know?

The most destructive flu epidemic of all times in recorded history occurred in 1918, with approximately 20 million deaths worldwide.

Did you know?

The first oral chemotherapy drug for colon cancer was approved by FDA in 2001.

Did you know?

In the ancient and medieval periods, dysentery killed about ? of all babies before they reach 12 months of age. The disease was transferred through contaminated drinking water, because there was no way to adequately dispose of sewage, which contaminated the water.

Did you know?

Calcitonin is a naturally occurring hormone. In women who are at least 5 years beyond menopause, it slows bone loss and increases spinal bone density.

For a complete list of videos, visit our video library