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 92 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
:D TYSM

tanna.moeller

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

« previous next »
 

Did you know?

There used to be a metric calendar, as well as metric clocks. The metric calendar, or "French Republican Calendar" divided the year into 12 months, but each month was divided into three 10-day weeks. Each day had 10 decimal hours. Each hour had 100 decimal minutes. Due to lack of popularity, the metric clocks and calendars were ended in 1795, three years after they had been first marketed.

Did you know?

All adults should have their cholesterol levels checked once every 5 years. During 2009–2010, 69.4% of Americans age 20 and older reported having their cholesterol checked within the last five years.

Did you know?

Barbituric acid, the base material of barbiturates, was first synthesized in 1863 by Adolph von Bayer. His company later went on to synthesize aspirin for the first time, and Bayer aspirin is still a popular brand today.

Did you know?

Though the United States has largely rejected the metric system, it is used for currency, as in 100 pennies = 1 dollar. Previously, the British currency system was used, with measurements such as 12 pence to the shilling, and 20 shillings to the pound.

Did you know?

The lipid bilayer is made of phospholipids. They are arranged in a double layer because one of their ends is attracted to water while the other is repelled by water.

How to calculate present value (Question 4) How to calculate present value (Question 4)
How to combine and sketch transformations of a sinusoidal function (Question 2) (y=a*sin⁡b(x−c)+d) How to combine and sketch transformations of a sinusoidal function (Question 2) (y=a*sin⁡b(x−c)+d)
Calculus question Calculus question
economic question economic question
economic question economic question
Which color is placed at the center of the circle? Which color is placed at the center of the circle?
Video: Red alga life cycle Animation

For a complete list of videos, visit our video library