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?
Exhibit:
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.
You don’t need an explicit Commit so A is wrong. Recycle bin and Log Switch are out of context so B and C are wrong.
D is correct.