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

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/8520577/viewspace-2075632/，如需轉載，請註明出處，否則將追究法律責任。