ORACLE 11G OCP 管理2WorkshopII 1Z0053题库1100题 时时更新.docx
- 文档编号:23369647
- 上传时间:2023-05-16
- 格式:DOCX
- 页数:59
- 大小:490.46KB
ORACLE 11G OCP 管理2WorkshopII 1Z0053题库1100题 时时更新.docx
《ORACLE 11G OCP 管理2WorkshopII 1Z0053题库1100题 时时更新.docx》由会员分享,可在线阅读,更多相关《ORACLE 11G OCP 管理2WorkshopII 1Z0053题库1100题 时时更新.docx(59页珍藏版)》请在冰豆网上搜索。
ORACLE11GOCP管理2WorkshopII1Z0053题库1100题时时更新
ExamA
QUESTION1
Whiledeployinganewapplicationmodule,thesoftwarevendorshipstheapplicationsoftwarealongwithappropriateSQLplanbaselinesforthenewSQLsbeingintroduced.Whichtwostatementsdescribetheconsequences?
(Choosetwo.)
A.
Theplanbaselinescanbeevolvedovertimetoproducebetterperformance.
B.
ThenewlygeneratedplansaredirectlyplacedintotheSQLplanbaselinewithoutbeingverified.
C.
ThenewSQLstatementsinitiallyrunwiththeplansthatareknowntoproducegoodperformanceunder
standardtestconfiguration.
D.
TheoptimizerdoesnotgeneratenewplansfortheSQLstatementsforwhichtheSQLplanbaselinehas
beenimported.
Answer:
AC
Section:
(none)
QUESTION2
Youplantohavealargermovingwindowsizeforthedefaultsystem-definedmovingwindowbaselinebecauseyouwanttousetheadaptivethreshold.Whichstatementfactorsinthisconsiderationwhileincreasingthesizeofthemovingwindow?
A.
ThecollectionlevelfortheAWRshouldbesettoBASIC.
B.
ThemovingwindowsizemustbelessthanUndoRetention.
C.
ThemovingwindowsizeshouldbegreaterthantheAutomaticWorkloadRepository(AWR)retentionperiod.
D.
ThemovingwindowsizeshouldbeequaltoorlessthantheAutomaticWorkloadRepository
(AWR)retentionperiod.
Answer:
D
Section:
(none)
QUESTION3
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';
Answer:
C
Section:
(none)
Explanation/Reference:
QUESTION4
WhichthreecomponentsdoestheScheduleruseformanagingtaskswithintheOracleenvironment?
(Choosethree.)
A.
ajob
B.
aprogram
C.
aschedule
D.
aPL/SQLprocedure
Answer:
ABC
Section:
(none)
QUESTION5
ExaminethesectionoftheHealthCheckreportgivenbelow:
DBMS_HM.GET_RUN_REPORT('HM_RUN_1061')
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.
Answer:
AB
Section:
(none)
QUESTION6
YouareworkingonaCATDBdatabasethatcontainsanOracleDatabaseversion11.1catalogschemaownedbytheuserRCO11.TheINST1databasecontainsanOracleDatabaseversion10.1catalogschemaownedbytheuserRCAT10.
YouwanttheRMANtoimportmetadatafordatabaseIDs1423241and1423242,registeredinRCAT10,intotherecoverycatalogownedbyRCO11.Youalsowanttoderegisterthemfromthecatalogafterimport.Youexecutedthefollowingcommandstoachievethis:
RMAN>CONNECTCATALOGrco11/password@catdb
RMAN>IMPORTCATALOGrcat10/oracle@inst1DBID=1423241,1423242;
WhathappensiftheRCO11cataloghasscriptswiththesamenameasthatofthescriptsinRCAT10catalog?
A.
ThescriptsintheRCO11catalogareoverwritten.
B.
RMANrenamesthelocalstoredscriptsintheRCO11catalog.
C.
TheRMANsessioninwhichthecommandisexecutedaborts.
D.
RMANrenamestheglobalscriptsthatareimportedfromtheRCAT10catalog.
Answer:
D
Section:
(none)
Explanation/Reference:
QUESTION7
Youneedtoconfigurefine-grainedaccesscontroltoexternalnetworkresourcesfromwithinyourdatabase.Youcreateanaccesscontrollist(ACL)usingtheDBMS_NETWORK_ACL_ADMINpackage.
WhichstatementistrueregardingtheACLcreated?
A.
ItisalistofremotedatabaselinksstoredintheXMLfilethatareavailabletotheusersofthedatabase.
B.
ItisalistofusersandnetworkprivilegesstoredintheXMLfileaccordingtowhichagroupofusers
canconnecttooneormorehosts.
C.
Itisalistofusersandnetworkprivilegesstoredinthedatadictionaryaccordingtowhichagroupof
userscanconnecttooneormorehosts.
D.
ItisthelistofthehostnamesortheIPaddressesstoredinthedatadictionarythatcanconnecttoyour
databasethroughPL/SQLnetworkutilitypackagessuchasUTL_TCP.
Answer:
B
Section:
(none)
QUESTION8
WhichstatementistrueregardingonlineredefinitionforthemigrationofBasicFileLOBstoSecureFileLOBs?
A.
Itcannotbedoneinparallel.
B.
Itcanbedoneatthetablelevelorpartitionlevel.
C.
Itdoesnotrequireadditionalstoragebecausetheoperationisdoneonline.
D.
Localandglobalindexesaremaintainedautomaticallyduringtheoperation.
Answer:
B
Section:
(none)
QUESTION9
WhichstatementdescribestheinformationreturnedbytheDBMS_SPACE.SPACE_USAGEprocedureforLOBspaceusage?
A.
ItreturnsspaceusageofonlyBasicFileLOBchunks.
B.
ItreturnsspaceusageofonlySecureFileLOBchunks.
C.
ItreturnsbothBasicFileandSecureFileLOBspaceusageforonlynonpartitionedtables.
D.
ItreturnsbothBasicFileandSecureFileLOBspaceusageforbothpartitionedandnonpartitionedtables.
Answer:
B
Section:
(none)
QUESTION10
Considerthefollowingscenarioforyourdatabase:
-BackupoptimizationisenabledinRMAN.
Therecoverywindowissetto7daysinRMAN.
ThemostrecentbackuptodiskfortheTOOLStablespacewastakenonNovember3,2007.
TheTOOLStablespaceisread-onlysinceNovember4,2007.
OnNovember23,2007,youissuetheRMANcommandtobackupthedatabasetodisk.WhichstatementistrueregardingthebackupoftheTOOLStablespace?
A.
TheRMANbackupfailsbecausetheTOOLStablespaceisread-only
B.
TheRMANskipsthebackupofthetablespacebecausebackupoptimizationisenabled
C.
TheRMANmakesbackupbecauseoptimizationcanbeenabledonlyforbackupstodisk
D.
TheRMANmakesthebackupbecausenobackupofthetablespaceexistswithinthesevendaywindow
Answer:
D
Section:
(none)
Explanation/Reference:
QUESTION11
ViewtheExhibittoexaminethemetricswithathreshold.WhichstatementistrueregardingtheNumberofTransactions(persecond)metric?
A.
Oracleusesstatisticalrelevancetodeterminewhenanadaptivethresholdhasbeenbreachedforthemetric.
B.
Thestatisticsforthemetricvaluesobservedoverthebaselinetimeperiodarenotexaminedto
determinethresholdvalues.
C.
Oracledetermineswhenanadaptivethresholdhasbeenbreachedbasedonthemaximumvalue
capturedbythebaseline.
D.
Thetotalconcurrentnumberofthresholdviolations,whichmustoccurbeforeanalertisraisedfor
themetric,hasbeensettozero.
Answer:
A
Section:
(none)
QUESTION12
YouperformedtheRMANdatabasebackuphavingabackupsetkeynumber231withtheKEEPFOREVERoption.
Aftersomedays,youwanttochangethestatusofthedatabasebackupandyouissuedthefollowingcommand:
RMAN>CHANGEBACKUPSET231NOKEEP;
Whatistheimplicationofthiscommand?
A.
Thebackupisdeleted.
B.
Thebackupismarkedunavailable.
C.
Thebackupoverridesthebackupretentionpolicy.
D.
thebackupbecomeseligiblefordeletionaccordingtotheexistingretentionpolicy
Answer:
D
Section:
(none)
QUESTION13
ViewtheExhibitthatsetsthethresholdfortheCurrentOpenCursorsCountmetric.Whyisthe
SignificanceLevelthresholdtypenotavailableinthethresholdsetting?
A.
becauseAWRbaselineisnotenabled
B.
becauseCurrentOpenCursorsCountisnotabasicmetric
C.
becausetheSTATISTICS_LEVELparameterissettoBASIC
D.
becausetheAWRbaselineisasystem-definedmovingwindowbaseline
Answer:
B
Section:
(none)
Explanation/Reference:
QUESTION14
Whichtwostatementsaretrueregardinghotpatching?
(Choosetwo.)
A.
ItrequiresrelinkingoftheOraclebinary.
B.
Itdoesnotrequiredatabaseinstanceshutdown.
C.
Itcandetectconflictsbetweentwoonlinepatches.
D.
Itisavailableforinstallingallpatchesonallplatforms.
E.
Itworksonlyinasingledatabaseinstanceenvironment.
Answer:
BC
Section:
(none)
QUESTION15
YouareintheprocessofcreatingavirtualprivatecataloginyourOracleDatabase11gdatabase.ThePROD1,PROD2,andPROD3OracleDatabase10gdatabasesareregisteredinthebaserecoverycatalog.ThedatabaseuserwhoownsthebaserecoverycatalogisCATOWNER.CATOWNERexecutesthefollowingcommandtograntprivilegestoanewuserVPC1usingOracleDatabase11gRMANexecutables:
RMAN>GRANTCATALOGFORDATABASEprod1,prod2TOvpc1;
Thenyouissuethefollowingcommands:
RMAN>CONNECTCATALOGvpc1/oracle@catdb;
RMAN>SQL"EXECcatowner.dbms_rcvcat.create_virtual_catalog;"
Whatistheoutcomeoftheabovecommands?
A.
Theyexecuteandcreateavirtualcatalogforpre-Oracle11gclients.
B.
TheyproduceanerrorbecausePROD1andPROD2databasesbelongtotheolderversion.
C.
TheyproduceanerrorbecauseyouneedtoconnectasCATOWNERtoexecutethispackagedprocedure.
D.
They
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- ORACLE 11G OCP 管理2 WorkshopII 1Z0053题库1100题 时时更新 11 管理 Z0053 题库 1100 时时 更新
链接地址:https://www.bdocx.com/doc/23369647.html