单项选择题
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 use...
单项选择题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 lock...
单项选择题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 d...
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
