On which two database objects can the VERSIONS clause of the Flashback Versions Query be used?

On which two database objects can the VERSIONS clause of the Flashback Versions Query be used? (Choose two.)

On which two database objects can the VERSIONS clause of the Flashback Versions Query be used? (Choose two.)

A.
views

B.
fixed tables

C.
heap tables

D.
external tables

E.
temporary tables

F.
Index-Organized Tables (IOTs)

Explanation:
The VERSIONS clause CANNOT be used to query, the following database objects:
* External Tables
* Temporary Tables
* Fixed Tables
* Views
REF.: Oracle(r) Database 10g : New Features for Oracle 8i DBAs, 19-14



Leave a Reply 1

Your email address will not be published. Required fields are marked *


mr_tienvu

mr_tienvu

I choose CF