多项选择题
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 EMP table that was dropped by mistake from the database will be restored.
C. The changes made to the EMP table since the specified time will be undone.
D. The FLASHBACK TABLE statement will not maintain the existing indexes on the EMP table.
E. The FLASHBACK TABLE statement will be executed within a single transaction.
F. The list of transactions that have modified the EMP table since the specified time will be displayed.
相关考题
-
单项选择题
EverySunday，consistentbackupsareperformedonyourdatabase.Becauseofausererror，you performedanincompleterecoveryonTuesdayandopenedthedatabasewiththeRESETLOGSoption.AusererroroccursagainonThursday，whichnecessitatesanincompleterecovery.Sunday’sbackupisthemostrecentbackupavailable.Whatwouldyoudointhisscenario？（）
A. recovery cannot be performed because a backup was not performed after the last incomplete recovery
B. restore all the files from Sunday’s backup， and then recover up to the point in time when the RESETLOGS operation was performed on Tuesday
C. restore all the files from Sunday’s backup， and open the database to reset the database to the point in time when the backup was performed on Sunday
D. restore all the files from Sunday’s backup， and then perform an incomplete recovery up to the point in time when the user error occurred on Thursday -
单项选择题
Thelossofthecontrolfileforcedyoutore-createthecontrolfile.Afterre-creatingitandopeningthedatabase，youfindthatsomeofthedatafilesarenamedasMISSINGnnnnn，wherennnnnisafive-digitnumberstartingwith0.Whatcouldbethepossiblereason？（）
A. These are the data files that are corrupted.
B. There is no SYSAUX tablespace in your database
C. There is a read-only tablespace in your database.
D. These are the data files that cannot be recovered. -
单项选择题
YoulostthePRODSTDtablespace，whichwasread-only.Thetablespacewasread-onlywhenthelastbackupwastaken.Howwouldyourecoverthetablespace？（）
A. restore the tablespace from the backup， and then perform an incomplete recovery
B. restore the tablespace from the backup， and then apply all the redo information
C. restore all the data files in the database， and then perform an incomplete recovery
D. restore the tablespace from the backup
