单项选择题

A.An application process acquires at least a share lock……

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

单项选择题In which situation is shredding XML data recommended?（）

A.When the data is naturally tabular
B.When the number of nodes are volatile
C.When the data by nature has sparse attributes
D.When the data is of low volume and requires a complex star-schema topology

单项选择题Which of the following is a typical data warehouse query?（）

A.What is this customers address?
B.Does this customer have any unpaid bills?
C.What is the balance in this customers account?
D.What are the total sales for each of the last 6 months?