A.Youwillneedtoopenthedatabasewiththeresetlogscommand.
B.AllyouneedtodoisexecutethetracefilefromSQL*Plusanditwillperformtherecoveryforyou.
C.Youwillusetheresetlogsversionofthecreatecontrolfilecommand.
D.Youwillusethenoresetlogsversionofthecreatecontrolfilecommand.
E.Youwillusethetracefiletocreateabackupcontrolfile,andthenyouwillrecoverthedatabasewiththerecoverdatabaseusingbackupcontrolfilecommand
第1题
A. Another repair session is running concurrently.
B. The failure ID has not been mentioned in the command for data file 5.
C. There are new failures recorded in the Automatic Diagnostic Repository (ADR).
D. The ADVISE FAILURE command has not been issued before the REPAIR FAILURE command.
第2题
A.Restorethe19thsbackup,restoreallarchivedredologs,recoverthedatabasetothe20th,andopenthedatabase.
B.Tellthemthattheirrequestcannotbemetwiththecurrentbackupstrategy.
C.Restorethe19thsbackup,applytheonlineredologs,andopenthedatabase.
D.SwitchthedatabaseintoARCHIVELOGmode,restorethe19th’sbackup,restoreallarchivedredologs,andrecoverthedatabasetothe20th.
E.Usetherecoverdatabasecommandtorollbackthedatabasefromtodaytothe19thofthemonth.
第3题
A.importthedatabasefromthelastexport
B.restoreallthemembersinthegroupfromthelastbackup
C.dropthelostmemberfromthedatabase,andthenaddanewmembertothegroup
D.restoreallthedatabasefilesfromthebackup,andthenperformacompleterecovery
E.restoreallthedatabasefilesfromthebackup,andthenperformanincompleterecovery
第4题
A.Backupcontrolfile.
B.Emergencycontrolfile.
C.Thecreatecontrolfilecommand.
D.TherestorecontrolfileSQL*Pluscommand.
E.Nobackupisrequired.Thedatabasewillre-createthecontrolfilewhenitisdiscoveredtobelost.
第5题
A.Theindextablespacecontainsbitmapindexes.
B.Theindextablespacecontainsmorethanonedatafile.
C.Theindextablespacesupportsonlycompleterecovery.
D.Theindextablespaceisnotadictionarymanagedtablespace.
E.Thereisadependencyrelationshipbetweenatableanditsindexes.
第6题
A.a
B.b
C.c
D.ac
E.abc
第7题
A.DataPump
B.SQLscripts
C.SQL*Loader
D.Flashbackdatabase
E.RecoveryManager(RMAN)script
第8题
gamediarecovery,youdecidedtorecreatetheindexesinanewtablespace.Whichtwooptionswouldyouusetoreducethetimeittakestorecreatetheindexes?()
A.ONLINE
B.REVERSE
C.PARALLEL
D.COMPRESS
E.NOLOGGING
F.COMPUTESTATISTICS
第9题
andshutdown.OneisassignedtotheSYSTEMtablespaceandtwoareassignedtotheUSERStablespace.Youcanchoosefromthefollowingstepstorecoveryourdatabase:
a.Restorethethreedatabasedatafilesthatwerelost.
b.IssuetheStartupMountcommandtomountthedatabase.
c.Issuethealterdatabaseopencommand.
d.Issuethealterdatabaseopenresetlogscommand.
e.Recoverthedatabaseusingtherecoverdatabasecommand.
f.Recoverthedatafileswiththerecoverdatafilecommand.
g.Takethedatafilesoffline.
Whichisthecorrectorderofthesestepsinthiscase?()
第10题
files are stored on three locations. The Flash Recovery Area is one of the locations. The details are given below:Which statement is true regarding what this command accomplishes?()
A. All archived redo log files backed up at least twice to tape are deleted.
B. All archived redo log files backed up at least once to tape are eligible for deletion.
C. All archived redo log files backed up at least twice to tape are deleted from the flash recovery area.
D. All archived redo log files in local archiving destinations and the flash recovery area backed up at least twice to tape are eligible for deletion.
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!