Application A currently holds an exclusive lock on a single

第1题：

第2题：

A cluster administrator decides ti implement application monitoring in order to monitor both a web application and its supporting database. The plan is to use a single resource group prod_rg and to configure one monitor method for the web app and one monitor method for the database.  Which of the following statements best describes the need for custom resource monitor？（）  

• A、 Multiple application servers must be in a single resource group.
• B、 Multiple application servers per resource group may be monitored.
• C、 Multiple resource groups must each contain a single application server.
• D、 Multiple application servers in a cluster cannot use process monitoring.

第3题：

第4题：

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.

第5题：

A server needs to have memory added to support a new application. It currently is using PC4200 in a single channel configuration. Which of the following would be the correct memory upgrade？（）

• A、Install larger capacity PC2100 dual channel memory modules.
• B、Add a PCI expansion card with PC2100 single channel memory modules.
• C、Install smaller capacity PC4200 single channel memory modules.
• D、Install larger capacity PC4200 single channel memory modules.

第6题：

写出下列Application对象的集合属性和方法所表示的含义  1.Application_onEnd 2.Application_onStart 3.Lock 4.unLock
1.Application_onEnd应用程序对象结束事件
2.Application_onStart应用程序对象开始事件
3.Lock加锁方法
4.unLock解锁方法
略

第7题：

A SAN attached production file server is required to be backed up nightly according to company  policy.Recently the data to be backed up has increased to approximately 4TB. Currently， the server has a single attached LTO2 tape drive.  Which of the following should the server administrator do to provide enough backup capacity for the nightly job？ （）

• A、 Replace the backup software with a more efficient application.
• B、 Reduce the amount of data to be backed up.
• C、 Replace the LTO2 tape drive with an LTO3 tape drive.
• D、 Replace the single tape drive with a tape library.

第8题：

第9题：

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

第10题：

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.