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

查看答案

考题用于提交和回滚事务的语句为（）。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

查看答案

考题 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.

查看答案

考题 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.

查看答案

考题 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.

查看答案

考题 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.

查看答案

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

查看答案

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

查看答案

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

查看答案

考题单选题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）

查看答案

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

查看答案

网友您好， 请在下方输入框内输入要搜索的题目：

网友您好，请在下方输入框内输入要搜索的题目：