Oracle OCP 1Z0 053 Q704(Flashback Versions Query)
704. View the Exhibit and examine the data manipulation language (DML) operations that you performed
on the NEWEMP table. Note that the first two updated are not listed by the Flashback Versions Query.
What could be the reason?
A.The first two updated were not explicitly committed.
B.ALTER TABLE caused the recycle bin to release the space.
C.The data definition language (DDL) operation caused a log switch.
D.Flashback Versions Query stops producing versions of rows that existed before a change in the table
structure.
Answer:D
DDL并不会引起log switch
参考：http://www.cnblogs.com/jyzhao/p/5279547.html
on the NEWEMP table. Note that the first two updated are not listed by the Flashback Versions Query.
What could be the reason?
A.The first two updated were not explicitly committed.
B.ALTER TABLE caused the recycle bin to release the space.
C.The data definition language (DDL) operation caused a log switch.
D.Flashback Versions Query stops producing versions of rows that existed before a change in the table
structure.
Answer:D
DDL并不会引起log switch
参考：http://www.cnblogs.com/jyzhao/p/5279547.html
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/8520577/viewspace-2075632/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
