Question

During the _______ phase, the local variables that hold the write operations are copied to the database

(a) Read phase

(b) Validation phase

(c) Write phase

(d) None of the mentioned

The question was posed to me during an online interview.

I'd like to ask this question from Validation Based Protocols topic in section Concurrency Control of RDBMS

Answer 1

Right choice is (c) Write phase

Explanation: During the write phase, the local variables that hold the write operations are copied to the database. Read only operations omit this phase.