ocp Oracle1z0053答案整理.docx
《ocp Oracle1z0053答案整理.docx》由会员分享,可在线阅读,更多相关《ocp Oracle1z0053答案整理.docx(246页珍藏版)》请在冰豆网上搜索。
![ocp Oracle1z0053答案整理.docx](https://file1.bdocx.com/fileroot1/2023-1/5/93c8519e-b735-4417-a53b-12d622e13cbd/93c8519e-b735-4417-a53b-12d622e13cbd1.gif)
ocpOracle1z0053答案整理
整理过程参考了一末夕阳的博客,复习过程的心得是,一百题看完复习前一部分,同时我还整理了一份打印版本的,上面只有题目,没有答案,建议在电脑上先看答案整理那一份,没有答案的那份打印出来,复习使用,可以有效加强记忆。
1.Whiledeployinganewapplicationmodule,thesoftwarevendorshipstheapplicationsoftwarealongwithappropriateSQLplanbaselinesforthenewSQLsbeingintroduced.Whichtwostatementsdescribetheconsequences?
(Choosetwo.)
A.Theplanbaselinescanbeevolvedovertimetoproducebetterperformance.
B.ThenewlygeneratedplansaredirectlyplacedintotheSQLplanbaselinewithoutbeingverified.
C.ThenewSQLstatementsinitiallyrunwiththeplansthatareknowntoproducegoodperformanceunderstandardtestconfiguration.
D.TheoptimizerdoesnotgeneratenewplansfortheSQLstatementsforwhichtheSQLplanbaselinehasbeenimported.
当部署一个新的应用模块时,软件供应商与用于被引入的新SQL的适当的SQL计划基线一起运送应用软件。
哪两个语句描述了后果?
A, 计划基线可以随着时间的推移演变,产生更好的性能。
C,新的SQL语句最初与计划一起运行,该计划在标准测试配置下已知能产生良好的性能。
新应用程序部署:
部署新的应用程序模块意味着在系统中引入新的SQL语句。
软件供应商可以将应用程序软件与新引入的SQL语句的相应SQL计划基线一起提供。
由于存在计划基线,新的SQL语句最初将与已知在标准测试配置下具有良好性能的计划一起运行。
但是,如果客户系统配置与测试配置有很大的差异,则计划基线可随时间演化以产生更好的性能。
2.Youplantohavealargermovingwindowsizeforthedefaultsystem-definedmovingwindowbaseline
becauseyouwanttousetheadaptivethreshold.
Whichstatementfactorsinthisconsiderationwhileincreasingthesizeofthemovingwindow.?
A.ThecollectionlevelfortheAWRshouldbesettoBASIC.
B.ThemovingwindowsizemustbelessthanUndoRetention.
C.ThemovingwindowsizeshouldbegreaterthantheAutomaticWorkloadRepository(AWR)retentionperiod.
D.ThemovingwindowsizeshouldbeequaltoorlessthantheAutomaticWorkloadRepository(AWR)retentionperiod.
移动窗口基线
OracleDatabase会自动维护一个系统定义的移动窗口基线。
系统定义的移动窗口基线的默认窗口大小为当前的AWR保留期(默认为八天)。
如果计划使用自适应阈值,则可考虑使用较大的移动窗口(如30天),以便精确地计算阈值。
通过将移动窗口中的天数更改为等于或小于AWR保留期中的天数的值,可以调整移动窗口基线的大小。
因此,要增加移动窗口的大小,需要先相应地增加AWR保留期。
这种系统定义的基线提供了一个现成的默认基线,EM的性能屏幕可对照当前的数据库性能对性能进行比较。
注:
在OracleDatabase11g中,快照数据的默认保留期已经从七天更改为八天,以确保捕获整周的性能数据。
3.YourdatabaseisinARCHIVELOGmode.Youhavetwoonlineredologgroups,eachofwhichcontainsoneredomember.Whenyouattempttostartthedatabase,youreceivethefollowingerrors:
ORA-00313:
openfailedformembersofloggroup1ofthread1
ORA-00312:
onlinelog1thread1:
'D:
\REDO01.LOG'
Youdiscoverthattheonlineredologfileofthecurrentredogroupiscorrupted.
Whichstatementshouldyouusetoresolvethisissue?
A.ALTERDATABASEDROPLOGFILEGROUP1;
B.ALTERDATABASECLEARLOGFILEGROUP1;
C.ALTERDATABASECLEARUNARCHIVEDLOGFILEGROUP1;
D.ALTERDATABASEDROPLOGFILEMEMBER'D:
\REDO01.LOG';
你的数据库在归档记录模式。
你有两个在线重做日志组,其中每个都包含一个重做成员。
当您尝试启动数据
库时,您会收到以下错误:
ORA-00313:
线程1日志组1成员打开失败
ORA-00312:
联机日志1线程1:
'D:
\REDO01.LOG
你发现当前的重做组联机重做日志文件被损坏。
你应该使用哪种说法来解决这个问题?
4.WhichthreecomponentsdoestheScheduleruseformanagingtaskswithintheOracleenvironment?
(Choosethree.)
A.ajob
B.aprogram
C.aschedule
D.aPL/SQLprocedure
在Oracle环境调度程序为管理任务使用哪三个组件?
A.ajob作业
B.aprogram程序
C.aschedule调度
5.ExaminethesectionoftheHealthCheckreportgivenbelow:
DBMS_HM.GET_RUN_REPORT('HM_RUN_1061')
Thesafer,easierwaytohelpyoupassanyITexams.
3/193
RunName:
HM_RUN_1061RunId:
1061CheckName:
DataBlockIntegrityCheckMode:
REACTIVEStatus:
COMPLETEDStartTime:
2007-05-1222:
11:
02.032292-07:
00EndTime:
2007-05-1222:
11:
20.835135-07:
00ErrorEncountered:
0
SourceIncidentId:
7418
NumberofIncidentsCreated:
0
WhichtwostatementsaretrueregardingtheHealthCheckreport?
(Choosetwo.)
A.HealthCheckwasperformedmanually.
B.HealthCheckwasperformedtocheckthediskimageblockcorruptions.
C.HealthCheckwasperformedtocheckinterblockandintersegmentcorruption.
D.HealthCheckwasperformedtoverifytheintegrityofdatabasefilesandreportfailures.
E.HealthCheckwasperformedbytheHealthMonitorautomaticallyinresponsetoacriticalerror.
6.YouareworkingonaCATDBdatabasethatcontainsanOracleDatabaseversion11.1catalogschema
ownedbytheuserRCO11.TheINST1databasecontainsanOracleDatabaseversion10.1catalog
schemaownedbytheuserRCAT10.
YouwanttheRMANtoimportmetadatafordatabaseIDs1423241and1423242,registeredinRCAT10,
intotherecoverycatalogownedbyRCO11.Youalsowanttoderegisterthemfromthecatalogafterimport.
Youexecutedthefollowingcommandstoachievethis:
RMAN>CONNECTCATALOGrco11/password@catdb
RMAN>IMPORTCATALOGrcat10/oracle@inst1DBID=1423241,1423242;
WhathappensiftheRCO11cataloghasscriptswiththesamenameasthatofthescriptsinRCAT10
catalog?
A.ThescriptsintheRCO11catalogareoverwritten.
B.RMANrenamesthelocalstoredscriptsintheRCO11catalog.
C.TheRMANsessioninwhichthecommandisexecutedaborts.
D.RMANrenamestheglobalscriptsthatareimportedfromtheRCAT10catalog.
globalscripts:
可以针对在恢复目录中注册的任何数据库执行.
在import时,如果 globalscripts与目标方案的 globalscripts名称相同,则RMAN会重新命名为COPYOF script_name。
7.Youneedtoconfigurefine-grainedaccesscontroltoexternalnetworkresourcesfromwithinyour
database.Youcreateanaccesscontrollist(ACL)usingtheDBMS_NETWORK_ACL_ADMINpackage.
WhichstatementistrueregardingtheACLcreated?
A.ItisalistofremotedatabaselinksstoredintheXMLfilethatareavailabletotheusersofthedatabase.
B.ItisalistofusersandnetworkprivilegesstoredintheXMLfileaccordingtowhichagroupofuserscan
connecttooneormorehosts.
C.Itisalistofusersandnetworkprivilegesstoredinthedatadictionaryaccordingtowhichagroupof
userscanconnecttooneormorehosts.
D.ItisthelistofthehostnamesortheIPaddressesstoredinthedatadictionarythatcanconnecttoyour
databasethroughPL/SQLnetworkutilitypackagessuchasUTL_TCP.
8.WhichstatementistrueregardingonlineredefinitionforthemigrationofBasicFileLOBstoSecureFileLOBs?
A.Itcannotbedoneinparallel.
Thesafer,easierwaytohelpyoupassanyITexams.
4/193
B.Itcanbedoneatthetablelevelorpartitionlevel.
C.Itdoesnotrequireadditionalstoragebecausetheoperationisdoneonline.
D.Localandglobalindexesaremaintainedautomaticallyduringtheoperation.
OnlineredefinitionistheonlyrecommendedmethodformigrationofBasicFilesLOBstoSecureFilesLOBs. Itcanbedoneatthetableorpartitionlevel.
迁移到SecureFiles
使用LOB接口超集,可轻松从BasicFileLOB进行迁移。
迁移到SecureFiles 有两种建议方法:
分区交换和联机重新定义。
分区交换
•需要与表中最大分区相等的额外空间
•可在交换期间维护索引
•可将工作量分散到多个较小的维护窗口
•要求表或分区脱机以执行交换
联机重新定义(建议做法)
•不要求表或分区脱机
•可并行进行
•要求额外存储空间等于整个表,并且所有LOB段均可用
•要求重建所有全局索引
这些解决方案通常意味着使用输入LOB列中的数据所用磁盘空间两倍的空间。
但是,使用分区和按分区执行这些操作有助于降低所需的磁盘空间。
9.WhichstatementdescribestheinformationreturnedbytheDBMS_SPACE.SPACE_USAGEprocedure
forLOBspaceusage?
A.ItreturnsspaceusageofonlyBasicFileLOBchunks.
B.ItreturnsspaceusageofonlySecureFileLOBchunks.
C.ItreturnsbothBasicFileandSecureFileLOBspaceusageforonlynonpartitionedtables.
D.ItreturnsbothBasicFileandSecureFileLOBspaceusageforbothpartitionedandnonpartitioned
tables.
如果题目指定为SECUREFILE LOB spaceusage,则B是正确的。
10.Considerthefollowingscenarioforyourdatabase:
-BackupoptimizationisenabledinRMAN.Therecoverywindowissetto7daysinRMAN.Themost
recentbackuptodiskfortheTOOLStablespacewastakenonNovember3,2007.
TheTOOLStablespaceisread-onlysinceNovember4,2007.
OnNovember23,2007,youissuetheRMANcommandtobackupthedatabasetodisk.Whichstatement
istrueregardingthebackupoftheTOOLStablespace?
A.TheRMANbackupfailsbecausetheTOOLStablespaceisread-only
B.TheRMANskipsthebackupofthetablespacebecausebackupoptimizationisenabled
C.TheRMANmakesbackupbecauseoptimizationcanbeenabledonlyforbackupstodisk
D.TheRMANmakesthebackupbecausenobackupofthetablespaceexistswithinthesevenday
Window
题意:
最近的一次TOOLS表空间是November3,2007,November4,2007变为只读,November23,2007执行RMAN备份。
仅当符合保留策略的备份不存在时,备份优化才会让RMAN备份只读表空间。
根据备份优化,如果在November3,2007之后的7天内备份,则在rman备份时跳过只读表空间,即TOOLS表空间。
如果超过7天,即之前保留的备份已经没有了,再次执行RMAN命令时,此时的TOOLS表空间并没有备份,则执行RMAN命令时,TOOLS表空间也要被备份。
故选D。
tools这个只读表空间在7天的时间窗口没有备份。
11.ViewtheExhibittoexaminethemetricswithathreshold.Whichstatementistrueregardingthe
NumberofTransactions(persecond)metric?
A.Oracleusesstatisticalrelevancetodeterminewhenanadaptivethresholdhasbeenbreachedforthemetric.
Oracle使用统计相关性来确定一种自适应阈值时已经突破了度量。
B.Thestatisticsforthemetricvaluesobservedoverthebaselinetimeperiodarenotexaminedto
determinethresholdvalues.
C.Oracledetermineswhenanadaptivethresholdhasbeenbreachedbasedonthemaximumvalue
capturedbythebaseline.
D.Thetotalconcurrentnumberofthresholdviolations,whichmustoccurbeforeanalertisraisedforthe
metric,hasbeensettozero.
Thesafer,easierwaytohelpyoupassanyITexams.
5/193
12.YouperformedtheRMANdatabasebackuphavingabackupsetkeynumber231withtheKEEP
FOREVERoption.
Aftersomedays,youwanttochangethestatusofthedatabasebackupandyouissuedthefollowing
command:
RMAN>CHANGEBACKUPSET231NOKEEP;
Whatistheimplicationofthiscommand?
A.Thebackupisdeleted.
B.Thebackupismarkedunavailable.
C.Thebackupoverridesthebackupretentionpolicy.
D.thebackupbecomeseligiblefordeletionaccordingtotheexistingretentionpolicy
要删除备份就会根据现有的保留政策
13.ViewtheExhibitthatsetsthethresholdfortheCurrentOpenCursorsCountmetric.Whyisthe
SignificanceLevelthresholdtypenotavailableinthethresholdsetting?
A.becauseAWRbaselineisnotenabled
B.becauseCurrentOpenCursorsCountisnotabasicmetric
因为当前打开的游标数不是一个基本指标
C.becausetheSTATISTICS_LEVELparameterissettoBASIC
D.b