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

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;



Leave a Reply 0

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