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、Decr

题目

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.开始事务，提交事务，回滚事务的英语单词分别是：A.begin transaction , rollback transaction , commit transactionB.commit transaction , rollback transaction , begin transactionC.rollback transaction , begin transaction , commit transactionD.begin transaction , commit transaction , rollback transaction

2.用于提交和回滚事务的语句为（ ）。A.END TRANSACTION和ROLLBACK TRANSACTION B.COMMIT TRANSACTION和ROLLBACK TRANSACTION C.SAVE TRANSACTION和ROLLUP TRANSACTION D.COMMIT TRANSACTION和ROLLUP TRANSACTION

3.A transaction is an action,or a series of actions,carried out by a single user or（ ）,that accesses or changes the contents of the database.A transaction should possess the four basic or so-called ACID properties:Atomicity.The“all or nothing”property.A transaction is an（ ）unit that is either performed in its entirety or is not performed at all.Consistency.A transaction must transform the database from one consistent state to another consistent state.Isolation.Transactions execute independently of one another.In other words,the partial effects of（ ）transactions should not be visible to other transactions.Durability.The effects of a successfully completed（committed）transaction are permanently recorded in the database and must not be lost because of a subsequent failure.The four properties above,only（请作答此空）property is the responsibility of the concurrency control subsystem to ensure.It is the responsibility of both the（ ）and the application developers to ensure consistency.To guarantee the Atomicity and Durability properties after a failure,a log file is needed.A.atomicity B.consistency C.isolation D.durability

4.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

