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? (Choose three.)
A.
SELECT job FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno;
B.
DELETE FROM emp WHERE job=’MANAGER’;
C.
LOCK TABLE emp IN EXCLUSIVE MODE;
D.
LOCK TABLE emp IN SHARE MODE;
E.
INSERT INTO emp(empno,ename) VALUES (1289,’Dick’);