單項(xiàng)選擇題

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

你可能感興趣的試題

單項(xiàng)選擇題

How does DB2 protect the integrity of indexes when data is updated?（）

A.Locks are acquired on the data.
B.Locks are acquired on index keys.
C.Locks are acquired on index pages.
D.Locks are acquired on index pointers.

單項(xiàng)選擇題

If DB2 detects a deadlock between application A and application B (each waiting for a lock held by the other one), what action will DB2 take?（）

A.Rollback the transaction in both applications.
B.Rollback the transaction in one of the two applications.
C.Decrease the lock timeout value for both applications, thereby causing a lock timeout situation.
D.Send a message to let the administrator know of the situation and decide which application or applications should be terminated.

无码高清视频|成人自拍视频|欧美成人午夜无码A片秀色直播|草美女视频网站|美女被操网站在线观看

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?（）

你可能感興趣的試題

How does DB2 protect the integrity of indexes when data is updated?（）

If DB2 detects a deadlock between application A and application B (each waiting for a lock held by the other one), what action will DB2 take?（）