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.