The application workload on your database is same between 10 a.m. and 11 a.m. on weekdays. Suddenly you observe poor performance between 10 a.m. and 11 a.m. in the middle of the week. How would you identify the changes in configuration settings， workload 

第1题：

What are three of the fields used in defining a CSQ in IPCC Express Enhanced?（）

• A、WrapUp Time  
• B、Service Level  
• C、Overflow CSQ  
• D、Agent Name  
• E、Automatic Work  
• F、CRS Application

第2题：

You work as an application developer at Certkiller .com. Certkiller .com has asked you to develop an application that monitors and controls the activities of a Windows service.You need to use the appropriate class to meet Certkiller .com’s requirements. What should you do？（）

• A、 Use the ServiceBase class.
• B、 Use the ServiceInstaller class.
• C、 Use the ServiceManager class.
• D、 Use the ServiceController class.

第3题：

第4题：

Company.com has installed HACMP and is configuring a three-node cluster. One of the Applications  uses the AIX hostname as a key for authorization to execute on the specific computer. The application vendor was contacted and consented to having multiple copies of the application but required that only one application be active at any one point in time.  How can the AIX host name dependency be managed in an HACMP environment.（）  

• A、 It cannot be managed because the application will not work properly with HACMP.
• B、 The application start and stop script for the application can manage the hostname.
• C、 HACMP will require customization to correctly manage a change in the hostname since it is tied to the primary network adapter.
• D、 HACMP will have to be restarted if the hostname is changed. This can be done with customization in the node_up and node_down event scripts.

第5题：

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.

第6题：

You work as a database administrator for Supportcenter.cn. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective， which component would you configure on each database server？（）

• A、Database Control
• B、Management Server
• C、Management Repository
• D、Application Server Control
• E、Oracle Management Agent

第7题：

Which of the following is TRUE for the DB2 isolation level Cursor Stability (CS)?（）

• A、An application process acquires at least a share lock on the current row of every cursor.
• B、Any row that is read during a unit of work cannot be changed by other application processes until the unit of work is complete.
• C、Any row changed by another application process can be read, even if the change has not been committed by that application process.
• D、An application process that issues the same query more than once in a unit of work will not see additional rows caused by other application processes appending new information to the database.

第8题：

第9题：

If an application issues the same query more than once in the same Unit of Work, which isolation level will not permit this application to see additional rows inserted by other applications?（）

• A、Read Stability (RS)
• B、Repeatable Read (RR)
• C、Uncommitted Read (UR)
• D、Cursor Stability (CS)

第10题：

A batch application executes a large number of update statements. The service level agreement for the application states that the application must complete its work as quickly as possible to ensure that dependent workloads can start ontime. What is one way to help the application complete quickly?（）

• A、Code the application to issue a LOCK TABLE statement.  
• B、Code the application to issue a LOCK ROW statement.  
• C、Decrease the number of I/O servers.  
• D、Increase the locklist parameter.