單項選擇題

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.

你可能感興趣的試題

單項選擇題

You are working in an online transaction processing （OLTP） environment. You realize that the salary for an employee， John， has been accidentally modified in the EMPLOYEES table. Two days ago， the data was in the correct state. Flashback logs generated during last two days are available in the flash recovery area.
Which option would you choose to bring the data to the correct state while ensuring that no other data in the same table is affected？（）

A.perform point-in-time recovery
B.perform a Flashback Table operation to restore the table to the state it was in two days ago
C.perform a Flashback Database operation to restore the database to the state it was in two days ago
D.perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements， and then use them for recovery

多項選擇題

For which two SQL statements can you use the Flashback Table feature to revert a table to its previous state？（）

A.UPDATE TABLE
B.CREATE CLUSTER
C.TRUNCATE TABLE
D.ALTER TABLE MOVE
E.INSERT INTO···VALUES
F.ALTER TABLE···DROP COLUMN
G.ALTER TABLE···DROP PARTITION

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

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

你可能感興趣的試題

For which two SQL statements can you use the Flashback Table feature to revert a table to its previous state？（）

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

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