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 110 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
YES! Correct, THANKS for helping me on my review

kalskdjl1212

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

« previous next »
 

Did you know?

It is difficult to obtain enough calcium without consuming milk or other dairy foods.

Did you know?

Although not all of the following muscle groups are commonly used, intramuscular injections may be given into the abdominals, biceps, calves, deltoids, gluteals, laterals, pectorals, quadriceps, trapezoids, and triceps.

Did you know?

Elderly adults are living longer, and causes of death are shifting. At the same time, autopsy rates are at or near their lowest in history.

Did you know?

To prove that stomach ulcers were caused by bacteria and not by stress, a researcher consumed an entire laboratory beaker full of bacterial culture. After this, he did indeed develop stomach ulcers, and won the Nobel Prize for his discovery.

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.

Draw and label a diagram and explain how a factor-dependent transcription (rho-dependent) terminator Draw and label a diagram and explain how a factor-dependent transcription (rho-dependent) terminator
Apply light tapotement on the head. Tapping lightly with the fingertips works well for this purpose. Apply light tapotement on the head. Tapping lightly with the fingertips works well for this purpose.
Control of the cell cycle by cyclin-dependent kinases, and the checkpoints at which they operate Control of the cell cycle by cyclin-dependent kinases, and the checkpoints at which they operate
Please fully explain in detail Please fully explain in detail
Explain how it can be desirable from an intertemporal perspective for a country run a current ... Explain how it can be desirable from an intertemporal perspective for a country run a current ...
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: Introduction to Human Immunodeficiency Virus (HIV)

For a complete list of videos, visit our video library