nerdexam
Oracle

1Z0-043 · Question #183

Which two statements are correct regarding the Flashback Versions Query feature? (Choose two.)

The correct answer is A. You can use this feature to identify the committed versions of the rows, but not the uncommitted C. You can use this feature to identify the inserts, deletes, and updates performed on a particular row. See the full explanation below for the reasoning.

Question

Which two statements are correct regarding the Flashback Versions Query feature? (Choose two.)

Options

  • AYou can use this feature to identify the committed versions of the rows, but not the uncommitted
  • BYou can use this feature to identify the versions of V$ views.
  • CYou can use this feature to identify the inserts, deletes, and updates performed on a particular row
  • DYou can use this feature for a table only if row movement is enabled for the table.
  • EYou can use this feature to identify the versions of external and fixed tables.

How the community answered

(53 responses)
  • A
    75% (40)
  • B
    15% (8)
  • D
    6% (3)
  • E
    4% (2)

Community Discussion

No community discussion yet for this question.

Full 1Z0-043 Practice