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.
第1题
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.
第2题
A.Compilation fails.
B.ClassC is displayed.
C.The code runs with no output.
D.An exception is thrown at runtime.
第3题
abase,youfindthatsomeofthedatafilesarenamedasMISSINGnnnnn,wherennnnnisafivedigitnumberstartingwith0.Whatcouldbethepossiblereason?()
A.Thesearethedatafilesthatarecorrupted.
B.ThereisnoSYSAUXtablespaceinyourdatabase
C.Thereisareadonlytablespaceinyourdatabase.
D.Thesearethedatafilesthatcannotberecovered.
第4题
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
第5题
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
第6题
A.Thesystemchangenumber,whichisapointintimerelativetotransactionswithinagivendatabase.
B.Anumberthatrepresentstime.Thus,at1300hours,theSCNisthesameonalldatabases.
C.Thesecuritychangenumber,whichrepresentsthesecuritycodethatisneededtoaccess any databasestructure.
D.Aconversionfactorthatconvertsinternaldatabasetimetoexternalclocktime.
E.UTCtimeinthedatabase,providingastandardizedwayoftrackingtimeinOracle.
第7题
verycatalogandrestoredthecontrolfilebyusingthefollowingcommand:RMAN>RESTORECONTROLFILEWhichtwooperationsdoyouneedtoperformafterrestoringthecontrolfilefrombackup?()
A.shutdownandrestarttheinstance
B.addnewtempfilestothetemporarytablespacesafterrecovery
C.performamediarecoveryandopenthedatabasewiththeRESETLOGSoption
D.performamediarecoveryandbringthedatabasetoNOARCHIVELOGmode
第8题
A.Restoreandrecoverthedatafile.
B.Restoreandrecoverthetablespace.
C.Restoreandrecoverthedatabase.
D.Restoreandrecoverthecontrolfile.
E.Restoreandrecovertheparameterfile.
第9题
A.byusingthetracefile
B.byusingthealertlogfile
C.byusingthedatabaseID
D.byusingtheserverparameterfile
E.byusingtheV$CONTROLFILEview
F.byusingtheautobackupformatconfigurationsetting
第10题
erecoveryprocess,youreceivethefollowingerror:
ORA-00279:change5033391generatedat08/17/200806:37:40neededforthread1ORA-00289:suggestion:
/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17/o1_mf_1_11_%u_.arc
ORA-00280:change5033391forthread1isinsequence#11ORA-00278:log
file,,/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17
/o1_mf_1_10_4bj6wnqm_.arcnolongerneededforthisrecoverySpecifylog:{=suggested|filename|AUTO|CANCEL}ORA-00308:cannotopenarchivedlog
,,/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17/o1_mf_1_11_%u_.arc
ORA-27037:unabletoobtainfilestatusLinuxError:2:NosuchfileordirectoryAdditionalinformation:3
Howdoyourespondtothiserror?()
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!