Oracle Database 12c: Advanced Administration — Question 87

Which two statements are true about Flashback Version Query?

Answer options

• A. The result of a query can be used as part of a DML statement.
• B. It can be used to create views.
• C. It can be used only if Flashback Data Archive is enabled for a table.
• D. It retrieves all versions of rows that exist in a time interval, including the start time and end time.
• E. It can be used to retrieve the SQL that is required to undo a row change and the user responsible for the change.

Correct answer: A, C

Explanation

The correct answers are A and C because Flashback Version Query allows the output to be incorporated into DML operations, and it is only functional if Flashback Data Archive is enabled for the relevant table. Options B, D, and E are incorrect because Flashback Version Query does not create views, does not necessarily retrieve all versions including boundaries, and does not provide SQL or user information related to row changes.