Which of the following will occur?

Application A currently holds an exclusive lock on a single row and application B tries to access that row. If lock timeout is set to -1 and both applications are using isolation level RS, which of the following will occur?
A. Applications A and B will cause a deadlock situation.
B. Application B will read the previous version of the row.
C. Application B will read the row and see uncommitted changes made by application A.
D. Application B will be placed in a lock-wait state until application A releases its lock.

Download Printable PDF. VALID exam to help you PASS.

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.