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 job FROM emp 2 WHERE job=’CLERK’ FOR UPDATE OF empno SCOTT has opened another session to work with the database. Which three operations would wait when issued in SCOTT’s second session？（）A.LOCK TABLE emp IN SHARE MODEB.LOCK TABLE emp IN EXCLUSIVE MODEC.DELETE FROM emp WHERE job=’MANAGER’D.INSERT INTO emp（empno，ename） VALUES （1289，’Dick’）E.SELECT job 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 job FROM emp
2 WHERE job=’CLERK’ FOR UPDATE OF empno;
SCOTT has opened another session to work with the database. Which three operations would wait when issued in SCOTT’s second session？（）

A.LOCK TABLE emp IN SHARE MODE;
B.LOCK TABLE emp IN EXCLUSIVE MODE;
C.DELETE FROM emp WHERE job=’MANAGER’;
D.INSERT INTO emp（empno，ename） VALUES （1289，’Dick’）;
E.SELECT job FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno;

1Z0-042