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

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

washai

  • Hero Member
  • *****
  • Posts: 523
on: Jul 7, 2018
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
Reply #1 on: Jul 7, 2018
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

Joy Chen

  • Member
  • Posts: 354
Reply 3 on: Yesterday
Wow, this really help

« previous next »
 

Did you know?

Your heart beats over 36 million times a year.

Did you know?

Alzheimer's disease affects only about 10% of people older than 65 years of age. Most forms of decreased mental function and dementia are caused by disuse (letting the mind get lazy).

Did you know?

Of the estimated 2 million heroin users in the United States, 600,000–800,000 are considered hardcore addicts. Heroin addiction is considered to be one of the hardest addictions to recover from.

Did you know?

The liver is the only organ that has the ability to regenerate itself after certain types of damage. As much as 25% of the liver can be removed, and it will still regenerate back to its original shape and size. However, the liver cannot regenerate after severe damage caused by alcohol.

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.

Inverse Relation Between IQ and Disease. Could this explain the Flynn effect? Inverse Relation Between IQ and Disease. Could this explain the Flynn effect?
Special Purpose Checks Special Purpose Checks
Social scientists have not done well at devising theories to explain lovely romantic moments Social scientists have not done well at devising theories to explain lovely romantic moments
Please fully explain the answer with steps Please fully explain the answer with steps
Checkpoints and proliferation decision points monitor the progress of the cell through the cell cycl Checkpoints and proliferation decision points monitor the progress of the cell through the cell cycl
The purpose of mitosis is to take diploid cells and make two identical clones. A shows a simplified The purpose of mitosis is to take diploid cells and make two identical clones. A shows a simplified
Video: What is Reverse Osmosis?

For a complete list of videos, visit our video library