Which statement is correct regarding the query output?

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

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

A.
It would return information regarding only the last committed transaction.

B.
It would return only the active transactions in all the undo segments in the database.

C.
It would return only the committed transactions in all the undo segments in the database.

D.
It would return both active and committed transactions in all the undo segments in the
database.

E.
It would return information regarding the transactions that began and were committed in the last
30 minutes.



Leave a Reply 0

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