nerdexam
Oracle

1Z0-067 · Question #90

1Z0-067 Question #90: Real Exam Question with Answer & Explanation

The correct answer is 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. https://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns_flashback.htm#ADFNS01004

Question

Which two statements are true about Flashback Version Query?

Options

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

Explanation

https://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns_flashback.htm#ADFNS01004

Community Discussion

No community discussion yet for this question.

Full 1Z0-067 Practice