If DB2 detects a deadlock between application A and applicat

题目
单选题
If DB2 detects a deadlock between application A and application B (each waiting for a lock held by the other one), what action will DB2 take?()
A

Rollback the transaction in both applications.

B

Rollback the transaction in one of the two applications.

C

Decrease the lock timeout value for both applications, thereby causing a lock timeout situation.

D

Send a message to let the administrator know of the situation and decide which application or applications should be terminated.

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

第1题:

Which product must be installed on z/OS to allow a COBOL program running on that machine to access data on a remote DB2 for z/OS server?()

A.DB2 for z/OS

B.DB2 Run-Time Client for z/OS

C.DB2 Connect Enterprise Edition for z/OS

D.z/OS Application Connectivity to DB2 for z/OS and OS/390


参考答案:A

第2题:

What is meant by the term "firewall sandwich"?()

  • A、multiple layers of firewalling
  • B、a method of operating firewalls from multiple vendors
  • C、firewall connections in either an active or standby state
  • D、an architecture in which all traffic between firewalls goes through application-specific servers
  • E、an architecture in which all traffic between firewalls goes through application-specific gateways

正确答案:A

第3题:

Acts as an interface between computer hardware and users()。

A.Operating system

B.Application software

C.USB

D.MODEM


正确答案:A

第4题:

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

第5题:

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

第6题:

Which CRS Subsystem handles connections between the Application Server and the Enterprise Databases?()

  • A、Media
  • B、JTAPI
  • C、Database
  • D、Application

正确答案:C

第7题:

Which tool must be used to analyze all of the database operations performed by an application against a DB2 for i5/OS database?()

  • A、Visual Explain
  • B、Activity Monitor
  • C、SQL Performance Monitor
  • D、DB2 Performance Monitor

正确答案:C

第8题:

An application needs to store a 5 MB JPEG image in a DB2 table. Which data type should be specified for the column that will be used for storing the image?()

A.GRAPHIC

B.BINARY

C.IMAGE

D.BLOB


参考答案:D

第9题:

Which ONE of the following statements about Domino Enterprise server is true?()

  • A、Can host Active Server Pages Web sites
  • B、Can host PHP Web sites
  • C、Includes a DB2 server
  • D、Includes an integrated Web application server

正确答案:D

第10题:

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

更多相关问题