【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答案因為要鎖整個表，所以也要發生等待。)
