Oracle OCP 19c 认证1Z0-083考试(第4题)

最新推荐文章于 2026-05-13 09:54:08 发布

原创

最新推荐文章于 2026-05-13 09:54:08 发布 · 502 阅读

收录于

当前文章被以下社区和专栏收录：

Oracle的FLASHBACK操作包括查询、版本查询和事务查询。FLASHBACK版本查询依赖于UNDO，允许查看特定时间间隔内的所有行版本。而FLASHBACK事务查询则能获取指定交易或时间区间内的历史数据和元数据，通常与版本查询配合使用。

Which three are true about requirements for various FLASHBACK operations? (Choose three.)

A. FLASHBACK transaction query requires undo to retrieve all versions of a row that existed between two points in time.
B. FLASHBACK drop requires that the RECYCLEBIN parameter be set to ON.
C. FLASHBACK version query requires that the RECYCLEBIN parameter be set to ON.
D. FLASHBACK DATA ARCHIVE requires undo to store all versions of all rows of a table being tracked.
E. FLASHBACK drop requires undo to retrieve all versions of a row that existed between two points in time.
F. FLASHBACK version query requires undo to retrieve all versions of a row that existed between two points in time.

A B F

F is definitely right. Reference: https://oracle-base.com/articles/10g/flashback-version-query-10g "Flashback version query is based on UNDO. As

标签