单选题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 delet

题目
单选题
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.

如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

oracle数据库中下列哪个等待事件显示行级锁竞争?()

  • A、latch:shared pool
  • B、cursor:pin S waiton X
  • C、enq:TX-row lock contention
  • D、dbfile scattered read

正确答案:C

第2题:

Which of the following will help protect an operating system from vulnerability?()

  • A、Download free anti-virus programs from the Internet.
  • B、Perform updates from the manufacturers website regularly.
  • C、Using the operating systems email program only to open attachments.
  • D、Monitoring what is displayed on the screen.

正确答案:B

第3题:

Consider the following:Which statement best describes the meaning of the value for the key_len column?()

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


参考答案:D

第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?()

  • A、SSL
  • B、PGP
  • C、File encryption program
  • D、Public key encryption

正确答案:A

第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题:

Which of these best describes the actions taken when a VTP message is received on a switch configuredwith the VTP mode "transparent"?()

  • A、VTP updates are ignored and forwarded out all ports.
  • B、VTP updates are ignored and forwarded out trunks only.
  • C、VTP updates are made to the VLAN database and are forwarded out trunks only.
  • D、VTP updates are ignored and are not forwarded.

正确答案:B

第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?()

  • 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

正确答案:D

第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


参考答案:D

第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题:

Which of the following best describes how locks are used in DB2?()

  • A、To maintain control of updated rows for commit processing
  • B、To ensure only committed changes are altered by another application
  • C、To allow two applications to update the same row of data simultaneously
  • D、To prevent multiple applications from accessing the same data simultaneously

正确答案:B

更多相关问题