ORACLE 11G OCP 管理2WorkshopII 1Z0053题库1100题 时时更新.docx

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