问题详情

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 wouldwait when issued in SCOTT’s second session()


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;

时间:2022-01-05 13:28 关键词: 1Z0-052

答案解析

A| B| E
相关问题