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


Jsherida

  • Member
  • Posts: 314
Reply 3 on: Yesterday
Excellent

 

Did you know?

The Centers for Disease Control and Prevention has released reports detailing the deaths of infants (younger than 1 year of age) who died after being given cold and cough medications. This underscores the importance of educating parents that children younger than 2 years of age should never be given over-the-counter cold and cough medications without consulting their physicians.

Did you know?

More than 30% of American adults, and about 12% of children utilize health care approaches that were developed outside of conventional medicine.

Did you know?

Walt Disney helped combat malaria by making an animated film in 1943 called The Winged Scourge. This short film starred the seven dwarfs and taught children that mosquitos transmit malaria, which is a very bad disease. It advocated the killing of mosquitos to stop the disease.

Did you know?

Computer programs are available that crosscheck a new drug's possible trade name with all other trade names currently available. These programs detect dangerous similarities between names and alert the manufacturer of the drug.

Did you know?

Acetaminophen (Tylenol) in overdose can seriously damage the liver. It should never be taken by people who use alcohol heavily; it can result in severe liver damage and even a condition requiring a liver transplant.

For a complete list of videos, visit our video library