单项选择题
A.MQT
B.Trigger
C.Read Only Cursor
D.Stored Procedure
单项选择题 To which of the following resources can a lock be applied?()
单项选择题 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?()