IBM(000-730)
单选题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 applic
题目
An application process acquires at least a share lock on the current row of every cursor.
Any row that is read during a unit of work cannot be changed by other application processes until the unit of work is complete.
Any row changed by another application process can be read, even if the change has not been committed by that application process.
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.
参考答案和解析
相似问题和答案
第1题：
B. The content of the work of art is always the true object of aesthetic interest.
C. The content presented without any individuality is not the content of the work of art.
D. The content understood by means of a process of discursive thought is no more than a husk.
第2题：
Which of the following is NOT a way in which Custom Controls can be used？（）
- A、As reusable UI assets
- B、As a way to share some layout
- C、Shared through templates （NTF） just like any other design element
- D、As the runtime for anXPage application
正确答案:D
第3题：
A.InnoDB uses row and table-level locks, but row locks are not escalates
B.InnoDB locks only those rows that are updated
C.InnoDB only uses row locks, not page or table-level locks
D.InnoDB row locks may be escalated to page or table-level locks
E.InnoDB uses row-level or table-level locks depending on the number of rows affected
第4题：
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)
正确答案:B
第5题：
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.
正确答案:A
第6题：
oracle数据库中下列哪个等待事件显示行级锁竞争？（）
- A、latch：shared pool
- B、cursor：pin S waiton X
- C、enq：TX-row lock contention
- D、dbfile scattered read
正确答案:C
第7题：
Application A currently holds an exclusive lock on a single row and application B tries to access that row. If lock timeout is set to -1 and both applications are using isolation level RS, which of the following will occur?（）
- A、Applications A and B will cause a deadlock situation
- B、Application B will read the previous version of the row
- C、Application B will read the row and see uncommitted changes made by application A
- D、Application B will be placed in a lock-wait state until application A releases its lock
正确答案:D
第8题：
A.latch：shared pool
B.cursor：pin S waiton X
C.enq：TX-row lock contention
D.dbfile scattered read
第9题：
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.
正确答案:A
第10题：
Application A holds an Update lock on a single row and application B is trying to read that row. If both applications are using isolation level UR, which of the following will occur?（）
- A、Application B will read the row.
- B、Applications A and B will cause a deadlock situation.
- C、Application B will wait until application A releases the Update lock.
- D、Application A will be terminated so that application B can read the row.
正确答案:A