Application B will read the row.
Applications A and B will cause a deadlock situation.
Application B will wait until application A releases the Update lock.
Application A will be terminated so that application B can read the row.
第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?()
第2题:
Which of the following is TRUE for the DB2 isolation level Cursor Stability (CS)?()
第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?()
第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?()
第5题:
Which of the following functions is provided by the LPAR Validation Tool (LVT)?()
第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?()
第7题:
Which of the following best describes the lock protection provided by DB2 for the current row of a cursor?()
第8题:
An administrator is in charge of a server that houses various applications. Which of the following BEST explains this server type?()
第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?()
第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?()