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

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

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.

第3题：

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.

第4题：

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)

第5题：

Which of the following functions is provided by the LPAR Validation Tool （LVT）？（）

• A、LPAR creation
• B、Proper card placement
• C、Application compatibility assistance
• D、Response time for applications

第6题：

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

第7题：

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.

第8题：

An administrator is in charge of a server that houses various applications. Which of the following BEST explains this server type？（）

• A、Dedicated Application Server
• B、File Server
• C、Shared Application Server
• D、Peer-to-Peer Application Server

第9题：

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.

第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.