A.DataPump
B.SQLscripts
C.SQL*Loader
D.Flashbackdatabase
E.RecoveryManager(RMAN)script
第1题
gamediarecovery,youdecidedtorecreatetheindexesinanewtablespace.Whichtwooptionswouldyouusetoreducethetimeittakestorecreatetheindexes?()
A.ONLINE
B.REVERSE
C.PARALLEL
D.COMPRESS
E.NOLOGGING
F.COMPUTESTATISTICS
第2题
andshutdown.OneisassignedtotheSYSTEMtablespaceandtwoareassignedtotheUSERStablespace.Youcanchoosefromthefollowingstepstorecoveryourdatabase:
a.Restorethethreedatabasedatafilesthatwerelost.
b.IssuetheStartupMountcommandtomountthedatabase.
c.Issuethealterdatabaseopencommand.
d.Issuethealterdatabaseopenresetlogscommand.
e.Recoverthedatabaseusingtherecoverdatabasecommand.
f.Recoverthedatafileswiththerecoverdatafilecommand.
g.Takethedatafilesoffline.
Whichisthecorrectorderofthesestepsinthiscase?()
第3题
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.
第4题
A.restorethetablespacefromthebackupthereisnoneedtoapplytheredoinformation
B.restorethefulldatabasetorecoverthedatauptothepointwhenyouperformedthebackup
C.restorethetablespacefromthebackup,andthenperformarecoveryusingthebackupcontrolfile
D.restorethetablespacefromthebackup,andthenrecoverthetablespacealltheredoinformationfromthepointwhenthetablespacewasmaderead/writeisapplied
第5题
A.dropandrecreatethereadonlytablespaces
B.renamethereadonlydatafilestotheircorrectfilenames
C.changethetablespacestatusfromread/writetoreadonly
D.recreatethereadonlytablespacebecauseitisautomaticallyremoved
第6题
iles,butusingabackupcontrolfile.Thebackupcontrolfileindicatesthatthestatusofthereadonlytablespacewasread/writewhenthecontrolfilewasbackedup.Whatshouldyouconsider?()
A.dropthereadonlytablespaceandrecreatethetablespaceafterrecovery
B.takedatafilesfromthereadonlytablespaceofflinebeforeperformingarecovery
C.performarecoverystatusofthetablespaceincontrolfilewillbechangedautomatically
D.recoveryusingbackupcontrolfileisnotpossible,sorestoreallthefilesfromthelastfulldatabasebackup,andthenopenthedatabase
第7题
A. The LOB matically compressed.
B. The LOB values are cached bvalues are autoy default in the buffer cache.
C. The LOB values are automatically stored in encrypted mode.
D. All LOB data that is identical in two or more rows in a LOB column share the same data blocks.
第8题
result,yourdatabasehascrashed.Youhavetriedtorestartthedatabaseandcleartheonlineredologfiles,butwhenyoutrytoopenthedatabaseyougetthefollowingerror.
SQL>startupORACLEinstancestarted.
TotalSystemGlobalArea167395328bytesFixedSize1298612bytesVariableSize142610252bytesDatabaseBuffers20971520bytesRedoBuffers2514944bytesDatabasemounted.
ORA-00313:openfailedformembersofloggroup2ofthread1ORA-00312:onlinelog2thread1:,,/oracle01/oradata/orcl/redo02a.logORA-27037:unabletoobtainfilestatusLinuxError:2:NosuchfileordirectoryAdditionalinformation:3
ORA-00312:onlinelog2thread1:,,/oracle01/oradata/orcl/redo02.logORA-27037:unabletoobtainfilestatusLinuxError:2:NosuchfileordirectoryAdditionalinformation:3
SQL>alterdatabaseclearlogfilegroup2;alterdatabaseclearlogfilegroup2*ERRORatline1:
ORA-01624:log2neededforcrashrecoveryofinstanceorcl(thread1)ORA-00312:onlinelog2thread1:,,/oracle01/oradata/orcl/redo02.logORA-00312:onlinelog2thread1:,,/oracle01/oradata/orcl/redo02a.log
Whatstepsmustyoutaketoresolvetheerror?()
a.Issuetherecoverdatabaseredologscommand.
b.IssuetheStartupMountcommandtomountthedatabase.
c.Restorethelastfulldatabasebackup.
d.Performapoint-in-timerecovery,applyingallarchivedredologsthatareavailable.
e.Restoreallarchivedredologsgeneratedduringandafterthelastfulldatabasebackup.
f.Openthedatabaseusingthealterdatabaseopenresetlogscommand.
g.Issuethealterdatabaseopencommand.
第9题
A.Compilation fails.
B.ClassC is displayed.
C.The code runs with no output.
D.An exception is thrown at runtime.
第10题
abase,youfindthatsomeofthedatafilesarenamedasMISSINGnnnnn,wherennnnnisafivedigitnumberstartingwith0.Whatcouldbethepossiblereason?()
A.Thesearethedatafilesthatarecorrupted.
B.ThereisnoSYSAUXtablespaceinyourdatabase
C.Thereisareadonlytablespaceinyourdatabase.
D.Thesearethedatafilesthatcannotberecovered.
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!