Chapter Quiz: Transaction Control (TCL) & Concurrency

Transaction Control (TCL)

Complete this assessment with 100% score to master this chapter.

01Which isolation level prevents 'Dirty Reads' but still allows 'Non-Repeatable Reads'?

02What occurs when two transactions are blocked waiting for locks held by each other?

03Which ACID property ensures that all statements in a transaction succeed as a single unit, or none are applied at all if an error occurs?

04What is the performance penalty of executing a loop of 1,000 individual UPDATE statements without an explicit BEGIN/COMMIT block?

05In the context of database transactions, what does the 'Durability' property of ACID guarantee?