The cursor is only protected from updates and deletes by concurrent applications.
The row is only protected from positioned updates and deletes that reference another cursor of the same application.
The cursor is protected from positioned updates and deletes that reference another cursor of a different application.
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.
第1题:
oracle数据库中下列哪个等待事件显示行级锁竞争?()
第2题:
Which of the following will help protect an operating system from vulnerability?()
第3题:
A.It shows the total size of the index row
B.It shows how many columns in the index are examined
C.It shows the number of characters indexed in the key
D.It shows how many bytes will be used from each index row
第4题:
A customer wants to have employees work from remote locations as well as in the office. All communications must be secure and files must be protected from access by unauthorized people. The employee’s applications (database inserts and reads) are only accessed with a web browser. Which of the following capabilities is necessary?()
第5题:
Which of the following is TRUE for the DB2 isolation level Cursor Stability (CS)?()
第6题:
Which of these best describes the actions taken when a VTP message is received on a switch configuredwith the VTP mode "transparent"?()
第7题:
The opening of cursor CSR01 produces the following result set: STUDENT LASTNM FIRSTNM CLASSNO 123 Brown John T100 213 Bailey James T100 312 Carter Arlene T210 465 Chas Devon T305 546 Davis Steven T405 If this Fetch statement is executed: FETCH csr01 INTO :studnum, :firstname, :lastname, :class Which of the following DELETE statements will cause this row to be deleted?()
第8题:
The opening of cursor CSR01 produces the following result set:STUDENT LASTNM FIRSTNM CLASSNO 123 Brown John T100 213 Bailey JamesT100 312 Carter Arlene T210 465 Chas Devon T305 546 Davis Steven T405If this Fetch statement is executed: FETCH csr01 INTO :studnum, :firstname, :lastname, :class Which of the following DELETE statements will cause this row to be deleted?()
A.DELETE ALL FROM tab01 FOR CURRENT OF csr01
B.DELETE FROM tab01 FOR CURRENT csr01 WITH RS
C.DELETE * FROM tab01 WHERE CURRENT csr01 WITH CS
D.DELETE FROM tab01 WHERE CURRENT OF csr01 WITH RR
第9题:
Which of the following best describes the lock protection provided by DB2 for the current row of a cursor?()
第10题:
Which of the following best describes how locks are used in DB2?()