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

The strongest synthetic topical retinoid drug available, tazarotene, is used to treat sun-damaged skin, acne, and psoriasis.

Did you know?

Your skin wrinkles if you stay in the bathtub a long time because the outermost layer of skin (which consists of dead keratin) swells when it absorbs water. It is tightly attached to the skin below it, so it compensates for the increased area by wrinkling. This happens to the hands and feet because they have the thickest layer of dead keratin cells.

Did you know?

There can actually be a 25-hour time difference between certain locations in the world. The International Date Line passes between the islands of Samoa and American Samoa. It is not a straight line, but "zig-zags" around various island chains. Therefore, Samoa and nearby islands have one date, while American Samoa and nearby islands are one day behind. Daylight saving time is used in some islands, but not in others—further shifting the hours out of sync with natural time.

Did you know?

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

Did you know?

In 1885, the Lloyd Manufacturing Company of Albany, New York, promoted and sold "Cocaine Toothache Drops" at 15 cents per bottle! In 1914, the Harrison Narcotic Act brought the sale and distribution of this drug under federal control.

For a complete list of videos, visit our video library