ocp 1Z0053 最近题库.docx

ocp 1Z0053 最近题库.docx

《ocp 1Z0053 最近题库.docx》由会员分享，可在线阅读，更多相关《ocp 1Z0053 最近题库.docx（13页珍藏版）》请在冰豆网上搜索。

ocp1Z0053最近题库

681.TheenvironmentalvariableORACLE-BASEisset.YouwanttocheckthediagnosticfilescreatedaspartoftheAutomaticDiagnosticRepository（ADR）.ViewtheExhibitandnotethevariousparameterssetinyourdatabase.

WhatwillbethelocationoftheADRbase?

A.ItissettoORACLE-BASE.

B.ItissettoORACLE_HOME/log.

C.Itissetto/u01/app/oracle/admin/orcl/adump.

D.Itissetto/u01/app/oracle/flash_recovery_area.

682.IdentifythescenariosinwhichtheRMANCROSSCHECRcommandisuseful.（Chooseallthatapply.）

A.Tocheckthattheobsoletebackupsaredeletedfromtherepositoryrecordsandfromthedisk.

B.ToupdatetheRMANrepositoryifyoudeletearchivedredologswithoperatingsystemcommands.

C.Toupdateoutdatedinformationaboutbackupsthatdisappearedfromdiskortapeorbecamecorruptedandinaccessible.

D.TosynchronizetheactualfilesondiskorinthemediamanagementcatalogwiththeRMANrepositoryforwhichthebackupwasnottakenusingRMAN.

683.YourproductiondatabaseitfunctionalontheSHOST1host.YouarebackinguptheproductiondatabasebyusingRecoveryManager（RMAN）withtherecoverycatalog.Youwanttoreplicatetheproductiondatabasetoantherhost,SHOST2,fortestingnewapplications.

Afteryouensuredthatthebackupsofthetargetdatabaseareaccessibleonthenewhost,whatmustyoudotorestoreandrecoverthebackupforthetestenvironment?

A.RestoringthecontrolfilefromthebackupbyusingtheNOCATALOGoptiontorestore,andrecoveringthedatafiles

B.RestoringthedatafilesbyusingtheNOCATALOGoptionandusingtheSETNEWNAMEcommandtochangethelocation

C.Restoringtheserverparameterfilefromthebackupbyusingtherecoverycatalogtorestore,andrecoveringthedatafiles

D.Restoringthedatafilesfromthebackupbyusingtherecoverycatalogtorecoverthefiles,andusingtheSWITCHcommandtochangethelocation.

684.YourdatabaseisrunninginARCHIVELOGmode.Youhavebeentakingbackupsofallthedatafilesandcontrolfilesregularly.

YouareinformedthatsomeimportanttablesintheBILLINGtablespacehavebeendroppedonFebruary28,2007at10.30AMandmustberecovered.

Youdecidetoperformanincompleterecoveryusingthefollowingcommand:

SQL>RECOVERDATABASEUNTILTIME‘2007-02-28:

10:

15:

00’;

Identifythefilesthatmustberestoredtorecoverthemissingtablessuccessfully.

A.Restorethebackupofallthedatafiles.

B.Restorethebackupofallthedatafilesandthecontrolfile.

C.Restorethebackupofonlythedatafilesthatcontainthedroppedtables.

D.Restorethebackupofallthedatafilesbelongingtothetablespacecontainingthedroppedtables.

685.Inyourtestdatabase:

-YouareusingRecoveryManager（RMAN）toperformincrementalbackupsofyourtestdatabase

-ThetestdatabaseisrunninginNOARCHIVELOGmode

-Oneofthedatafilesiscorrupted

-Allonlineredologfilesarelostbecauseofamediafailure

Whichoptionmustyouconsiderinthisscenario?

A.ConfiguringthedatabaseinARCHVIELOGmodeandthenusingincrementalbackuptorecoverthedatabase

B.Usingincrementalbackuptorecoverthedamageddatafileandthenmanuallycreatingtheonlineredologfiles

C.CreatinganewtestdatabasebecausethedatabaseisnotrecoverableduetothefactthatthedatabaseisconfiguredinNOARCHIVELOGmode

D.UsingincrementalbackupstorecoverthedatabasebyusingtheRECOVERDATABASENOREDOcommandandthenusingtheRESETLOGSoptiontoopenthedatabase.

686.YouexecutethefollowingFLASHBACKTABLEcommand:

Whichtwostatementsarecorrect?

（Choosetwo.）

A.TheEMPtablethatwasdroppedbymistakeearlierisrestored.

B.TheFLASHBACKTABLEstatementisexecutedasasingletransaction.

C.TheFLASHBACKTABLEstatementdoesnotmaintainexistingindexesontheEMPtable.

D.ThechangesmadetotheEMPtablesincethespecifiedtimeareundoneifnoconstraintisviolatedduringflashback.

ViewtheEXHIBITandexaminetheoutputandcommandsexecutedontheALTBtable.

Whydoesthenumberofblocksforthetableremainthesaleaftertheshrinkoperation?

A.Becausethetabledidnotcontainmigratedorchainedrows

B.BecausetherowIDsremainthesameforallrowsduringtheshrinkoperation

C.Becausetheprogressoftheshrinkoperationisnotsavedinthebitmapblocksofthetable

D.Becausethehigh-watermark（HWM）didnotmoveduetotheCOMPACToptionthatisusedintheshrinkoperation

687.UsersareconnectedtoadatabaseinstancethatisusingAutomaticStorageManagement（ASM）.TheDBAexecutesthecommandasfollowstoshutdowntheASMinstance:

SQL>SHUTDOWNIMMEDIATE;

Whathappenstothedatabaseinstance?

