单项选择题 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?()
单项选择题 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=A00Application 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?()
单项选择题 Which of the following is TRUE for the DB2 isolation level Cursor Stability (CS)?()