This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: What is a checkpoint? What will be an ideal response?[br][br][b][color=#165FFA]Question ... (Read 47 times)

kamilo84

  • Sr. Member
  • ****
  • Posts: 495
on: Jul 7, 2018
What is a checkpoint?
 
  What will be an ideal response?

Question 2

Describe the update set-to-null option (for implementing a referential integrity constraint).
 
  What will be an ideal response?


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

alexanderhamilton

  • Sr. Member
  • ****
  • Posts: 334
Reply #1 on: Jul 7, 2018
Answer to Question 1

A checkpoint is a part of a recovery log. When a checkpoint is created, all updates recorded in the recovery logand as a result any updates to data stored in memoryare written to the database in the data file on the disk.

Answer to Question 2

The update set-to-null option allows a record to be changed if its primary key value is referred to by a foreign key value of a record in another relation. As a consequence, in all of the records where the foreign key value refers to the primary key being changed, the value of the foreign key is set to null.


kamilo84

  • Member
  • Posts: 495
Reply 2 on: Jul 7, 2018
Great answer, keep it coming :)

cam1229

  • Member
  • Posts: 329
Reply 3 on: Yesterday
Gracias!

« previous next »
 

Did you know?

Pink eye is a term that refers to conjunctivitis, which is inflammation of the thin, clear membrane (conjunctiva) over the white part of the eye (sclera). It may be triggered by a virus, bacteria, or foreign body in the eye. Antibiotic eye drops alleviate bacterial conjunctivitis, and antihistamine allergy pills or eye drops help control allergic conjunctivitis symptoms.

Did you know?

Many people have small pouches in their colons that bulge outward through weak spots. Each pouch is called a diverticulum. About 10% of Americans older than age 40 years have diverticulosis, which, when the pouches become infected or inflamed, is called diverticulitis. The main cause of diverticular disease is a low-fiber diet.

Did you know?

In inpatient settings, adverse drug events account for an estimated one in three of all hospital adverse events. They affect approximately 2 million hospital stays every year, and prolong hospital stays by between one and five days.

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.

Did you know?

Amphetamine poisoning can cause intravascular coagulation, circulatory collapse, rhabdomyolysis, ischemic colitis, acute psychosis, hyperthermia, respiratory distress syndrome, and pericarditis.

Question Question
Terry Winters, Color and Information. Terry Winters, Color and Information.
Cell-mediated immunity, primary and secondary response. Cell-mediated immunity, primary and secondary response.
How the Wernicke-Geschwind model works in a person who is responding to a heard question and reading ... How the Wernicke-Geschwind model works in a person who is responding to a heard question and reading ...
How to calculate present value (Question 4) How to calculate present value (Question 4)
Frequency diagrams of skin colors. (a) Skin color distribution in the parents falls into two discont Frequency diagrams of skin colors. (a) Skin color distribution in the parents falls into two discont
Video: Pasteur's Experiment

For a complete list of videos, visit our video library