多项选择题
A.SYSDATE should not be used with TIMESTAMP.
B.The database must have multiplexed redo log files.
C.The database must be in the MOUNT state to execute the command.
D.The database must be opened with the RESETLOGS option after the flashback operation.
E.The entire database needs to be restored from the most recent backup before the flashback operation.
单项选择题 OnTuesday,ajuniorDBAdroppedanimportantapplicationuseraccount,whoseschemahasimportanttables.Youareaskedtorecoveralltheobjectsintheschema.Oninvestigation,youfindthattheuseraccountwasdroppedat11:00a.m.andSunday’sbackupisthemostrecentbackup.Whichflashbackfeaturewouldyouuse?()
单项选择题 A data file became corrupted in your database due to bad sectors on the disk. Because of corruption, you lost all the important tables in that data file. Which method would you use for recovery?()
单项选择题 EverySunday,consistentbackupsareperformedonyourdatabase.Becauseofausererror,youperformedanincompleterecoveryonTuesdayandopenedthedatabasewiththeRESETLOGSoption.AusererroroccursagainonThursday,whichnecessitatesanincompleterecovery.Sunday’sbackupisthemostrecentbackupavailable.Whatwouldyoudointhisscenario?()