PrepAway - Latest Free Exam Questions & Answers

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?

PrepAway - Latest Free Exam Questions & Answers

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 applicationA releases its lock.

One Comment on “which of the following will occur?


Leave a Reply