You executed the following query: SELECT operation, undo_sql, table_name FROM flashback_transaction_query Which statement is correct regarding the query output?

Question

Options

• AIt would return information regarding only the last committed transaction.
• BIt would return only the active transactions in all the undo segments in the database.
• CIt would return only the committed transactions in all the undo segments in the database.
• DIt would return both active and committed transactions in all the undo segments in the database.
• EIt would return information regarding the transactions that began and were committed in the last 30 minutes.

• A
  5% (2)
• B
  8% (3)
• C
  3% (1)
• D
  84% (31)

No community discussion yet for this question.