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

第1题：

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

第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题：

When your WebLogic Server solution needs to be scaled out with additional capacity and you  Don’t want to add additional hardware, which three techniques should you us?（）

• A、Assign more than one managed server to a physical hardware that allows better CPU  utilization
• B、Assign more than one application to one managed server to better utilize threads within a single JVM process
• C、Assign the same application to more than one managed server to load balance requests  between servers
• D、Assign the same heap size to the managed server across the cluster for easier control of  memory footprint  
• E、Create a virtualized environment with hypervisor for an easier solution

第4题：

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.

第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题：

SQL2提供事务的四种隔离级别，其中最高级别是（）

• A、SERIALIZABLE
• B、REPEATABLE READ
• C、READ COMMITTED
• D、READ UNCOMMITTED

第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题：

You use Microsoft .NET Framework 4 to create a custom Windows Presentation Foundation (WPF) application. Your environment includes several WPF applications. The applications use the same logo and style configuration as part of a corporate standard. You need to ensure that the existing applications can be updated to use the same logo and style settings without recompiling. Which two actions should you perform?（）

• A、 Mark the resource as an embedded resource in each application. 
• B、 Create a resource in an XAML file that contains the logo and style configurations.
• C、 Create a resource in a custom control that contains the logo and style configurations.
• D、 Add the resource as a ResourceDictionary in the MergedDictionaries collection of each application.
• E、 Use ResourceManager to read the content of the resource. Manually assign the style configurations included in the resource file to the appropriate control in each application.

第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 common approach to solve application performance issues is to add more hardware. Which two  reasons describe why this alone does not always solve performance problems?（）

• A、There may be a bottleneck in the application that additional hardware would not solve.
• B、Adding more hardware is costly and time consuming.
• C、Adding hardware at the application layer may place additional load on an already overloaded database, network appliance, or storage system.
• D、Adding more hardware may introduce new configuration requirements that need to be tested.