What intention locks must be obtained by a read operation in a transaction executing at REPEATABLE READ when the locking implementation given in Section A.1.5 is used?

What will be an ideal response?

An IS lock on the table (and an S lock on the tuples returned)

Computer Science & Information Technology

You might also like to view...

The place where VBA programming code is stored when you record a macro is called a ________

Fill in the blank(s) with correct word

Computer Science & Information Technology

Which of the following is true for a correct producer/consumer relationship with one producer, one consumer, and a 5-cell buffer?

a. The producer can produce when all cells are full. b. The consumer can consume when all cells are full. c. The consumer can consume when all cells are empty. d. None of the above.

Computer Science & Information Technology