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;
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=ANAGER?UPDATE emp SET sal=sal*1.2
WHERE job=?ANAGER?
D.INSERT INTO emp(empno,ename) VALUES (1289,'Harry');
E.SELECT ename FROM empWHERE job='CLERK' FOR UPDATE OF empno;
Correct Answers: A B E
用户一个会话在做DML操作且未提交,其它会话不能对同一张表做什么?
A: 正确,其它会话不允许SHARE MODE锁定表
B: 正确,其它会话不允许EXCLUSIVE MODE锁定表
C: 错误,在同一个表中更新不同的行,锁不会有冲突
D: 错误,插入数据,锁不会有冲突
E: 正确,在同一个表中更新想同的行,锁会有冲突