多項選擇題

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

无码高清视频|成人自拍视频|欧美成人午夜无码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’）；

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