单项选择题
Which of the following is TRUE for the DB2 isolation level Cursor Stability (CS)?（）
A.An application process acquires at least a share lock on the current row of every cursor.
B.Any row that is read during a unit of work cannot be changed by other application processes until the unit of work is complete.
C.Any row changed by another application process can be read, even if the change has not been committed by that application process.
D.An application process that issues the same query more than once in a unit of work will not see additional rows caused by other application processes appending new information to the database.
相关考题
-
单项选择题
Which of the following best describes the lock protection provided by DB2 for the current row of a cursor?（）
A.The cursor is only protected from updates and deletes by concurrent applications.
B.The row is only protected from positioned updates and deletes that reference another cursor of the same application.
C.The cursor is protected from positioned updates and deletes that reference another cursor of a different application.
D.The row is protected from updates and deletes by the current application and from positioned updates and deletes that reference another cursor of the same application. -
单项选择题
Which of the following resources can be referenced in the LOCK statement?（）
A.Row
B.Table
C.Column
D.Table space -
单项选择题
Which of the following tools for DB2 V9 allows a user to create and debug a SQL stored procedure?（）
A.Control Center
B.Development Center
C.Developer Workbench
D.Stored Procedure Builder
