ORACLE 11G OCP 管理2 WorkshopII 1Z0053 题库100200之间题.docx

ORACLE 11G OCP 管理2 WorkshopII 1Z0053 题库100200之间题.docx

《ORACLE 11G OCP 管理2 WorkshopII 1Z0053 题库100200之间题.docx》由会员分享，可在线阅读，更多相关《ORACLE 11G OCP 管理2 WorkshopII 1Z0053 题库100200之间题.docx（54页珍藏版）》请在冰豆网上搜索。

ORACLE11GOCP管理2WorkshopII1Z0053题库100200之间题

QUESTION100

Examinethefollowingcommandthatisusedtoduplicateadatabaseonthesamehost:

RMAN>RUN

{

ALLOCATEAUXILIARYCHANNEL,aux1DEVICETYPEDISK;

DUPLICATETARGETDATABASETOauxdbSKIPREADONLY;\}

Whichtwostatementsdescribetheeffectafterthedatabaseisduplicatedsuccessfully?

（Choosetwo）

A.

Thedatafilesoftheread-onlytablespacesinthetargetdatabasearenotduplicated

B.

Theread-onlytablespacesinthetargetdatabasearestilldefinedinnewthedatabase

C.

Theread-onlytablespacesinthetargetdatabasearechangedtoonlineafterduplication

D.

Thedatafilesoftheread-onlytablespacesinthetargetdatabasegetduplicated

E.

Theread-onlytablespacesinthetargetdatabasearenotdefinedinthenewdatabase

Answer:

AB

Section:

（none）

QUESTION101

IdentifytwosituationsinwhichyoucanuseDataRecoveryAdvisorforrecovery.（Choosetwo.）

A.

Theuserhasdroppedanimportanttablethatneedstoberecovered.

B.

Thedatabasefilesarecorruptedwhenthedatabaseisopen.

C.

Youarenotabletostartupthedatabaseinstancebecausetherequireddatabasefilesaremissing.

D.

Thearchivedlogfilesaremissingforwhichbackupisnotavailable.

Answer:

BC

Section:

（none）

QUESTION102

ExaminethefollowingvaluesoftheinitializationparametersinthedatabasehavingtheSIDORCL:

BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdump

USER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udump

CORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdump

DIAGNOSTIC_DEST=

Theenvironmentvariableshavethefollowingvalue:

ORACLE_BASE=/u01/app/oracle

ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1

WhatisthelocationoftheAutomaticDiagnosticRepository（ADR）home?

A.

/u01/app/oracle/product/11.1.0/db_1

B.

/u01/app/oracle

C.

$ORACLE_HOME/bdump

D.

$ORACLE_HOME/log

Answer:

B

Section:

（none）

QUESTION103

ObservethefollowingPL/SQLblock:

BEGIN

dbms_spm.configure（'SPACE_BUDGET_PERCENT',30）;

END;

WhichstatementiscorrectregardingtheabovePL/SQLblock?

A.

ItautomaticallypurgestheSQLmanagementobjectswhenSMBoccupiesmorethan30%ofthe

SYSAUXtablespace.

B.

Itreserves30%ofthespaceintheSYSAUXtablespaceforSQLManagementBase（SMB）.

C.

Itreserves30%ofthespaceintheSYSTEMtablespaceforSMB.

D.

ItgeneratesaweeklywarninginthealertlogfilewhenSMBoccupiesmorethan30%oftheSYSAUX

tablespace.

Answer:

D

Section:

（none）

Explanation/Reference:

QUESTION104

YouaremanaginganOracleDatabase11gASMinstancehavingthreedisksinadiskgroupwithASMcompatibilityattributesetto11.1.0andredundancysettohigh.Oneofthedisksinthediskgroupbecomesunavailablebecauseofpowerfailure.Whichstatementswillbetrueinthisscenario?

（Chooseallthatapply.）

A.

Thediskisimmediatelydroppedfromthediskgroup.

B.

TheASMtrackstheextentsthataremodifiedduringtheouta

C.

TheASMmigratestheextentsfromtheunavailabledisktotheremainingdisks.

D.

Thediskautomaticallygoesoffline.

Answer:

BD

Section:

（none）

QUESTION105

Whichstatementsaretrueregardingtablecompression?

（Chooseallthatapply.）

A.

Itsavesdiskspaceandreducesmemoryusage.

B.

Itsavesdiskspacebuthasnoeffectonmemoryusage.

C.

ItincursextraCPUoverheadduringDMLaswellasdirectloadingoperations.

D.

ItincursextraCPUoverheadduringDMLbutnotdirectloadingoperations.

E.

ItrequiresuncompressoperationduringI/O.

Answer:

AC

Section:

（none）

QUESTION106

YouareworkingasaDBAonthedecisionsupportsystem.Thereisabusinessrequirementtotrackandstorealltransactionsforatleastthreeyearsforafewtablesinthedatabase.Automaticundomanagementisenabledinthedatabase.Whichconfigurationshouldyouusetoaccomplishthistask?

A.

EnableFlashbackDataArchiveforthetables.

B.

Specifyundoretentionguaranteeforthedatabase.

C.

Enablesupplementalloggingforthedatabase.

D.

QueryV$UNDOSTATtodeterminetheamountofundothatwillbegeneratedandcreateanundo

tablespaceforthatsize.

E.

CreateFlashbackDataArchiveonthetablespaceonwhichthetablesarestored.

Answer:

A

Section:

（none）

QUESTION107

Whichcomponentsareneededforsuccessfulandmostefficientrecovery.

A.

ThebackupRB3andthecurrentonlineredologfiles

B.

thebackupRB2andthearchivedredologfilesafterthelogsequencenumber15622

C.

BackupR81andthearchivedredologhiesafterthelogsequencenumber12871

