A.Restorethelatestwholebackup,performcompleterecovery,andopenthedatabasenormally
B.Restorethelatestwholebackup,performincompleterecovery,andopenthedatabasewiththeRESETLOGSoption.
C.Restorethelatestbackupscontrolfile,performcompleterecovery,andopenthedatabasewiththeRESETLOGSoption.
D.Restorethelatestbackupcontrolfile,performincompleterecoveryusingbackupcontrolfile,andopenthedatabasewiththeRESETLOGoption.
第1题
A. Restore the latest whole backup, perform complete recovery, and open the database normally
B. Restore the latest whole backup, perform incomplete recovery, and open the database with the RESETLOGS option
C. Restore the latest backups control file, perform complete recovery, and open the database with the RESETLOGS option
D. Restore the latest backup control file, perform incomplete recovery using backup control file, and open the database with the RESETLOG option
第2题
A.whenrecoveringalostread-onlytablespacefromaread-onlytablespacebackup
B.whenrecoveringalostread-onlytablespacefromaread-writetablespacebackupwhenthedatabaseisrunninginARCHIVELOGmode
C.whenrecoveringalostread-onlytablespacefromaread-writetablespacebackupwhenthedatabaseisrunninginNOARCHIVELOGmodeandthechangesintheonlineredologfileshavebeenoverwritten
D.whenrecoveringalostread-onlytablespacefromaread-onlytablespacebackupusingthebackupofthecontrolfile,thecontrolfilewascreatedusingtheALTERDATABASEBACKUPCONTROLFILETOTRACEstatement,andthisstatementwasissuedwhenthetablespacewasread-only
第3题
A.Itwillbecreatedonthelocalfilesystem.
B.ItwillbecreatedonlyintheFlashRecoveryArea.
C.ItwillbecreatedinthelocationspecifiedbytheLOG_ARCHIVE_DEST_1parameterandthedefaultlocation$ORACLE_HOME/dbs.
D.ItwillbecreatedinthelocationspecifiedbytheLOG_ARCHIVE_DEST_1parameterandlocationspecifiedbytheDB_RECOVERY_FILE_DESTparameter.
第4题
A. They are created only in the location specified by the LOG_ARCHIVE_DEST_1 parameter.
B. They are created only in the Fast Recovery Area.
C. They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and in the default location $ORACLE_HOME/dbs/arch.
D. They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the location specified by the DB_RECOVERY_FILE_DEST parameter.
第5题
A.thedatafilesassociatedwiththeSYSTEMtablespace
B.thedatafilesassociatedtotheDATA1tablespace
C.thedatafilesassociatedtotheSYSTEMandDATA1tablespaces
D.allthedatafilesinthedatabase
第6题
A.2,4,3
B.1,4,3,2
C.2,5,4,3,6
D.5,2,4,3,6
E.1,5,4,3,6,2
第7题
A.IftheFORMAToptiontotheRMANBACKUPcommandisspecified,thenRMANcreatesbackuppiecesandimagecopiesintheflashrecoveryareawithnamesintheOracleManagedFiles(OMF)format.
B.IfanylocaldestinationsforLOG_ARCHIVE_DEST_nareset,thenarchivedredologsarestoredinthesedestinationsaswellasintheflashrecoveryarea.
C.IftheflashrecoveryarealocationisconfiguredusingtheDB_RECOVERY_FILE_DESTinitializationparameter,thentheRMANbackupofOraclemanageddatafiles(OMF)onlywillgototheflashrecoveryareabydefault.
D.Ifnootherdestinationisconfiguredforrecoveryfiles,thenRMANplacesthecontrolfileautobackupsintheflashrecoveryareabydefault.
第8题
A. Data files that belong to only the root container
B. Data files that belong to the root container and all the pluggable databases (PDBs)
C. Data files that belong to only the root container and PDB$SEED
D. Data files that belong to the root container and all the PDBs excluding PDB$SEED
第9题
A. The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.
B. If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.
C. If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.
D. If you restart the database, the database will not be opened.
第10题
A. Drop the affected tablespace, re-create the tablespace, restore the datafiles, and the tablespace.
B. Take the affected datafile offline (if not already offline), restore the damaged image of the datafile, and then bring it online.
C. Restart the database in MOUNT mode, restore the damaged datafile, recover the datafile and then open the database with resetlogs.
D. Put the database in RESTRICTED mode, restore all the datafiles in the affected datafile and recover the tablespace, and then put the database in normal operational mode.
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!