black

IBM(000-730)

登录

单项选择题

Which object may be used during query optimization to improve the performance for a subset of SELECT queries?()

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?()

All Rights Reserved 版权所有©建筑考试题库(jzkao.com)

备案号:湘ICP备2020024380号-3