ocp-276

QUESTION NO: 276
Over the course of a day, a department performed multiple DML statements (inserts, updates, deletes) on
multiple rows of data in multiple tables. The manager would like a report showing the time, table name,
and DML type for all changes that were made. Which Flashback technology would be the best choice to
produce the list?
A. Flashback Drop
B. Flashback Query
C. Flashback Transaction Query
D. Flashback Versions Query
E. Flashback Table
Answer: C
Flashback Transaction Query could provide the data requested in a single query. Option A is an invalid
choice because the table wasn‘t dropped. Option B is incorrect because Flashback Query returns data at
only a specific point in time, not for a range of times. Option D is incorrect because, although it could
produce the data needed for the report, Flashback Versions Query would have to be run for each table
individually. Option E is incorrect because the user does not want to recover the table at all.

---

在一天当中，一个部门执行多表数据的多行的多个DML语句（插入，更新，删除）。经理
希望一份报告显示所做的所有更改的时间，表名和DML类型。 哪一个闪回技术会是产生这些列表的最好的
选择？

C.闪回事务查询

闪回事务查询可提供在一个查询中所请求的数据，选项A是一个无效的选择，因为表没有删除，选项B不正确，因为闪回
查询返回的数据只有一个特定的时间点，而不是一个时间范围选项D不正确，因为尽管它可能产生的报告所
需的数据，就必须单独为每个表执行闪回版本查询； 选项E是不正确的，因为用户不希望恢复该表。

---