0729实际考错的OCP 1Z0053题目.docx

0729实际考错的OCP 1Z0053题目.docx

《0729实际考错的OCP 1Z0053题目.docx》由会员分享，可在线阅读，更多相关《0729实际考错的OCP 1Z0053题目.docx（9页珍藏版）》请在冰豆网上搜索。

0729实际考错的OCP1Z0053题目

Feedbackonyourperformanceisprintedbelow.Thereportliststheobjectivesforwhichyouansweredaquestionincorrectly.

∙Backupandrecoveracontrolfile

∙Backuptherecoverycatalog

∙ConfigureautomaticPGAmemorymanagement

∙Configurebackupoptimization

∙Createamultisection,compressedandencryptedbackup

∙CreateandUseRMANstoredscripts

∙Define,applyandusearetentionpolicy

∙Enablefastincrementalbackup

∙Identifytheneedofbackupmode

∙PerformBlockMediaRecovery

∙PerformFlashbackQuery

∙Performuser-managedincompletedatabaserecovery

∙Restoreadatabaseontoanewhost

∙SetupanduseaFlashbackDataArchive

∙UseFlashRecoveryArea

∙UseFlashbackTransaction

∙Useatime-basedorevent-basedscheduleforexecutingSchedulerjobs

∙Usejobchainstoperformaseriesofrelatedtasks

QUESTION9

Inyourdatabase,theflashrecoveryarea（FRA）isconfiguredasthedefaultforRMANbackups.You

executedthefollowingcommandstoconfigurethesettingsinRMAN:

Whichstatementistrueabouttheoutcome?

A.Onlyonechannelisallocatedandthebackupiscreatedintheflashrecoveryarea

B.Onlyonechannelisallocatedandthebackupiscreatedinthedestinationspecifiedforchannel

C.Twochannelsareallocatedandbackupsetsarecreatedinthedestinationsspecifiedforchannels1

and2

D.Threechannelsareallocatedandbackupsetsarecreatedinthedestinationsspecifiedforchannels1,2,andFRA

CorrectAnswer:

A

很容易错误的选B，我正选的B

Section:

UsingtheRMANRecoveryCatalog（RC）

Explanation

QUESTION94

WhichtwostatementscorrectlydescribetherelationshipamongtheSchedulercomponents:

job,program,

andschedule?

（Choosetwo）

A.Ajobisspecifiedaspartofaprogramdefinition

B.Aprogramcanbeusedinthedefinitionofmultiplejobs

C.Aprogramandjobcanbespecifiedaspartofascheduledefinition

D.Aprogramandschedulecanbespecifiedaspartofajobdefinition

CorrectAnswer:

BD

错误题库选择的是:

AC我也选的AC

Section:

AutomatingTaskswiththeScheduler

QUESTION70

YouwanttoenableautomaticPGAmemorymanagementinyourdatabase.Whichsettingisrequiredto

achievethis?

A.SetMEMORY_TARGETtozero

B.SettheSTATISTICS_LEVELparametertoBASIC

C.SettheWORKAREA_SIZE_POLICYparametertoMANUAL

D.SetthePGA_AGGREGATE_TARGETparametertononzerovalue

CorrectAnswer:

D

错误选择:

A

Section:

ManagingMemory

QUESTION34

Whileperformingaregularcheckonyourrecoverycatalogyourealizedthatthecatalogdatabaseis

runningoutofspaceandyoudonothaveoptionstoincreasethespace.However,youhaveanother

databasewheremorespaceisavailableandyouwanttomoveyourexistingrecoverycatalogtothis

database.

Theoptionsthatcanbeconsideredwhilemovingtherecoverycatalogareasfollows:

1.UsingoneoftheOracleexpdputilitiestoexportthecatalogdata

2.Creatingarecoverycataloguserandgrantingthenecessaryprivilegesintheotherdatabase

3.CreatingtherecoverycatalogusingtheCREATECATALOGcommand

4.Usingthecorrespondingimpdputilitytoimportthecatalogdataintotheotherdatabase

