單項(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

單項(xiàng)選擇題

View the Exhibits.

You performed operations on the DEPT4 table as shown in the Exhibit. When you perform the FlashbackVersions Query， you find that the first two updates are not listed. What could be the reason？（）

A.The row movement is not enabled on the table.
B.The first two updates were not explicitly committed.
C.The Flashback Versions Query lists only the most recent update.
D.The Flashback Versions Query stops producing rows after it encounters a time in the past when the table structure was changed.

99色精品-9色在线-99色在线-99色视频 国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精

You executed the following query： SELECT operation， undo_sql， table_name FROM flashback_transaction_query； Which statement is correct regarding the query output？（）

你可能感興趣的試題

View the Exhibits. You performed operations on the DEPT4 table as shown in the Exhibit. When you perform the FlashbackVersions Query， you find that the first two updates are not listed. What could be the reason？（）

99色精品-9色在线-99色在线-99色视频国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精

You executed the following query： SELECT operation， undo_sql， table_name FROM flashback_transaction_query；
Which statement is correct regarding the query output？（）

View the Exhibits.

You performed operations on the DEPT4 table as shown in the Exhibit. When you perform the FlashbackVersions Query， you find that the first two updates are not listed. What could be the reason？（）