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.