單項(xiàng)選擇題

By using the transaction identifier provided by （） for a particular row change， you can use theFlashback Transaction Query to see the operation performed by the transaction.

A.Flashback Table
B.Flashback Database
C.Flashback Versions Query
D.the RMAN REPORT command
E.the DBA_PENDING_TRANSACTIONS view

你可能感興趣的試題

單項(xiàng)選擇題

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.

單項(xiàng)選擇題

By mistake， you ran the batch job （for updating the BILL_DETAILS table） twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify：
a） a list of changes made along with the transaction identifier of each change
b） the necessary SQL statements to undo the erroneous changes
Which option would you choose？（）

A.RMAN only
B.Flashback Table only
C.Flashback Versions Query only
D.Flashback Database and Flashback Transaction Query
E.Flashback Versions Query and Flashback Transaction Query

By using the transaction identifier provided by （） for a particular row change， you can use theFlashback Transaction Query to see the operation performed by the transaction.

你可能感興趣的試題

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？（）