5.RegisteringthetargetdatabaseinthenewcatalogdatabaseusingtheREGISTERDATABASE

command.

Identifytheoptionwiththecorrectsequenceformovingtherecoverycatalog.

A.2,3,5

B.1,2,4

C.1,2,4,5

D.1,2,3,4,5

CorrectAnswer:

B

错误选择:

A

Section:

UsingtheRMANRecoveryCatalog（RC）

Explanation

Explanation/Reference:

Theexp/imptoolscanexportandimportthecompletedatastructureanddataextentstothedestination

database,sothatyoudon'tneedtodocreatecatalogandregisterdatabase.

Yourealizethatthecontrolfileisdamagedinyourproductiondatabase.Afterrestoringthecontrolfilefrom

autobackup,whatisthenextstepthatyoumustdotoproceedwiththedatabaserecovery?

A.Mountthedatabase

B.OpenthedatabaseinNORMALmode

C.OpenthedatabaseinRESTRICTEDmode

D.OpenthedatabasewiththeRESETLOGSoption

CorrectAnswer:

A

粗心选择：

D

Section:

PerformingUser-ManagedBackupandRecovery

Explanation

Explanation/Reference:

Afterrestoringthecontrolfile,itistimetoloadtherestoredcontrolfileontothedatabaseinstance,

toissueSTARTUPMOUNTcommandtoloadit.

QUESTION36

QUESTION69

ExaminethefollowingRMANcommand:

RMAN>CONFIGUREENCRYPTIONFORDATABASEON;

RMAN>BACKUPDATABASEPLUSARCHIVELOG;

Whichprerequisitemustbemetbeforeaccomplishingthebackup?

A.Provideapasswordfortheencryption

B.SetupanOraclewalletfortheencryption

C.Nosetupisrequiredasitisadefaultencryptionmethod

D.BothOraclewalletandpasswordmustbesetupfortheencryption

CorrectAnswer:

B

错误选择：

A

Section:

ConfiguringBackupSpecifications

QUESTION75

Identitytwoadvantagesofusingarecoverycatalogin-loadofthecontrolFileofthetargetdatabase

RecoveryManager（RMAN）.（Choosetwo.）

A.YoucanuseRMANstoredscripts.

B.Recoveryisfasterifdataisstoredincataloginadditiontothecontrolfile.

C.YoucanstorebackupInformationofallregistereddatabasesinoneplace.

D.Databasebackupsareautomaticallydeletedwhentheyareolderthanthespecifiedtimeperiod.

CorrectAnswer:

AC

错误:

AD

YourdatabaseisrunninginARCHIVELOGmode.Oneofthedatafiles,USERDATA01.dbf,intheUSERS

tablespaceisdamagedandyouneedtorecoverthefileuntilthepointoffailure.Thebackupforthedatafile

isavailable.

Whichthreefileswouldbeusedintheuser-managedrecoveryprocessperformedbythedatabase

administrator（DBA）?

（ChooseThree）

A.Redologs

B.Controlfile

C.Thelatestbackupofonlythedamageddatafile

D.ThelatestbackupofallthedatafileintheUSERStablespace

E.Temporaryfilesoftemporarytablespace

F.ArchiveLogssincethelatestbackuptopointoffailure

CorrectAnswer:

ACF

粗心选择:

ADC

此题可用来复习JPS之间的关系

（512）Whichtwostatementscorrectlydescribetheschedule?

（Choosetwo）

A.Ajobisspecifiedaspartofaprogramdefinition

B.Aprogramcanbeusedinthedefinitionofmultiplejobs

C.Aprogramandjobcanbespecifiedaspartofascheduledefinition

D.Aprogramandschedulecanbespecifiedaspartofajobdefinition

答案：

（B、D）

解析：

如图可见job，program和schedule三者的关系。

QUESTION42

ViewthefollowingSQLstatements:

TransactionT1

SQL>INSERTINTOhr.regions

2VALUES（5,'Pole'）;

3COMMIT;

TransactionT2

SQL>UPDATEhr.regions

