单项选择题

A.Rollback the transaction in both applications.B.Rollb……

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

单项选择题Given table T1 has column I1 containing the following data: I1 1 2 3 4 If the following sequence of SQL statements is applied within a single unit of work: UPDATE t1 SET i1 = 3 WHERE i1 = 2; S AVEPOINT s1 ON ROLLBACK RETAIN CURSORS; UPDATE t1 SET i1 = 5 WHERE i1 = 3; SAVEPOINT s2 ON ROLLBACK RETAIN CURSORS;INSERT INTO t1 (i1) VALUES (6); ROLLBACK TO SAVEPOINT s1; UPDATE t1 SET i1 = 2 WHERE i1 = 4; COMMIT; What is the expected sequence of values returned from?（） SELECT i1 FROM t1 ORDER BY i1

A. 1, 2, 3, 3
B. 1, 2, 2, 4
C. 1, 2, 3, 3, 6
D. 1, 2, 2, 5, 6

单项选择题Given the following two tables: TAB1 C1 C2 1 Antarctica 2 Africa 3 Asia 4 Australia TAB2 CX CY 5 Europe 6 North America 7 South America Which of the following SQL statements will insert all rows found in table TAB2 into table TAB1?（）

A.INSERT INTO tab1 SELECT cx, cy FROM tab2
B.INSERT INTO tab1 VALUES (tab2.cx, tab2.cy)
C.INSERT INTO tab1 VALUES (SELECT cx, cy FROM tab2)
D.INSERT INTO tab1 (c1, c2) VALUES (SELECT cx, cy FROM tab2)