ITAA-OCM 发表于 2012-2-15 15:23:54

Oracle OCP试题解析（33）

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 WHERE job='CLERK' FOR UPDATE OF empno;SCOTT has opened another session to work with the database. Which three operations would wait whenissued in SCOTT's second session? (Choose three.) 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;Answer: A,B,ESELECT … FROM … FOR UPDATE语句会申请相应行的排他锁以及行所在表的共享锁。

haobo1990321 发表于 2012-2-29 12:13:30

{:6_267:}

jiazl88 发表于 2012-7-17 16:41:54

{:6_267:}

冰蓝静轩 发表于 2012-8-10 13:58:38

为了学习，努力赚钱。

再辛苦也值得。努力，加油

{:6_267:}

zhuolin119 发表于 2012-12-8 22:37:38

{:6_272:}
页: [1]
查看完整版本: Oracle OCP试题解析（33）