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

题目

单选题

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?（）

Rollback the transaction in both applications.

Rollback the transaction in one of the two applications.

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

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

参考答案和解析

正确答案： A

解析：暂无解析

更多“单选题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 D”相关问题

第1题

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.

点击查看答案
第2题

Application A is designed to execute the following SQL statements within a single Unit of Work (UOW). UPDATE employee SET salary = salary * 1.1 WHERE empno='000010' UPDATE department SET deptname = 'NEW dept' WHERE deptno='A00'Application B is designed to execute the following SQL statements within a single Unit of Work (UOW). UPDATE department SET deptname = 'OLD DEPT' WHERE deptno='A00' UPDATE employee SET salary = salary * 0.5 WHERE empno='000010' Application A and application B execute their first SQL statement at the same time. When application A and application B try to execute their second SQL statement, a deadlock occurs. What will happen?（） A、The database manager will rollback the transaction in both applications.B、The database manager will rollback the transaction in one of the two applications.C、Application B will successfully update the EMPLOYEE and DEPARTMENT tables; Application A will be placed in a lock wait state.D、Application A will successfully update the EMPLOYEE and DEPARTMENT tables; Application B will terminate when the lock timeout value is reached.

点击查看答案
第3题

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.

点击查看答案
第4题

The session of user SCOTT receives the following error after executing an UPDATE command onthe EMP table： ERROR at line 1： ORA-00060： deadlock detected while waiting for resource On investigation， you find that a session opened by user JIM has a transaction that caused the deadlock. two statements are true regarding the session of SCOTT in this scenario（）A、The session is terminated after receiving the error and JIM can continue with his transaction.B、SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.C、The session is rolled back after receiving the error and JIM can continue with his transaction.D、SCOTT has to reexecute the last command in the transaction after he commits the transaction.

点击查看答案
第5题

Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?（）A、point-in-time recoveryB、execute the ROLLBACK command with transaction numberC、flashback the database to before the transaction was committedD、determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery

点击查看答案
第6题

You work as an application developer at Certkiller .com. Certkiller .com has been contracted to develop an application for the local bank.You have been given the responsibility of creating this application and need to store each transaction record， which is identified using a complex transaction identifier，in memory. The bank informs you that the total amount of transaction records could reach 200 per day. To achieve this， you decide to utilize one of the existing collection classes in the .NET 2.0 class library. You need to ensure that you the collection class you select is the most efficient one for storing transaction records.What should you do？（）A、 Select the ListDictionary collection class.B、 Select the HashTable collection class.C、 Select the Queue collection class.D、 Select the StringCollection collection class.

点击查看答案
第7题

You need to design the Service Broker queues that will be used to submit requests for long-running reports. Your solution must minimize complexity of using the queues by applications. What should you do?（）A、Specify one queue for each client application that can submit report requests.B、Specify one queue for each of the two report-generation services.C、Specify one queue for all long-running report requests.D、Specify eight queues：One for each service， and one for each client application.

点击查看答案

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

题目

参考答案和解析

更多“单选题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 D”相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容