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 would wait
when issued in SCOTT’s second session? (Choose three.)
A.
SELECTename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno;
B.
INSERT INTOemp(empno,ename) VALUES (1289,’Harry’);
C.
UPDATEemp SET sal=sal*1.2 WHERE job=ANAGER?UPDATE emp SET
sal=sal*1.2 WHERE job=?ANAGER?
D.
LOCK TABLEemp IN SHARE MODE;
E.
LOCK TABLEemp IN EXCLUSIVE MODE;
A,D AND E