2SETregion_name='Poles'

3WHEREregion_id=5;

4COMMIT;

TransactionT3

SQL>UPDATEhr.regions

2SETregion_name='NorthandSouthPoles'

3WHEREregion_id=5;

YouwanttobackouttransactionT2.Whichoptionwouldyouuse?

A.Itispossible,buttransactionT3alsobacksout.

B.ItispossiblewiththeNOCASCADE_FORCEoption.

C.ItispossiblewiththeNONCONFLICT_ONLYoption.

D.ItisnotpossiblebecauseithasconflictswithtransactionT3.

CorrectAnswer:

B

错误选的:

A

Section:

UsingFlashbackTechnology

QUESTION77

YourproductiondatabaseisfunctionalontheSHOST1host.Youarebackinguptheproductiondatabase

byusingRecoveryManager（RMAN）withtherecoverycatalog.Youwanttoreplicatetheproduction

databasetoantherhost,SHOST2,fortestingnewapplications.

Afteryouensuredthatthebackupsofthetargetdatabaseareaccessibleonthenewhost,whatmustyou

dotorestoreandrecoverthebackupforthetestenvironment?

A.RestoringthecontrolfilefromthebackupbyusingtheNOCATALOGoptiontorestore,andrecovering

thedatafiles

B.RestoringthedatafilesbyusingtheNOCATALOGoptionandusingtheSETNEWNAMEcommandto

changethelocation

C.Restoringtheserverparameterfilefromthebackupbyusingtherecoverycatalogtorestore,

D.Restoringthedatafilesfromthebackupbyusingtherecoverycatalogtorecoverthefiles,andusing

theSWITCHcommandtochangethelocation.

CorrectAnswer:

A

错误选择：

B

Section:

UsingRMANtoPerformRecovery

Explanation

Explanation/Reference:

Refertohere:

Torestorethedatabaseonanewhost:

1.Ensurethatthebackupsofthetargetdatabaseareaccessibleonthenewhost.

2.ConfiguretheORACLE_SIDonhostb.

3.StartRMANonhostbandconnecttothetargetdatabasewithoutconnectingtotherecovery

catalog.

Forexample,enterthefollowingcommand:

%rmanNOCATALOG

RMAN>CONNECTTARGET

/

4.SettheDBIDandstartthedatabaseinstancewithoutmountingthedatabase.

Forexample,runSETDBIDtosettheDBID,thenrunSTARTUPNOMOUNT:

SETDBID1340752057;

STARTUPNOMOUNT

RMANfailstofindtheserverparameterfile,whichhasnotyetbeenrestored,butstartstheinstance

witha"dummy"file.Sampleoutputfollows:

startupfailed:

ORA-01078:

failureinprocessingsystemparameters

LRM-00109:

couldnotopenparameterfile'/net/hostb/oracle/dbs/

inittrgta.ora'

tryingtostarttheOracleinstancewithoutparameterfiles...

Oracleinstancestarted

5.Restoreandedittheserverparameterfile.

Allocateachanneltothemediamanager,thenrestoretheserverparameterfileasaclient-side

parameterfileandusetheSETcommandtoindicatethelocationoftheautobackup（inthisexample,

theautobackupisin/tmp）:

RUN

{

ALLOCATECHANNELc1DEVICETYPEsbtPARMS'...';

SETCONTROLFILEAUTOBACKUPFORMATFORDEVICETYPEDISKTO'/tmp/%F';

RESTORESPFILE

TOPFILE'?

/oradata/test/inittrgta.ora'

FROMAUTOBACKUP;

SHUTDOWNABORT;

}

6.Edittherestoredinitializationparameterfile.

Changeanylocation-specificparameters,forexample,thoseendingin_DEST,toreflectthenew

directorystructure.Forexample,editthefollowingparameters:

-IFILE

-LOG_ARCHIVE_DEST_1

-CONTROL_FILES

7.Restarttheinstancewiththeeditedinitializationparameterfile.

Forexample,enterthefollowingcommand:

STARTUPFO