PrepAway - Latest Free Exam Questions & Answers

When a database detects an error, what enables it to start processing at a designated place?

When a database detects an error, what enables it to start processing at a designated place?

PrepAway - Latest Free Exam Questions & Answers

A.
A checkpoint

B.
A data dictionary

C.
Metadata

D.
A data-mining tool

Explanation:
A: Savepoints and checkpoints are similar in nature. A savepoint is used to periodically save the state of the application and the users information, whereas a checkpoint saves data held in memory to a temporary file. Both are used so that if the application endures a glitch, it has the necessary tools to bring the user back to his working environment without losing any data. You experience this with a word processor when it asks you if you want to review the recovered version of a file you were working on.

2 Comments on “When a database detects an error, what enables it to start processing at a designated place?


Leave a Reply