【2019】OCP考试062题库近期考试原题解析-第53题
最新学讯：近期OCP认证正在报名中，因考试人员较多请尽快报名获取最近考试时间，报名费用请联系在线老师，甲骨文官方认证，报名从速！
我要咨询2018年的时候，OCP 11g考试题库大更新，052 053出现了很多新题，
2019年，11g即将停考的前期，Oracle又出现了一次大变动，12c出现了很多新题，比如062 063题库大更新
OCP解析公开课时间：【每周五晚8点】
OCP解析公开课地址：http://ke.qq.com/course/326223
OCP解析群资料分享：1015267481 验证：ocp
-------------------------------------------------------
53题、choose two
The HR user executes the following query on the EMPLOYEES table but does not issue COMMIT, ROLLBACK, or any data definition language (DDL) command after that:
SQL> SELECT job
FROM employees
WHERE job='CLERK' FOR UPDATE OF empno;
HR then opens a second session.
Which two operations wait when executed in HR'S second session?
A) SELECT job FROM employees WHERE job='CLERK' FOR UPDATE OF empno;
B) INSERT INTO employees(empno,ename,job) VALUES (2001,'Harry','CLERK');
C) SELECT empno,ename FROM employees WHERE job='CLERK';
D) INSERT INTO employees(empno,ename) VALUES (1289,'Dick');
E) LOCK TABLE employees IN EXCLUSIVE MODE;
Answer：AE
(解析：因为查询中用到了for update of，那么被查询到的行会被加锁，所以A答案会造成等待，E答案因为要锁整个表，所以也要发生等待。)
