多项选择题
You executed the following FLASHBACK TABLE command： FLASHBACK TABLE emp TO TIMESTAMP （’11：45’，’hh12：mi’）; Which two statements are correct？（）
A.The FLASHBACK TABLE statement will not be written to the alert log file.
B.The changes made to the EMP table since the specified time will be undone.
C.The EMP table that was dropped by mistake from the database will be restored.
D.The FLASHBACK TABLE statement will be executed within a single transaction.
E.The FLASHBACK TABLE statement will not maintain the existing indexes on the EMP table.
F.The list of transactions that have modified the EMP table since the specified time will be displayed.
相关考题
-
单项选择题
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 -
多项选择题
View the Exhibit and examine the Flashback SCNs. A user has inserted wrong department data in the DEPT3 table in the USERS tablespace. You use the Flashback Table functionality to rectify the erroneous inserts. While performing the recovery， you chose 2004343 as the Flashback SCN. Which two statements are correct in this scenario？（）
A.Only the row with DEPARTMENT_ID 290 would be flashed back.
B.The rows with DEPARTMENT_ID 290 and 300 would be flashed back.
C.The rows with DEPARTMENT_ID 290 and 280 would be flashed back.
D.You would have taken the USERS tablespace offline before starting the Flashback Table operation.
E.You would have enabled row movement for the DEPT3 table before starting the Flashback Table operation. -
单项选择题
OnMonday，youdroppedtheDEPTtablefromyourschemaandthenyourecreatedtheDEPTtableinyourschema.OnWednesday，youhavearequirementtorestoretheDEPTtablefromtherecyclebin.Whichstatementiscorrect？（）
A.You can restore the DEPT table by using the Oracle Flashback Drop feature， provided you use the RENAME TO clause.
B.You can restore the DEPT table by using the Oracle Flashback Drop feature and a systemgenerated name will be assigned to the restored table.
C.You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table withthe name DEPT already exists in your schema.
D.You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of the recycle bin are purged every 12 hours by default.
