单项选择题
A.flash back all the tables in the data file, one by one
B.restore the data file to a new location and perform a media recovery
C.flash back the database; there is no need to restore the data file
D.restore the data file from the most recent backup and flash back the database
单项选择题 EverySunday,consistentbackupsareperformedonyourdatabase.Becauseofausererror,youperformedanincompleterecoveryonTuesdayandopenedthedatabasewiththeRESETLOGSoption.AusererroroccursagainonThursday,whichnecessitatesanincompleterecovery.Sunday’sbackupisthemostrecentbackupavailable.Whatwouldyoudointhisscenario?()
单项选择题 You are working on Oracle Database 10g, which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option?()
单项选择题 You are using Oracle Database 10g. The LOG_ARCHIVE_FORMAT parameter is set to ’LOG%t_%s_%r.dbf’. Why is %r used in the file name format?()