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.
LOCK TABLE emp IN SHARE MODE;

B.
LOCK TABLE emp IN EXCLUSIVE MODE;

C.
UPDATE emp SET sal=sal*1.2 WHERE job=’MANAGER’

D.
INSERT INTO emp(empno,ename) VALUES (1289,’Harry’);

E.
SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno;



Leave a Reply 3

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


Francesco

Francesco

i can’t lock table in share mode?

For update lock record affected in exclusive mode and table in share mode.
is true?

X-RAY

X-RAY

S lock doesn’t need to wait for a RS lock, right?

diana

diana

Why ‘E’?