A.dropandrecreatethereadonlytablespaces
B.renamethereadonlydatafilestotheircorrectfilenames
C.changethetablespacestatusfromread/writetoreadonly
D.recreatethereadonlytablespacebecauseitisautomaticallyremoved
第1题
iles,butusingabackupcontrolfile.Thebackupcontrolfileindicatesthatthestatusofthereadonlytablespacewasread/writewhenthecontrolfilewasbackedup.Whatshouldyouconsider?()
A.dropthereadonlytablespaceandrecreatethetablespaceafterrecovery
B.takedatafilesfromthereadonlytablespaceofflinebeforeperformingarecovery
C.performarecoverystatusofthetablespaceincontrolfilewillbechangedautomatically
D.recoveryusingbackupcontrolfileisnotpossible,sorestoreallthefilesfromthelastfulldatabasebackup,andthenopenthedatabase
第2题
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.
第3题
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.
第4题
A.Compilation fails.
B.ClassC is displayed.
C.The code runs with no output.
D.An exception is thrown at runtime.
第5题
abase,youfindthatsomeofthedatafilesarenamedasMISSINGnnnnn,wherennnnnisafivedigitnumberstartingwith0.Whatcouldbethepossiblereason?()
A.Thesearethedatafilesthatarecorrupted.
B.ThereisnoSYSAUXtablespaceinyourdatabase
C.Thereisareadonlytablespaceinyourdatabase.
D.Thesearethedatafilesthatcannotberecovered.
第6题
c Storage Management performs the rebalancing activity. You want to speed up the rebalancing activity.Which parameter should you specify to control the speed of the rebalancing activity?()
A. ASM_POWER_LIMIT
B. ASM_DISKSTRING
C. ASM_DISKGROUPS
D. INSTANCE_TYPE
第7题
verycatalog.Thefollowingcommandsareusedintheprocessofrecoveringthedatabasebyusingthebackupcontrolfile:Inwhatsequencewouldyouusethisprocesstoperformtherecovery?()
A.7,2,3,1,4,6,5
B.7,1,3,2,6,5,4
C.2,1,7,6,3,5,4
D.2,7,3,5,1,6,4
第8题
A.Thesystemchangenumber,whichisapointintimerelativetotransactionswithinagivendatabase.
B.Anumberthatrepresentstime.Thus,at1300hours,theSCNisthesameonalldatabases.
C.Thesecuritychangenumber,whichrepresentsthesecuritycodethatisneededtoaccess any databasestructure.
D.Aconversionfactorthatconvertsinternaldatabasetimetoexternalclocktime.
E.UTCtimeinthedatabase,providingastandardizedwayoftrackingtimeinOracle.
第9题
verycatalogandrestoredthecontrolfilebyusingthefollowingcommand:RMAN>RESTORECONTROLFILEWhichtwooperationsdoyouneedtoperformafterrestoringthecontrolfilefrombackup?()
A.shutdownandrestarttheinstance
B.addnewtempfilestothetemporarytablespacesafterrecovery
C.performamediarecoveryandopenthedatabasewiththeRESETLOGSoption
D.performamediarecoveryandbringthedatabasetoNOARCHIVELOGmode
第10题
A.Restoreandrecoverthedatafile.
B.Restoreandrecoverthetablespace.
C.Restoreandrecoverthedatabase.
D.Restoreandrecoverthecontrolfile.
E.Restoreandrecovertheparameterfile.
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!