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?()
- A、LOCK TABLE emp IN SHARE MODE;
- B、LOCK TABLE emp IN EXCLUSIVE MODE;
- C、DELETE FROM emp WHERE job=’MANAGER’;
- D、INSERT INTO emp(empno,ename) VALUES (1289,’Dick’);
- E、SELECT job FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno;
正确答案:A,B,E
答案解析:有

微信扫一扫手机做题