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

softEldritch

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

« previous next »
 

Did you know?

The B-complex vitamins and vitamin C are not stored in the body and must be replaced each day.

Did you know?

Autoimmune diseases occur when the immune system destroys its own healthy tissues. When this occurs, white blood cells cannot distinguish between pathogens and normal cells.

Did you know?

Coca-Cola originally used coca leaves and caffeine from the African kola nut. It was advertised as a therapeutic agent and "pickerupper." Eventually, its formulation was changed, and the coca leaves were removed because of the effects of regulation on cocaine-related products.

Did you know?

Although puberty usually occurs in the early teenage years, the world's youngest parents were two Chinese children who had their first baby when they were 8 and 9 years of age.

Did you know?

As of mid-2016, 18.2 million people were receiving advanced retroviral therapy (ART) worldwide. This represents between 43–50% of the 34–39.8 million people living with HIV.

This modified model of Easton’s systems theory puts government decision makers as the source of pol This modified model of Easton’s systems theory puts government decision makers as the source of pol
Special Purpose Checks Special Purpose Checks
Cultures Ideal Body Types Cultures Ideal Body Types
The Number of Children Americans Think Are Ideal The Number of Children Americans Think Are Ideal
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
Video: Replication of DNA and Chromosomes/ How do cells replicate their DNA? (Animation) no Audio

For a complete list of videos, visit our video library