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.
第1题
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
第2题
A. Redo logs
B. Control file
C. The latest backup of only the damaged data file
D. The latest backup of all the data file in the USERS tablespace
E. Temporary files of temporary tablespace
F. Archive Logs since the latest backup to point of failure
第3题
A. Redo logs
B. Control file
C. The latest backup of only the damaged data file
D. The latest backup of all the data file in the USERS tablespace
E. Temporary files of temporary tablespace
F. Archive Logs since the latest backup to point of failure
第4题
A.Restorethelatestwholebackup,performcompleterecovery,andopenthedatabasenormally
B.Restorethelatestwholebackup,performincompleterecovery,andopenthedatabasewiththeRESETLOGSoption.
C.Restorethelatestbackupscontrolfile,performcompleterecovery,andopenthedatabasewiththeRESETLOGSoption.
D.Restorethelatestbackupcontrolfile,performincompleterecoveryusingbackupcontrolfile,andopenthedatabasewiththeRESETLOGoption.
第5题
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
第6题
A.Redologs
B.Controlfile
C.Thelatestbackupofonlythedamageddatafile
D.ThelatestbackupofallthedatafileintheUSERStablespace
E.Temporaryfilesoftemporarytablespace
F.ArchiveLogssincethelatestbackuptopointoffailure
第7题
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
第8题
A.thedatafilesassociatedwiththeSYSTEMtablespace
B.thedatafilesassociatedtotheDATA1tablespace
C.thedatafilesassociatedtotheSYSTEMandDATA1tablespaces
D.allthedatafilesinthedatabase
第9题
A. Place CDB1 in the mount stage and then the USERDATA tablespace offline in ACCOUNTS_PDb.
B. Place CDB1 in the mount stage and issue the ALTER PLUGGABLE DATABASE accounts_pdb CLOSE IMMEDIATE command.
C. Issue the ALTER PLUGGABLE DATABASE accounts_pdb RESTRICTED command.
D. Take the USERDATA tablespace offline in ACCOUNTS_PDb.
第10题
01578:ORACLEdatablockcorrupted(file#5,block#51)ORA-01110:datafile5:
’/u01/app/oracle/oradata/orcl/example01.dbf’
Youneedtorectifythecorruptionwhileensuringthefollowing:Thedatafileshouldremainonline.
Themeantimetorecover(MTTR)shouldbeminimal.
Youarenotusingabackupcontrolfile,andallthearchivedlogsareaccessible.
Whichoptionwouldyouchoose?()
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!