This topic contains a solution. Click here to go to the answer

Author Question: Explain the purpose of transaction logs and checkpoints. What will be an ideal ... (Read 106 times)

washai

  • Hero Member
  • *****
  • Posts: 523
Explain the purpose of transaction logs and checkpoints.
 
  What will be an ideal response?

Question 2

Semantic objects represent the user's perceptions more closely than the E-R model.
 
  Indicate whether the statement is true or false



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

AngeliqueG

  • Sr. Member
  • ****
  • Posts: 343
Answer to Question 1

Transaction logs are created to facilitate the recovery of the database. All transactions that make changes to the database are recorded in the transaction log before they are applied to the database. In the event that the database fails the transactions in the log can be used to undo changes made by transactions that were not committed, and to redo changes that were committed since the database was last saved. Checkpoints are used in conjunction with transaction logs. A checkpoint is a marker for when the last time the database and the transaction log were synchronized. If the database must be restored, only after images for transactions that began after the last checkpoint have to be applied.

Answer to Question 2

TRUE




washai

  • Member
  • Posts: 523
Reply 2 on: Jul 7, 2018
Thanks for the timely response, appreciate it


meow1234

  • Member
  • Posts: 333
Reply 3 on: Yesterday
Great answer, keep it coming :)

 

Did you know?

Despite claims by manufacturers, the supplement known as Ginkgo biloba was shown in a study of more than 3,000 participants to be ineffective in reducing development of dementia and Alzheimer’s disease in older people.

Did you know?

There are over 65,000 known species of protozoa. About 10,000 species are parasitic.

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 the ancient and medieval periods, dysentery killed about ? of all babies before they reach 12 months of age. The disease was transferred through contaminated drinking water, because there was no way to adequately dispose of sewage, which contaminated the water.

Did you know?

Approximately one in three babies in the United States is now delivered by cesarean section. The number of cesarean sections in the United States has risen 46% since 1996.

For a complete list of videos, visit our video library