单项选择题
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.
相关考题
-
单项选择题
If an application issues the same query more than once in the same Unit of Work, which isolation level will not permit this application to see additional rows inserted by other applications?()
A.Read Stability (RS)
B.Repeatable Read (RR)
C.Uncommitted Read (UR)
D.Cursor Stability (CS) -
单项选择题
Which of the following best describes how locks are used in DB2?()
A.To maintain control of updated rows for commit processing
B.To ensure only committed changes are altered by another application
C.To allow two applications to update the same row of data simultaneously
D.To prevent multiple applications from accessing the same data simultaneously -
单项选择题
Which of the following resources can be explicitly locked?()
A.Row
B.Page
C.Table
D.Column