A.ItshutsdownlongwiththeASMinstance.

B.ItisabortedandtheASMinstanceshutsdownnormally.

C.ItstaysopenandSHUTDOWNcommandfortheASMinstancefails.

D.ItshutsdownonlyafterallpendingtransactionsarecompletedandtheASMinstancewaitsforthisbeforeshuttingdown.

688.WhichtwostatementsaretrueaboutthecompressedbackupsinRMAN?

（Choosetwo.）

A.Compressedbackupscanonlybetakenonthetapedrives.

B.Thebinarycompressioncreatessomeperformanceoverheadduringbackupoperation.

C.TheZLIBcompressionalgorithmcanbeusedonlyiftheCOMPATIBLEinitializationparameterissetto11.1.0.

D.Themediamanagercompressionforthetapedriveshouldbeenabledfortakingcompressedbackupsonthetape.

689.ViewtheExhibitandexaminetheRMANcommands.

Whichstatementdescribestheeffectofabackupretentionpolicyonthebackupofabackupset?

A.Eitherallthecopiesofabackupsetareobsoleteornoneofthemareaspertheretentionpolicy.

B.Thecopiesofthebackupwillbereportedasobsoleteunderaredundancy-basedbackupretentionpolicy.

C.Thecopiesofthebackupwillbereportedasobsoleteunderarecoverywindow-basedbackupretentionpolicy.

D.Allthecopiesofthebackupsetarecountedasoneinstanceofabackupandwilldeletedinbackupsetexceedstheredundancy-basedbackupretentionpolicy.

690.Thedatabaseusersregularlycomplainaboutthedifficultyinperformingtransactions.Oninvestigation,youfindthatsomeusersperformlong-runningtransactionsthatconsumehugeamountsofspaceintheundotablespace,whichcausedtheproblem.Youwanttocontroltheusageoftheundotablespaceonlyfortheseusersessionsandyoudonotwantthesesessionstoperformlong-runningoperations.

Howwouldyouachievethis?

A.Implementaprofilefortheusers.

B.Implementexternalrolesfortheusers.

C.Setthethresholdfortheundotablespace.

D.ImplementaDatabaseResourceManagerplan.

691.Youworkinadatawarehouseenvironmentthatinvolvestheexecutionofcomplexqueries.ThecurrentcontentoftheSQLcachecontainstheidealworkloadforanalysis.Youwanttoanalyzeonlyafewmostresource-intensivestatements.

Whatmustyoudotoreceiverecommendationsonefficientuseofindexesandmaterializedviewstoimprovequeryperformance?

A.RuntheSQLAccessAdvisor.

B.RuntheSQ;TuningAdvisor（STA）.

C.RuntheAutomaticWorkloadRepository（AWR）report.

D.RuntheAutomaticDatabaseDiagnosticMonitor（ADDM）.

692.YourcompanywantstoupgradetheproductiondatabasetoaRealApplicationClusters（RAC）environment.YousetupthebestRACdatabaseandwanttoreplayarecordedworkloadcapturedfromtheproductiondatabaseonthetestmachine.

Thefollowingstepsmaybeusedtoreplaythedatabaseworkload:

1）Preprocessthecapturedworkload

2）RestartthedatabaseinRESTRICTEDmode.

3）SetupReplayClients.

4）Restorethetestdatabasetothepointwhenthecapturestarted.

5）Remapconnections.

Whichisthecorrectsequenceoftherequiredsteps?

A.1,4,3,5

B.1,4,5,3

C.2,1,5,3,4

D.1,2,4,5,3

693.Whichtwostatementsaretrueaboutanimagecopybackup?

（Choosetwo.）

A.Itmayonlybetakentodisk.

B.Itwillcontainonlytheusedblocks.

C.Itwillcontainallusedandunusedblocks.

D.Itcanbeperformedondiskaswellasontape.

694.Aspartofarchivingthehistoricaldata,youwanttotransferdatafromonedatabasetoanotherdatabase,whichisonanotherserver.Alltablespacesinthesourcedatabaseareread/writeandonline.Thesourceandtargetdatabasesusethesamecompatibilitylevelandcharactersets.

ViewtheExhibitandexaminethefeaturesinthesourceandtargetdatabase.

Whichofthefollowingstepsarerequiredtotransportatablespacefromthedatabasetothetargetdatabase:

1.Makethetablespaceread-onlyatthesourcedatabase.

2.Exportmetadatafromthesourcedatabase.

3.ConvertdatafiledbyusingRecoveryManager（RMAN）.

4.Transferthedumpfileanddatafiledtothetargetmachine.

5.Importmetadataatthetargetdatabase.

6.Makethetablespaceread/writeatthetargetdatabase.

A.2,4,and5

B.Allthesteps

C.2,3,4and5

D.1,2,4,5and6

695.IdentifytwooptionsthatOraclerecommendswhileconfiguringthebackupandrecoveryenvironmentforyourrecoverycatalog.（Choosetwo.）

A.configuringcontrolfileautobackuptobeON

B.backingupdatafiledonlyandnotthearchivedredologfiles

C.runningtherecoverycatalogdatabaseinNOARCHIVELOGmode.

D.settingtheretentionpolicytoaREDUNDANCYvaluegreaterthan1

E.backinguptherecoverycatalogtothesamediskasthatofthetargetdatabase

696.ExaminethefollowingcommandforRMANbackup:

WhichstatementIstrueregardingtheapproachinthecommand?

A.TheRMANmultiplexinglevelis4.

B.ItistheuseofasynchronousI/ObyRMAN.

C.Itisacaseofparallelizationofthebackupset.

D.Itisanimplementationofamultisectionbackup.

697.Whichstatementistrueabout