更多“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、Decr”相关问题

  • 第1题：

    A transaction is an action,or a series of actions,carried out by a single user or（请作答此空）,that accesses or changes the contents of the database.A transaction should possess the four basic or so-called ACID properties:Atomicity.The“all or nothing”property.A transaction is an（ ）unit that is either performed in its entirety or is not performed at all.Consistency.A transaction must transform the database from one consistent state to another consistent state.Isolation.Transactions execute independently of one another.In other words,the partial effects of（ ）transactions should not be visible to other transactions.Durability.The effects of a successfully completed（committed）transaction are permanently recorded in the database and must not be lost because of a subsequent failure.The four properties above,only（ ）property is the responsibility of the concurrency control subsystem to ensure.It is the responsibility of both the（ ）and the application developers to ensure consistency.To guarantee the Atomicity and Durability properties after a failure,a log file is needed.

    A.application developer
    B.all users
    C.application program
    D.DBMS

    答案：C
    解析：

  • 第2题：

    In one of your online transaction processing （OLTP） applications， most users frequently modify the values， including the key values， of the application tables. Some users generate application reports by using multiple application tables.  What is the best table structure that you can use to gain optimal performance？（）

    • A、heap table
    • B、object table
    • C、external table
    • D、clustered table
    • E、global temporary table
    • F、index­organized table （IOT）

    正确答案:A

  • 第3题：

    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

  • 第4题：

    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.

    正确答案:A

  • 第5题：

    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.

    正确答案:B,D

  • 第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.

    正确答案:B

  • 第7题：

    You are designing an upgrade strategy for a Windows Azure application that includes one web role with one instance.  You have the following requirements：   - Test the application on the Windows Azure platform.   - Ensure that application upgrades can be rolled back.   - Ensure that upgrade and rollback processes do not cause downtime.    You need to recommend an approach for upgrading the application.  What should you recommend？（）

    • A、 Deploy to the Production slot.  Test the application， and then perform a VIP swap.
    • B、 Deploy to the Staging slot.  Test the application， and then perform a VIP swap.
    • C、 Deploy to the Staging slot.  Test the application， and then perform a manual in-place upgrade to the Production slot.
    • D、 Deploy to the Staging slotTest the application， and then perform an automatic in-place upgrade to the Production slot.

    正确答案:B

  • 第8题：

    多选题
    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.


    正确答案： C,B
    解析： 暂无解析

  • 第9题：

    多选题
    You are a systems administrator responsible for managing a Windows Server 2008 Web Server Currently，there are no Web sites configured on the server. You need to configure the server to host two Web applications： Engineering App and Sales App. Both Web applications must be accessible by using HTTPport 80 without the use of host headers. Also， you must protect against problems in one Web applicationaffecting the performance or reliability of the other Web application. Which two steps should you take tomeet these requirements？（）
    A

    Create a single Web site that contains both Web applications.

    B

    Create two Web sites， one for each Web application.

    C

    Assign both Web applications to the same application pool.

    D

    Assign each Web application to its own application pool.


    正确答案： B,D
    解析： 暂无解析

  • 第10题：

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

    B

     execute the ROLLBACK command with transaction number

    C

     flashback the database to before the transaction was committed

    D

     determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery


    正确答案： C
    解析： 暂无解析

  • 第11题：

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


    正确答案： C
    解析： 暂无解析

  • 第12题：

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


    正确答案： C
    解析： 暂无解析

  • 第13题：

    A transaction is an action,or a series of actions,carried out by a single user or（ ）,that accesses or changes the contents of the database.A transaction should possess the four basic or so-called ACID properties:Atomicity.The“all or nothing”property.A transaction is an（ ）unit that is either performed in its entirety or is not performed at all.Consistency.A transaction must transform the database from one consistent state to another consistent state.Isolation.Transactions execute independently of one another.In other words,the partial effects of（ ）transactions should not be visible to other transactions.Durability.The effects of a successfully completed（committed）transaction are permanently recorded in the database and must not be lost because of a subsequent failure.The four properties above,only（ ）property is the responsibility of the concurrency control subsystem to ensure.It is the responsibility of both the（请作答此空）and the application developers to ensure consistency.To guarantee the Atomicity and Durability properties after a failure,a log file is needed.

    A.DBMS
    B.DBA
    C.end user
    D.DBS

    答案：A
    解析：

  • 第14题：

    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

  • 第15题：

    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.

    正确答案:B

  • 第16题：

    What does the command show compare rollback 1 display?（）

    • A、the difference between the current candidate configuration and the candidate configuration from one commit ago
    • B、the difference between the current active configuration and the current candidate configuration
    • C、the difference between the current active configuration and the active configuration from one commit ago
    • D、the difference between the current candidate configuration and the archived configuration from one commit ago

    正确答案:D

  • 第17题：

    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 recovery
    • B、execute the ROLLBACK command with transaction number
    • C、flashback the database to before the transaction was committed
    • D、determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery

    正确答案:D

  • 第18题：

    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.

    正确答案:B

  • 第19题：

    A customer needs to install a database on a server.  Which of the following statements describes how to modify the RAID configuration for optimal performance？（）

    • A、Place both the database and transaction log on two logical drives in one RAID-10 array
    • B、Place both the database and transaction log on two logical drives in one RAID-1E array
    • C、Place the database on a RAID-1E array and place the transaction log on a separate RAID-5 array
    • D、Place the database on a RAID-5 array and place the transaction log on a separate RAID-1E array

    正确答案:D

  • 第20题：

    单选题
    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
    解析： 暂无解析

  • 第21题：

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


    正确答案： A
    解析： 暂无解析

  • 第22题：

    单选题
    Your alert log file has the following information： Tue May 25 17：43： 38 2004  ORA-00060： Deadlock detected. More info in file /u01/app/oracle/admin/ORCL/udump/orcl_ora_3173.trc.  What would you do to ensure that database is still running correctly？（）
    A

    examine the trace file and kill the session that caused the deadlock

    B

    examine the trace file and kill both the sessions responsible for the deadlock

    C

    examine the trace file for details and ask the user who caused the deadlock to rollback the transaction

    D

    examine the trace file for details and remember that deadlocks are resolved automatically by Oracle database

    E

    examine the trace file for details and use the Undo Advisor to rollback the transaction that caused the deadlock


    正确答案： A
    解析： 暂无解析

  • 第23题：

    单选题
    In one of your online transaction processing （OLTP） applications， most users frequently modify the values， including the key values， of the application tables. Some users generate application reports by using multiple application tables.  What is the best table structure that you can use to gain optimal performance？（）
    A

    heap table

    B

    object table

    C

    external table

    D

    clustered table

    E

    global temporary table

    F

    index­organized table （IOT）


    正确答案： A
    解析： 暂无解析

相关内容