多項選擇題

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

你可能感興趣的試題

單項選擇題

Why would you use the following FLASHBACK TABLE command？（）
FLASHBACK TABLE emp TO TIMESTAMP （’11：45’，’hh12：mi’）；

A.to undo the changes made to the EMP table since the specified time
B.to restore the EMP table that was wrongly dropped from the database
C.to view the transactions that have modified the EMP table since the specified time
D.to view the changes made to the EMP table for one or more rows since the specified time
E.to recover the EMP table to a point in time in the past by restoring the most recent backup

單項選擇題

You are working in an online transaction processing （OLTP） environment. You used the FLASHBACK TABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command， the System Change Number （SCN） was 663571. After flashing back the CUSTOMERS table，you realize that the table is not in the correct state and the resultant changes are not what you had desired. So， you need to reverse the effects of the FLASHBACK TABLE command while ensuring that：
a） No other user data in the database is affected.
b） The operation takes the minimum possible time.
Which option would you choose？（）

A.use the ROLLBACK command with SCN 663571
B.perform Flashback Transaction Query with SCN 663571
C.execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571
D.execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571

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

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

你可能感興趣的試題

Why would you use the following FLASHBACK TABLE command？（） FLASHBACK TABLE emp TO TIMESTAMP （’11：45’，’hh12：mi’）；

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

Why would you use the following FLASHBACK TABLE command？（）
FLASHBACK TABLE emp TO TIMESTAMP （’11：45’，’hh12：mi’）；