User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK， or any data definition language （DDL） command： SQL> SELECT ename FROM emp 2 WHERE job=’CLERK’ FOR UPDATE OF empno； SCOTT has opened another session to work with the database instance. Which three operations wouldwait when issued in SCOTT’s second session（） A:LOCK TABLE emp IN SHARE MODE； B:LOCK TABLE emp IN EXCLUSIVE MODE； C:UPDATE emp SET sal=sal*1.2 WHERE job=MANAGER； D:INSERT INTO emp（empno，ename） VALUES （1289，’Harry’）； E:SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno；

User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK， or any data definition language （DDL） command： SQL> SELECT ename FROM emp 2 WHERE job=’CLERK’ FOR UPDATE OF empno； SCOTT has opened another session to work with the database instance. Which three operations wouldwait when issued in SCOTT’s second session（）
A:LOCK TABLE emp IN SHARE MODE；
B:LOCK TABLE emp IN EXCLUSIVE MODE；
C:UPDATE emp SET sal=sal*1.2 WHERE job=MANAGER；
D:INSERT INTO emp（empno，ename） VALUES （1289，’Harry’）；
E:SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno；

出自：Oracle认证

提示：
同一【IP】的非会员用户每天可免费获取10次答案

本站试题总数:【10143087】个 (题库试题定时更新)