Which three operations would wait when issued in SCOTT’s second session?

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.)

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’);



Leave a Reply 0

Your email address will not be published. Required fields are marked *