D.

ThebackupRB3andthearchivedredologfilesafterthelogsequencenumber16721

Answer:

A

Section:

（none）

Explanation/Reference:

QUESTION108

YouaremanaginganOracleDatabase11ginstancewithASMstorage.YoulostanASMdiskgroupDATA.YouhaveRMANbackupofdataaswellasASMmetadatabackup.Youwanttore-createthemissingdiskgroupbyusingtheASMCMDmd_restorecommand.Whichofthesemethodswouldyouusetoachievethis?

（Chooseallthatapply.）

A.

Restorethediskgroupwiththeexactconfigurationasthebacked-updiskgroup,usingthesamedisk

groupname,samesetofdisks,failuregroupconfigurations,anddataonthediskgroup.

B.

Restorethediskgroupwiththeexactconfigurationasthebacked-updiskgroup,usingthesamedisk

groupname,samesetofdisks,andfailuregroupconfigurations.

C.

Restorethediskgroupwithchangeddiskgroupspecification,failuregroupspecification,diskgroupname,

andotherdiskattributes.

D.

Restoremetadatainanexistingdiskgroupbypassingtheexistingdiskgroupnameasaninputparameter.

Answer:

BCD

Section:

（none）

QUESTION109

Whichstatementdescribestheeffectoftableredefinitiononthetriggersattachedtothetable?

A.

AlltriggersonthetableareinvalidatedandareautomaticallyrevalidatedwiththenextDMLexecutiononthe

table.

B.

AlltriggersonthetableareinvalidatedandmustbemanuallyrecompiledbeforethenextDMLexecution

onthetable.

C.

Alltriggersonthetableremainvalid.

D.

Onlytriggersthatareaffectedbythechangestothestructureofthetableareinvalidatedandautomatically

revalidatedwiththenextDMLexecutiononthetable.

Answer:

A

Section:

（none）

QUESTION110

YouplantocollecttheAutomaticWorkloadRepository（AWR）dataeveryMondaymorningforamonth.YouwantOracleDatabasetoautomaticallycreateabaselineeveryMondayandremovetheoldbaseline.Whatisthecorrectactiontoachievethis?

A.

CreateandpopulateaSQLTuningSetfromtheAWRoneveryMonday.

B.

ChangetheRETENTIONsettingfortheAWRsnapshotsto7daysonMonday.

C.

Createarepeatingbaselinetemplate.

D.

InsertafindingdirectiveforfutureADDMtasks.

Answer:

C

Section:

（none）

QUESTION111

Whichthreestatementsaretrueregardingpersistentlightweightjobs?

（Choosethree.）

A.

Persistentlightweightjobsmodifyseveraltablesinthedatadictionarytogeneratealotofredo.

B.

Theusercannotsetprivilegesonpersistentlightweightjobs.

C.

Persistentlightweightjobsareusefulwhenusersneedtocreatealargenumberofjobsinashorttime.

D.

Persistentlightweightjobsareusefulwhenusersneedtocreateasmallnumberofjobsthatruninfrequently.

E.

Theuseofatemplateismandatorytocreatepersistentlightweightjobs.

Answer:

BCE

Section:

（none）

Explanation/Reference:

QUESTION112

Yourdatabaseinitializationparameterfilehasthefollowingentry:

SEC_MAX_FAILED_LOGIN_ATTEMPTS=3

Whichstatementistrueregardingthissetting?

A.

Itdropstheconnectionafterthespecifiednumberofloginattemptsfailforanyuser.

B.

Itisenforcedonlyifthepasswordprofileisenabledfortheuser.

C.

Itlockstheuseraccountafterthespecifiednumberofattempts.

D.

Itdropstheconnectionafterthespecifiednumberofloginattemptsfailonlyforuserswhohavethe

SYSDBAprivilege.

Answer:

A

Section:

（none）

QUESTION113

Whichstatementistrueregardingvirtualprivatecatalogs?

A.

Avirtualprivatecatalogownercancreatealocalstoredscript,andhaveread/writeaccesstoaglobal

storedscript.

B.

Thevirtualprivatecatalogownercannotcreateandmodifythestoredscripts.

C.

Thesetofviewsandsynonymsthatmakeupthevirtualprivatecatalogisstoredintheschemaofthe

RMANrecoverycatalogowner.

D.

ToperformmostoftheRMANoperations,thevirtualcatalogownermusthavetheSYSDBAorSYSOPER

privilegeonthetargetdatabase.

Answer:

D

Section:

（none）

QUESTION114

WhichtaskscanbeaccomplishedusingtheEnterpriseManagerSupportWorkbenchinOracleDatabase11g?

（Chooseallthatapply.）

A.

Generatereportsondatafailuresuchasdatafilefailures.

B.

YoucantracktheServiceRequest（SR）andimplementrepairs.

C.

YoucanpackageanduploaddiagnosticdatatoOracleSupport.

D.

Youcanmanuallyrunhealthcheckstogatherdiagnosticdataforaproblem.

Answer:

BCD

Section:

（none）

QUESTION115

WhataretheadvantagesofvariableextentsizesupportforlargeASMfiles?

（Choosetwo.）

A.

Itimprovesresyncoperationswhenthediskcomesonlineafterbeingtakenofflineformaintenancepurposes.

B.

Itimprovesperformanceintheextendedclusterconfigurationbyreadingfromalocalcopyofanextent.

C.

Fewerextentpointersareneededtodescribethefileandlessmemoryisrequiredtomanagetheextent

mapsinthesharedpool.

D.

Thisfeatureenablesfasterfileopensbecauseofthereductionintheamountofmemorythatisrequired

tostorefileextents.

Answer:

CD

Section:

（none）

Explanation/Reference:

QUESTION116

WhichtwoaretheusesoftheASMmetadata