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

Congestive heart failure is a serious disorder that carries a reduced life expectancy. Heart failure is usually a chronic illness, and it may worsen with infection or other physical stressors.

Did you know?

Though newer “smart” infusion pumps are increasingly becoming more sophisticated, they cannot prevent all programming and administration errors. Health care professionals that use smart infusion pumps must still practice the rights of medication administration and have other professionals double-check all high-risk infusions.

Did you know?

When intravenous medications are involved in adverse drug events, their harmful effects may occur more rapidly, and be more severe than errors with oral medications. This is due to the direct administration into the bloodstream.

Did you know?

Certain chemicals, after ingestion, can be converted by the body into cyanide. Most of these chemicals have been removed from the market, but some old nail polish remover, solvents, and plastics manufacturing solutions can contain these substances.

Did you know?

In ancient Rome, many of the richer people in the population had lead-induced gout. The reason for this is unclear. Lead poisoning has also been linked to madness.

For a complete list of videos, visit our video library