Database Management System (DBMS) Questions - Recovery MULTIPLE CHOICE 1. A chec

ID: 3688350 • Letter: D

Question

Database Management System (DBMS) Questions - Recovery

MULTIPLE CHOICE

1. A checkpoint does all of the following except:

suspend running transactions

force write the log to disk

force write the data for committed transactions to disk

force write modified data blocks for uncommitted transactions

2. Durability of a transaction is ensured by:

the recovery manager

the concurrency control manager

the query optimizer

the developer who writes the transaction

sheer dumb luck

3. The redo operation:

restarts a transaction from scratch

writes new values from start of the log to the end for committed data

writes old values from the log back to the database for uncommitted data

force writes all buffers to disk

4. The undo operation:

restarts a transaction from scratch

writes new values from start of the log to the end for committed data

writes old values from the log back to the database for uncommitted data

force writes all buffers to disk

TRUE OR FALSE

5. The atomic property of a transaction ensures that it is either performed in its entirety or is not performed at all. (True/False)

6. The idempotent feature of undo and redo operations ensure that they are repeatable and always lead to the same result. (True/False)

Answers:

1. A checkpoint does all of the following except: suspend running transactions

2. Durability of a transaction is ensured by: the recovery manager

3. The redo operation: writes new values from start of the log to the end for committed data

4.The undo operation:writes old values from the log back to the database for uncommitted data

5. True

6. False

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.