【新题】OCP 12c 062认证考试出现大量新题-5
最新学讯：近期OCP认证正在报名中，因考试人员较多请尽快报名获取最近考试时间，报名费用请联系在线老师，甲骨文官方认证，报名从速！
我要咨询2018年的时候，OCP 11g考试题库大更新，052 053出现了很多新题，
2019年，11g即将停考的前期，Oracle又出现了一次大变动，12c出现了很多新题，比如062 063题库大更新
OCP解析公开课时间：【每周五晚8点】
OCP解析公开课地址：http://ke.qq.com/course/326223
OCP解析群资料分享：1015267481 验证：ocp
-------------------------------------------------------
5.One of your databases supports an OLTP workload.
The default undo tablespace is fixed size with:
1. RETENTION NOGUARANTEE
2. undo_retention is 12 minutes
User scott get this error after a query on the sales table has run for more than 15 minutes:
ORA-01555: snapshot too old
Which three factors taken separately or in some combination might be the cause?
A) A committed delete to the sales table was made more than 12 minutes before the query began.
B) An uncommitted delete to the sales table was made more than 12 minutes before the query began.
C) A committed update to the sales table was made more than 12 minutes before the query began.
D) An uncommitted update to the sales table was made more than 12 minutes before the query began.
E) An update was made to the sales table before the query began.
F) An update to the SALES table was committed after the query began.
G) An update was made to the sales table after the query began.
Answer：ACF
(解析：题目的意思是：哪三个因素单独或结合在一起可能是原因?快照太老是因为一个长时间运行的查询语句，所要查询的对象在 undo 段找不到而产生的，找不到的原因是事务已经提交了，原来使用的 undo 段被覆盖。)
