网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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.
参考答案
更多 “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.” 相关考题
考题
开始事务，提交事务，回滚事务的英语单词分别是：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
考题
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
考题
用于提交和回滚事务的语句为（ ）。A.END TRANSACTION和ROLLBACK TRANSACTION
B.COMMIT TRANSACTION和ROLLBACK TRANSACTION
C.SAVE TRANSACTION和ROLLUP TRANSACTION
D.COMMIT TRANSACTION和ROLLUP TRANSACTION
考题
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
考题
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
考题
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
考题
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 tableB、object tableC、external tableD、clustered tableE、global temporary tableF、indexorganized table （IOT）
考题
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 situationB、Application B will read the previous version of the rowC、Application B will read the row and see uncommitted changes made by application AD、Application B will be placed in a lock-wait state until application A releases its lock
考题
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.
考题
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.
考题
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.
考题
What does the command show compare rollback 1 display?（）A、the difference between the current candidate configuration and the candidate configuration from one commit agoB、the difference between the current active configuration and the current candidate configurationC、the difference between the current active configuration and the active configuration from one commit agoD、the difference between the current candidate configuration and the archived configuration from one commit ago
考题
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.
考题
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
考题
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.
考题
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.
考题
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.
考题
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 arrayB、Place both the database and transaction log on two logical drives in one RAID-1E arrayC、Place the database on a RAID-1E array and place the transaction log on a separate RAID-5 arrayD、Place the database on a RAID-5 array and place the transaction log on a separate RAID-1E array
考题
多选题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（）AThe session is terminated after receiving the error and JIM can continue with his transaction.BSCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.CThe session is rolled back after receiving the error and JIM can continue with his transaction.DSCOTT has to reexecute the last command in the transaction after he commits the transaction.
考题
单选题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 situationB
Application B will read the previous version of the rowC
Application B will read the row and see uncommitted changes made by application AD
Application B will be placed in a lock-wait state until application A releases its lock
考题
多选题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？（）ACreate a single Web site that contains both Web applications.BCreate two Web sites， one for each Web application.CAssign both Web applications to the same application pool.DAssign each Web application to its own application pool.
考题
单选题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.
考题
单选题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
考题
单选题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 deadlockB
examine the trace file and kill both the sessions responsible for the deadlockC
examine the trace file for details and ask the user who caused the deadlock to rollback the transactionD
examine the trace file for details and remember that deadlocks are resolved automatically by Oracle databaseE
examine the trace file for details and use the Undo Advisor to rollback the transaction that caused the deadlock
考题
单选题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.
考题
单选题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 tableB
object tableC
external tableD
clustered tableE
global temporary tableF
indexorganized table （IOT）
考题
单选题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.
热门标签
最新试卷
