（609）Examine the following commands and their output:

select ename, sal from emp where ename = 'JAMES'

ENAME SAL

----- ------

JAMES 1050

update emp set sal = sal + sal * 1.2 where ename = 'JAMES';

select ename, sal from emp where ename = 'JAMES'

ENAME SAL

----- ------

JAMES 2310

View the exhibit and examine the Flashback Version Query that was executed after the preceding commands.

What could be the possible cause for the query not displaying any row?

A. Flashback logging is not enabled for the database.

B. The changes made to the table are not committed.

C. Supplemental logging is not enabled for the database.

D. The database is not configured in ARCHIVELOG mode.

答案：（B）

解析：

闪回查询找不到该版本的数据，原因在于该事务没有提交，所以就不成为某个能够恢复的版本。

ITPub博客

Oracle 11G OCP 1Z0-053 609