Author Question: Describe the update restrict option (for implementing a referential integrity constraint). What ... (Read 64 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?

Acute bronchitis is an inflammation of the breathing tubes (bronchi), which causes increased mucus production and other changes. It is usually caused by bacteria or viruses, can be serious in people who have pulmonary or cardiac diseases, and can lead to pneumonia.

Did you know?

More than 4.4billion prescriptions were dispensed within the United States in 2016.

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.

Did you know?

Patients who cannot swallow may receive nutrition via a parenteral route—usually, a catheter is inserted through the chest into a large vein going into the heart.

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.

For a complete list of videos, visit our video library