When you turned your computer on this morning, it crashed. You are not concerned because yesterday, you created a _______.
A)Integrity Check
B)Commit
C)Rollback
D)Savepoint

Question

Quizplus · Accepted Answer

Savepoints are used to make sure that if a system failure occurs, the database can attempt to return to a point before the system crashed. Savepoints are easy to implement within databases and applications, but a balance must be struck between too many and not enough savepoints. Having too many savepoints can degrade the performance, whereas not having enough savepoints runs the risk of losing data and decreasing user productivity because the lost data would have to be reentered.

When You Turned Your Computer on This Morning, It Crashed