In order to determine how efficiently an application is read

第1题：

During a planning meeting， Company.com indicates that they intend to make a relational  Database highly available. The application has a pre-requisite that a kernel extension be loaded from /etc/inittab.  How would this be managed in an HACMP environment？（）  

• A、 It can be started with a crontab entry.
• B、 It can be created as an Application Server.
• C、 It can be added to a resource group as a dependency.
• D、 It cannot be done because HACMP provides no method to order application start/stop scripts.

第2题：

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

第3题：

第4题：

In order to determine how efficiently an application is reading and writing data， which of the following utilities will report read and write sizes on disk I/O requests？（）

• A、 tprof
• B、 iostat
• C、 svmon
• D、 filemon

第5题：

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.

第6题：

In order to ensure best read performance， which of the following indicates how large an application’s read buffer size should be if the filesystem to be read is striped across N disks using LVM striping？（）

• A、 N times the stripe unit size
• B、 N times the VMM minfree parameter
• C、 The same value as that of the VMM maxfree parameter
• D、 The same value as that of  the VMM maxrndwrt parameter

第7题：

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)

第8题：

第9题：

A manufacturer is deploying a custom application to serve their customers.  The application is written to take advantage of multithreading features and run in a Windows environment.  To determine the processor family that will run the application most efficiently， which TWO questions will provide the required information？（）

• A、What is the application’s maximum processor scaling capability？
• B、Will the application run faster with Microsoft OLTP technology？
• C、Will the application benefit from larger disk cache and swap space？
• D、Can the application use Hot Swap Processor， Memory， and PCI-X technology？
• E、Is the application able to run in a 32 bit， 64 bit， or mixed environment？

第10题：

To enhance the availability of an application running under HACMP， a decision was made to use  The application monitoring facility. The application consists of several components and can take several minutes to initialize. The components use socket communication and can be initialized in any order as long as it is a serial order. The customer’s concern is that if the application stop and start scripts are used during application monitoring recovery，it may take an extraordinary length of time to reset all of the application components.  What can be done to ensure the best recover time？（）   

• A、 Use a process monitor that restarts the named processes in the original start order.
• B、 Use the defined application start and stop scripts to control the application if there is a failure.
• C、 Use multiple application monitors for this resource group to enable the monitoring of the specific components of the resource group.
• D、 Use application cleanup and restart scripts designed to determine the state of the various components of the application and start only the parts required.