单项选择题
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？（）
A. loss of one of the tablespaces
B. loss of a system data file
C. loss of one of the control files
D. loss of a tempfile
E. loss of the only member of an unarchived redo log group
F. loss of a member from each redo log group
相关考题
-
单项选择题
ThebackupretentionpolicyisconfiguredasRECOVERYWINDOW2.YouexecutedthefollowingcommandinRecoveryManager（RMAN）againstyourdatabase：RMAN>REPORTOBSOLETE；Whatwouldyouseeintheoutput？（）
A. a list of all those files that have been deleted in the last two days
B. a list of all those files that have been recovered within the last two days
C. a list of all the expired backups and copies
D. a list of backups and copies that are outside the range covered by the current retention policy -
单项选择题
YouhaveanAutomaticStorageManagement（ASM）instancemanagingthedatabasefilesofyourproductiondatabase.ThedatabasecontainsASMfilesandnon-ASMfiles.UsingRecoveryManager（RMAN），youmigratethecompleteproductiondatabasetousetheASMinstance.Whichstatementistrue？（）
A. RMAN would relocate all the data files to an ASM disk group and other files to an operating system location， defined using Oracle Managed Files （OMF）.
B. RMAN would relocate the ASM files to an ASM disk group and the non-ASM files to an operating system location， defined using OMF
C. RMAN would relocate all the database files to an ASM disk group.
D. RMAN would change the file definitions in the control file to use the ASM but would not relocate the database files physically. -
单项选择题
OnMonday，youdroppedtheDEPTtablefromyourschemaandthenyoure-createdtheDEPTtableinyourschema.OnWednesday，youhavearequirementtorestoretheDEPTtablefromtherecyclebin.Whichstatementiscorrect？（）
A. You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table with the name DEPT already exists in your schema.
B. You can restore the DEPT table by using the Oracle Flashback Drop feature， provided you use the RENAME TO clause.
C. 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.
D. You can restore the DEPT table by using the Oracle Flashback Drop feature and a system-generated name will be assigned to the restored table.
