![](https://lstatic.shangxueba.com/sxbzda/h5/images/m_q_title.png)
A.a
B.b
C.c
D.ac
E.abc
![](https://lstatic.shangxueba.com/sxbzda/h5/images/tips_org.png)
第1题
A.DataPump
B.SQLscripts
C.SQL*Loader
D.Flashbackdatabase
E.RecoveryManager(RMAN)script
第2题
gamediarecovery,youdecidedtorecreatetheindexesinanewtablespace.Whichtwooptionswouldyouusetoreducethetimeittakestorecreatetheindexes?()
A.ONLINE
B.REVERSE
C.PARALLEL
D.COMPRESS
E.NOLOGGING
F.COMPUTESTATISTICS
第3题
andshutdown.OneisassignedtotheSYSTEMtablespaceandtwoareassignedtotheUSERStablespace.Youcanchoosefromthefollowingstepstorecoveryourdatabase:
a.Restorethethreedatabasedatafilesthatwerelost.
b.IssuetheStartupMountcommandtomountthedatabase.
c.Issuethealterdatabaseopencommand.
d.Issuethealterdatabaseopenresetlogscommand.
e.Recoverthedatabaseusingtherecoverdatabasecommand.
f.Recoverthedatafileswiththerecoverdatafilecommand.
g.Takethedatafilesoffline.
Whichisthecorrectorderofthesestepsinthiscase?()
第4题
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.
第5题
A.restorethetablespacefromthebackupthereisnoneedtoapplytheredoinformation
B.restorethefulldatabasetorecoverthedatauptothepointwhenyouperformedthebackup
C.restorethetablespacefromthebackup,andthenperformarecoveryusingthebackupcontrolfile
D.restorethetablespacefromthebackup,andthenrecoverthetablespacealltheredoinformationfromthepointwhenthetablespacewasmaderead/writeisapplied
第6题
A.dropandrecreatethereadonlytablespaces
B.renamethereadonlydatafilestotheircorrectfilenames
C.changethetablespacestatusfromread/writetoreadonly
D.recreatethereadonlytablespacebecauseitisautomaticallyremoved
第7题
iles,butusingabackupcontrolfile.Thebackupcontrolfileindicatesthatthestatusofthereadonlytablespacewasread/writewhenthecontrolfilewasbackedup.Whatshouldyouconsider?()
A.dropthereadonlytablespaceandrecreatethetablespaceafterrecovery
B.takedatafilesfromthereadonlytablespaceofflinebeforeperformingarecovery
C.performarecoverystatusofthetablespaceincontrolfilewillbechangedautomatically
D.recoveryusingbackupcontrolfileisnotpossible,sorestoreallthefilesfromthelastfulldatabasebackup,andthenopenthedatabase
第8题
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.
第9题
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.
第10题
A.Compilation fails.
B.ClassC is displayed.
C.The code runs with no output.
D.An exception is thrown at runtime.
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!