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题:
第2题:
Which of the following is NOT a way in which Custom Controls can be used?()
第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?()
第5题:
Which of the following is TRUE for the DB2 isolation level Cursor Stability (CS)?()
第6题:
oracle数据库中下列哪个等待事件显示行级锁竞争?()
第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?()
第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?()
第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?()