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 100 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
Great answer, keep it coming :)


brbarasa

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

 

Did you know?

In 2012, nearly 24 milliion Americans, aged 12 and older, had abused an illicit drug, according to the National Institute on Drug Abuse (NIDA).

Did you know?

Essential fatty acids have been shown to be effective against ulcers, asthma, dental cavities, and skin disorders such as acne.

Did you know?

The people with the highest levels of LDL are Mexican American males and non-Hispanic black females.

Did you know?

Human stomach acid is strong enough to dissolve small pieces of metal such as razor blades or staples.

Did you know?

Adolescents often feel clumsy during puberty because during this time of development, their hands and feet grow faster than their arms and legs do. The body is therefore out of proportion. One out of five adolescents actually experiences growing pains during this period.

For a complete list of videos, visit our video library