160. Which two statements are correct regarding the Flashback Version
s Query feature? (Choose two.)
A. You can use this feature to identify the committed versions of the
rows, but not the uncommitted versions.
B. You can use this feature to identify the versions of V$ views.
C. You can use this feature to identify the inserts, deletes, and upd
ates performed on a particular row but not the data definition langua
ge (DDL) operations performed on the table.
D. You can use this feature for a table only if row movement is enabl
ed for the table.
E. You can use this feature to identify the versions of external and
fixed tables.
Answer: A,C
在哪种情况下可以使用flashback versions query
a、只能是commited 以后的数据
b、只能是dml 语句，ddl 不行，ddl 以后，前面的dml 也查询不到
c、没必要非要启用row movement,只有flashback table to scn 才需要
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/11312660/viewspace-718222/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
