1:ORA-01110:datafile4:,,/oracle01/oradata/orcl/users01.dbfORA-27041:01116:errorinopeningdatabasefile4ORA-unabletoopenfileLinuxError:
2:NosuchfileordirectoryAdditionalinformation:
3Youcanchoosefromthefollowingsteps:
a.Restorethemissingdatabasedatafiles.
b.Takethemissingdatafileoffline.
c.Shutdownthedatabase.
d.IssuetherecovertablespaceUSERScommand.
e.IssuetheStartupMountcommandtomountthedatabase.
f.BringtheUSERStablespaceonline.
g.Issuethealterdatabaseopencommand.
Whichisthecorrectorderofthesestepsinthiscase?()
第1题
A.Alpha a = x;
B.Foo f = (Delta)x;
C.Foo f = (Alpha)x;
D.Beta b = (Beta)(Alpha)x;
第2题
atabasebackupcontrolfiletotracecommand.Yourdatafilesandyouronlineredologsareallintact.Whichofthefollowingistrueregardingyourrecovery?()
A.Youwillneedtoopenthedatabasewiththeresetlogscommand.
B.AllyouneedtodoisexecutethetracefilefromSQL*Plusanditwillperformtherecoveryforyou.
C.Youwillusetheresetlogsversionofthecreatecontrolfilecommand.
D.Youwillusethenoresetlogsversionofthecreatecontrolfilecommand.
E.Youwillusethetracefiletocreateabackupcontrolfile,andthenyouwillrecoverthedatabasewiththerecoverdatabaseusingbackupcontrolfilecommand
第3题
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.
第4题
A.Restorethe19thsbackup,restoreallarchivedredologs,recoverthedatabasetothe20th,andopenthedatabase.
B.Tellthemthattheirrequestcannotbemetwiththecurrentbackupstrategy.
C.Restorethe19thsbackup,applytheonlineredologs,andopenthedatabase.
D.SwitchthedatabaseintoARCHIVELOGmode,restorethe19th’sbackup,restoreallarchivedredologs,andrecoverthedatabasetothe20th.
E.Usetherecoverdatabasecommandtorollbackthedatabasefromtodaytothe19thofthemonth.
第5题
A.importthedatabasefromthelastexport
B.restoreallthemembersinthegroupfromthelastbackup
C.dropthelostmemberfromthedatabase,andthenaddanewmembertothegroup
D.restoreallthedatabasefilesfromthebackup,andthenperformacompleterecovery
E.restoreallthedatabasefilesfromthebackup,andthenperformanincompleterecovery
第6题
A.Backupcontrolfile.
B.Emergencycontrolfile.
C.Thecreatecontrolfilecommand.
D.TherestorecontrolfileSQL*Pluscommand.
E.Nobackupisrequired.Thedatabasewillre-createthecontrolfilewhenitisdiscoveredtobelost.
第7题
A.Theindextablespacecontainsbitmapindexes.
B.Theindextablespacecontainsmorethanonedatafile.
C.Theindextablespacesupportsonlycompleterecovery.
D.Theindextablespaceisnotadictionarymanagedtablespace.
E.Thereisadependencyrelationshipbetweenatableanditsindexes.
第8题
A.a
B.b
C.c
D.ac
E.abc
第9题
A.DataPump
B.SQLscripts
C.SQL*Loader
D.Flashbackdatabase
E.RecoveryManager(RMAN)script
第10题
gamediarecovery,youdecidedtorecreatetheindexesinanewtablespace.Whichtwooptionswouldyouusetoreducethetimeittakestorecreatetheindexes?()
A.ONLINE
B.REVERSE
C.PARALLEL
D.COMPRESS
E.NOLOGGING
F.COMPUTESTATISTICS
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!