OracleOCP认证考试练习真题OCP053

试卷科目：OracleOCP认证考试练习OracleOCP认证考试练习真题OCP053PAGE"pagenumber"pagenumber/SECTIONPAGES"numberofpages"numberofpagesOracleOCP认证考试练习真题OCP053第1部分：多项选择题，共30题，每题至少两个正确答案,多选或少选均不得分。[多选题]1.youwanttoconvertanexistingdatabasebackupintoanarchivalbackupthatwillalwaysbeexemptfromtheRMANretentionpolicy.Whichtwoconditionsshouldbemetforthebackuptoconvertedsuccessfully?A)TheRESTOREPOINTClauseshouldbeusedB)ItshouldberegisteredinarecoverycatalogC)ItshouldresideinthefastrecoveryareaD)ItshouldnotresideinthefastrecoveryareaE)TheRESTOREPOINTclauseshouldnotbeused.F)Itshouldnotberegisteredinarecoverycatalog答案:BD解析:[多选题]2.WhichtwoaretrueaboutcomponentsofOracleResourceManager?A)AresourcemanagerplandirectivecanrestrictsessionsinthesameconsumergrouptoaspecificsetofCPUs.B)Aresourcemanagerplandirectivespecifieshowresourcesshouldbeallocatedamongstsessionsinthesameconsumergroup.C)Aresourcemanagerplandirectivecanspecifyresourceallocationrulesformultipleconsumergroups.D)Aresourceplancontainsdirectivesthatspecifyhowresourcesshouldbeallocatedamongstresourceconsumergroups.E)Aresourceconsumergroupcanbemanageddifferentlyindifferentresourcemanagerplans.答案:CE解析:[多选题]3.OneofyourdatabaseshasresumablespaceallocationenabledWhichtwoconditionswillsuspendasessionperformingDMLinthatdatabaseinstance?A)AdeadlockisdetectedB)TransactionreachesatablespacespacequotaC)TheDMLaffectsobjectsinatablespacethatisgoingofflineD)Atransactioncannotallocateextentsinatemporarysegment.E)Totalundospaceforasessionexceedstheamountavailable答案:AD解析:[多选题]4.Whichtwoaretrueaboutafastincrementalbackup?A)Itcanbeperformedforbothcumulativeanddifferentialincrementalbackups.B)Itcanbeenabledonlyforthewholedatabase.C)Itcanbeperformedforbothlevel0andlevel1incrementalbackups.D)ItusesablockchangetrackingfilewhentheincrementallevelisgreaterthanO.E)Itrequiresthefastrecoveryareatobeconfigured.答案:AE解析:[多选题]5.WhichtwoaretrueaboutautomaticPGAmemorymanagement?A)PGA_AGGREGATE_TARGETcannotbeconfiguredifSGA_TARGETisconfigure.B)ThepGAisauto-tunedwhetherornotPGA_AGGREGATE_TARGETisexplicitlyset.C)PGA_AGGREGATE_TARGETcannotbeconfiguredifMEMORY_TARGETisconfigured.D)MemoryisallocatedseparatelyforPGA_AGGREGATE_TARGETandSGA_TARGET.E)PGA_AGGREGATE_TARGETalwaysdefaultstozero.答案:BD解析:[多选题]6.ExaminetheseRMANcommands:RMAN>CONFIGUREDEFAULTDEVICETYPETodisk;RMAN>CONFIGUREDEVICETYPEDISKBACKUPTYPETOCOPY;RMAN>CONFIGURECONTROLFILEAUTOBACKUPON;YourdatabaseusesanSpFILE.Youissuedthiscommand:RMAN>BACKUPDATABASEPLUSARCHIVELOGDELETEINPUT;Whichthreeactionswilloccur?A)backupoftheentireSPFILEB)backuponlyofSPFILEcontentthathaschangedsincethelastbackupC)backupofonlinelogsD)backupofallusedandunusedblocksinalldatafilesE)backupofarchivedlogsF)backupofallusedblocksonly,inalldatafiles答案:ADE解析:[多选题]7.InwhichtwosituationsmustyouopenadatabasewithRESETLOGS?A)afterbringingarecoveredusertablespaceonlineB)afterperformingadatabasepoint-in-timerecoveryC)afterrecoveringfromthelossofaserverparameterfileD)afterrecoveringfromthelossofaCURRENTredologgroupE)afterrecoveringfromthelossofanACTIVEredologgroup答案:BD解析:[多选题]8.WhichthreearetrueabouttherecyclebininOracle11g?A)Adroppedtablemayalwaysbeflashedbackfromtherecyclebin.B)ObjectsintherecyclebinarestoredinthetEMptablespaceoftheschemaowner.C)IfHR.EMPLOYEESisdroppedandmovedtotherecyclebin,thenanothertablecalledHR.EMPLOYEEsmayalsobedroppedandmovedtotherecyclebin.D)Adroppedindexmaybeflashedbackfromtherecyclebin.E)Objectsintherecyclebinarestoredinthesametablespaceastheywerebeforetheyweredropped.F)Spaceoccupiedbyobjectsintherecyclebincountagainstthequotaoftheschemaowner.答案:CDE解析:第2部分：单项选择题，共24题，每题只有一个正确答案,多选或少选均不得分。[单选题]9.OneofyourdatabasesisinARCHIVELOGmode.Youexecutethesecommands:CONFIGUREDEVICETYPEDISKBACKUPTYPETOCOPY;CONFIGURECONTROLFILEAUTOBACKUPON:CONFIGUREBACKUPOPTIMIZATIONON:BACKUPDATABASE;Whatwillthebackupcontain?A)usedblocksonlyfromdatafilesandthecontrolfileB)usedandcompressedblocksonlyfromdatafilesC)allblocksfromdatafiles,thecontrolfile,theserverparameterfile(SPFILE),andarchivedredologfilesD)allblocksonlyfromdatafiles,thecontrolfile;andtheserverparameterfile(SPFILE.E)allblocksonlyfromdatafilesandthecontrolfile答案:A解析:[多选题]10.Youhaveconfiguredarchivelogdestinationsforoneofyourdatabases.Whichtwoensurelogswitchingwillonlyoccurifarchivingissuccessfultoatleasttwodestinations?A)SettheOPTIONALattributeforLoG_ARCHIVE_DEST_nforthefourdestinationsandsetLOG_ARCHIVE_MIN_SUCCEED_DESTto4.B)SettheMANDATORYattributeforLoG_ARCHIVE_DEST_nforanytwodestinationsandsetLOG_ARCHIVE_MIN_SUCCEED_DESTto1.C)ConfiguretheflashrecoveryareaandsettheLoG_ARCHIVE_MIN_SUCCEED_DESTparameterto2.D)SetLoG_ARCHIVE_DESTandLOGARCHIVEDUPLEXDESTtotwochosendestinationsandsetLoG_ARCHIVE_MIN_SUCCEED_DESTtonull.E)SettheOPTIONALattributeforLoG_ARCHIVE_DEST_nforthefourdestinationsandsetLoG_ARCHIVE_MIN_SUCCEED_DESTto2.答案:BE解析:[单选题]11.TheBOOKINGstablecontainsonlinebookinginformation.Whenabookingisconfirmed,thedetailsaretransferredtoanarchivaltableBOORINGSHISTanddeletedfromtheBooKINGStable.Thereisnofixedtimeintervalbetweeneachonlinebookinganditsconfirmation.Becausesufficientspaceisnotalwaysavailablefromthedeleteoperations,thehigh-watermark(HWM.ismovedupandmanyrowsareinsertedbelowtheHWMofthetable.TheBOOKINGStablehasAutomaticSegmentSpaceManagement(ASSM.androwmovementenabled.Thetableisaccessiblein24x7mode.WhatisthemostefficientmethodtoreclaimthespacereleasedbythedeleteoperationsintheBOORINGstable?A)MovetheBOOKINGstabletoadifferentlocationbyusingtheALTERTABLE...MOVEcommand.B)ShrinktheBOOKINGStablebyusingtheALTERTABLE...SHRINKSPACEcommand.C)PerformEXPORT,DROP,andIMPORToperationsontheBOORINGstablesequentially.D)DeallocatethespaceintheBOORINGtablebyusingtheALTERTABLE...DEALLOCATEUNUSEDcommand.答案:B解析:[单选题]12.ViewtheExhibittoexaminetheparametervalues.YouareplanningtosetthevaluefortheMEMORY_TARGETparameterofyourdatabaseinstance.Whatvaluewouldyourecommend?A)362MBB)1,440MBC)272MBD)90MB答案:A解析:[单选题]13.Inadatabaseinstance,theNLs_DATE_LANGUAGEparameterissettoAMERICANOnaclient,theNls_LANGenvironmentalvariableissettoFRENCH_CANADA.WE8ISO8859P1,Auserstartsasessionontheclientandissuesthesecommands,SQL>ALTERSESSIONSETNLS_LANGUAGE=GERMANSQL>SELECTTO_CHAR(hire_date,DD/MON/YYYY','nls_date_languag=ITALIAN?.FROMemployeesWhatistheresult?A)ThequerydisplaysabbreviatedmonthnamesinCanadianEnglish.B)ThequerydisplaysabbreviatedmonthnamesinCanadianFrench.C)ThequerydisplaysabbreviatedmonthnamesinGerman.D)ThequerydisplaysabbreviatedmonthnamesinItalian.E)ThequerydisplaysabbreviatedmonthnamesinUSEnglish.答案:D解析:[单选题]14.OneofyourdatabasesisinARCHIVELOGmode.Youexecutethesecommand:CONFIGUREDEVICETYPEDISKBACKUPTYPETOCOPY;CONFIGURECONTROLFILEAUTOBACKUPON;CONEIGUREBACKUPOPTIMIZATIONON;BACKUPDATABASE;Whatwillthebackupcontain?A)allblocksonlyfromdatafiles,thecontrolfile,andtheserverparameterfile(SPFILE.B)usedblocksonlyfromdatafilesandthecontrolfileC)usedandcompressedblocksonlyfromdatafilesD)allblocksfromdatafiles,thecontrolfile,theserverparameterfile(SPFILE),andarchivedredologfilesE)allblocksonlyfromdatafilesandthecontrolfile答案:A解析:[单选题]15.YouplantousetheFlashbackDropfeaturetorecoveradroppedtableSALES_EMP.Noothertablewiththesamenameexistsintheschema.YouqueryRECYCLEBINandfindmultipleentriesfortheSALES_EMPtableasfollows:SQL>SELECTobjectname,original_name,droptimeFROMrecyclebin;OBJECT_NAMEORIGINAL_NAMEDROPTIMEBIN$/mODrBV9RFGOAA53dC+FPW==$0SALESEMP2007-12-07:11:08:55BIN$2DeIssLeQTqgH/n80Rm2JQ==$0SALESEMP2007-12-07:11:11:38BIN$UuqrONodQy6ouDtaA+XOVw==$0SALESEMP2007-12-07:11:08:18Youthenissuethisstatementtorecoverthetable：SQL>FLASHBACKTABLEsales_empTOBEFOREDROP;Whatwouldbetheoutcomeoftheprecedingstatement?A)Itretrievesthelatestversionofthetablefromtherecyclebin.B)ItreturnsanerrorbecausethetablenameisnotspecifiedasperthenamesintheOBJECT_NAMEcolumn.C)Itretrievestheversionofthetableforwhichundoinformationisavilable.D)Itretrievestheoldestversionofthetablefromtherecyclebin.答案:A解析:[多选题]16.Youaremanaginga24X7database.Thebackupstrategyforthedatabaseistoperformuser-managedbackups.Identifytwoprerequisitestoperformthebackups.A)Thedatabasemustbeopenedinrestrictedmode.B)Thetablespacesarerequiredtobeinread-onlymodebeforetakingthebackup.C)ThedatabasemustbeconfiguredtoruninARCHIVELOGmode.D)Thetablespacesarerequiredtobeinbackupmodebeforetakingthebackup.答案:CD解析:[多选题]17.AdatabaseisrunninginARCHIVELOGmode.Youtookabinarybackupofthecontrolfile.Whichtwostatementsaretrueaboutrecoveryusingthebackupcontrolfile?A)YoumustalwaysRECOVERthedatabaseafterrestoringabackupcontrolfile,evenifnodatafileshavebeenrestored.B)Youcanonlyrestorethecontrolfiletoitsoriginallocation.C)Youcanperformonlyanincompleterecoverywithabackupcontrolfileevenifalltheonlineredologsandarchivedlogsareavailable.D)YoumustopenthedatabaserESEtloGsafterrecoveryusingabackupcontrolfile.E)Youcanonlyrestorethecontrolfiletothedefaultlocation.答案:AD解析:[单选题]18.HowcananOraclestoredprocedurebeexecutedautomaticallyeveryMondaynextmonthusingOracleScheduler?A)Configurethestoredproceduretoberuninaschedulerschedulewiththecorrectscheduleparametersandthencallthescheduleinaschedulerprogram.B)Configurethestoredproceduretoberuninaschedulerprogramandspecifytheprograminaschedulerjobwiththecorrectscheduleprogram.C)Configurethestoredproceduretoberuninaschedulerschedulewiththecorrectscheduleparametersandspecifythescheduleinaschedulerjob.D)Configurethestoredproceduretoberuninaschedulerjobandconfigureaschedulerprogramandjobinaschedulerschedulewiththecorrectschedulerparameters.E)Configurethestoredproceduretoberuninaschedulerprogramandspecifytheschedulerprograminaschedulerschedulewiththecorrectscheduleparameters答案:B解析:[多选题]19.Whichtwoaretrueaboutconfiguringthefastrecoveryarea?A)DB_FLASHBACK_RETENTION_TARGETmustbesetifdefiningaretentionpolicy.B)DB_RECOVERY_FILE_DEST_SIZEmustbesetifDB_RECOVERY_FILE_DESTisset.C)DB_RECOVERY_FILE_DESTmustbesetwhenconfiguringflashbackforthedatabase.D)ArchivelogdestinationsmustbespecifiedusingLOG_ARCHIVE_DEST_nparameters.E)USE_DB_RECOVERY_FILE_DESTmustbeexplicitlysettoLOG_ARCHIVE_DEST_10.答案:BC解析:[多选题]20.ExaminethisRecoveryManager(RMAN.command:RUN｛SETUNTILTIME?2008-01-14:21:59:00?;RESTOREDATABASE;RECOVERDATABASE;｝Thetimespecifiedisearlierthanthemostrecentbackuptakenbeforetherecovery,butolderbackupsalsoexistWhichtwoactionswilloccur?A)Alldatafilesandthecontrolflefromthemostrecentbackuppriortotherecoverywillberestored.B)AlldatafilesfromthemostrecentbackuppriortoSETTIMEwillberestoredC)Alldatafilesfromthemostrecentbackupwillberestored.D)OnlythesYsTEMdatafilefromthemostrecentbackupwillberestored.E)Allredologdatauptothesettimewillbeapplied.答案:BE解析:[单选题]21.ViewtheExhibitandexaminetheresultsoftwoqueriesexecutedintwousersessionsfromthesameclient.Whataccountsfortheformattingdifferences?A)TheNLSLANGenvironmentvariablewaschangedonthedatabasehostbeforestartingthesecondsession.B)Thesecondsessionconnectedviathelistenerbutthefirstsessionusedalocalconnection.C)Thedatabasecharactersetwaschangedbeforeexecutingthesecondquery.D)TheNISLANGenvironmentvariablewaschangedontheclientbeforestartingthesecondsession.E)Thedatabasenationalcharactersetwaschangedbeforeexecutingthesecondquery.答案:D解析:[多选题]22.ThiscommandisexecutedtoshutdownanAutomaticStorageManagement(ASM.instance:SQL>SHUTDOWNABORT;Whichtwostatementsdescribetheconsequencesoftheabovecommand?A)TheASMinstancerequiresrecoverywhenitisstarted.B)TheCSSdaemonstopsandhastoberestartedbeforetheASMinstanceisrestarted.C)ThedatabaseinstancesthatarecurrentlyclientsoftheASMinstanceareaborted.D)Thediskgroupsareorderlydismounted.答案:AC解析:[多选题]23.InwhichtwosituationsmustyouopenadatabasewithRESETLOGS?A)afterrecoveringfromthelossofanACTIVEredologgroupB)afterrecoveringfromthelossofacurrentredologgroupC)afterbringingarecoveredusertablespaceonlineD)afterperformingadatabasepoint-in-timerecoveryE)afterrecoveringfromthelossofaserverparameterfile答案:BD解析:[多选题]24.ExaminethiscommandsSQL>CREATEINDEXfrench_indexONproduct_descriptions_sort(NLSSORT(translated_name,NLS_SORT=FRENCH?));WhichtwodetermineiftheindexmightbeusedforaquerysortingontheTRANSLATED_NAMEcolumn?A)theNLS_TERRITORYenvironmentvariableonthedatabasehost.B)theNLS_TERRITORYenvironmentvariableontheclient.C)theNLS_COMPsessionparameter.D)theNLSSORTfunctionargumentsintheORDERBYclause.E)theNLS_TERRITORYdatabaseparameter.F)theNIS_SORTsessionparameter.答案:CF解析:[单选题]25.WhatistheeffectofincreasingthevalueoftheASM_POWER_LIMITparameter?A)TherebalancingoperationinanASMinstancecompletsmorequicklybutcanresultinhigherI/Ooverhead.rB)ThenumberofASMBprocessesincreases.C)ThenumberofDBWR_IO_SLAVESincreases.D)ThenumberofDBWRprocessesincreases.答案:A解析:[多选题]26.Whichtwoaretrueaboutafastincrementalbackup?A)Itrequiresthefastrecoveryareatobecknfigured.B)Itusesablockchangtrackingfilewhentheincrementalbackup.C)Itcanbeenableonlyforthewholedatabase.D)Itcanbeperformedforbothcumulativeanddifferentialincrementaibackup.E)Itcanbeperformedforbothlevel0andlevel1incrementaibackup.答案:BD解析:[多选题]27.Oneofyourdatabaseshasresumablespaceallocationenabled.Whichtwoconditionswillsuspendasessionexceedstheamountavailable.A)Totalundospaceforasessionexceedstheamountavailable.B)Atransactioncannotallocateextentsinatemporarysegment.C)Adeadlockisdetected.D)Atransactionreachesatablespacespacequota.E)TheDMLaffectobjectsinatablespacethatisgoingoffline.答案:AD解析:[多选题]28.Whichtwoaretrueaboutthecreation,configurationanduseofanRMANrecoverycatalog?A)Itcannotbecreatedinanyofthetargetdatabases.B)RESYNCCATALOGmustbeexecutedafterregisteringeachtargetdatabase.C)TherecoverycatalogownermusthavetheCREATESESSIONprivilegeandtheRECOVERY_CATALOG_OWNERrole.D)REGISTERDATABASEmustbeexecutedseparatelyforeachtargetdatabase.E)TherecoverycatalogdatabasemustbeinARCHIVELOGmode.F)Therecoverycatalogschemamustbestoredinatablespacecontainingnootherschemas.答案:CD解析:[单选题]29.Notetheseparametersettingsinyourdatabase:SGA_MAX_SIZE=1024MSGA_TARGET=700MDB_SK_CACHE_SIZE=124MLOG_BUFFER=200MYouissuedthiscommandtoincreasethevalueofDB_8K_CACHE_SIZE:SQL>ALTERSYSTEMSETDB_8K_CACH_SIZE=140M;Whatwillhappen?A)ItwillbesuccessfulonlyifthememoryisavailablefromtheautotunedcomponentsoftheSGA.B)ItwillfailbecauseanincreaseinDB_8K_CACHE_SIZEcannotbeaccommodatedwithinSGA_TARGET.C)ItwillfailbecauseanincreaseinDB_8K_CACHE_SIZEcannotbeaccommodatedwithinSGA_MAX_SIZE.D)ItwillfailbecausetheDB_8K_CACHE_SIZEparametercannotbechangeddynamically.答案:A解析:[多选题]30.WhichthreestatementsaretrueaboutAutomaticStorageManagement(ASM.inGridInfrastructure11gR2?A)ASMmirrorsattheallocationunit(AU.levelforDiskGroupswithHighRedundancy.B)ASMloadbalancingisoptionalwhenExternalRedundancyissetforaDiskGroup.C)ASMloadbalancesDiskGroupcontentacrossallASMdisksinthatDiskGroup.D)ASMloadbalancesDiskGroupcontentacrossamaximumofeightASMdisksinthatDiskGroup.E)AnASMfileisalwaysmirroredbasedontheredundancyattributeoftheDiskGroupcontainingthatfile.答案:BCE解析:[单选题]31.YouexecutedthisquerySELECToldest_flashback_scn,oldest_flashback_timeFROMV$FLASHBACK_DATABASE_LOG;Consideringthatalltheredologsareavailable,whatinformationcanyouderivefromtheoutputoftheprecedingquery?A)thesystemchangenumber(SCN.andthetimewhentheFlashbackDatabasewasenabledinthedatabaseinstanceB)thetimewhenthelastflashbackoperationinyourdatabasewasperformedC)theapproximatetimeandthelowestsystemchangenumber(SCN.towhichyoucanflashbackyourdatabaseD)thetimewhenthefirstflashbackoperationinyourdatabasewasperformed答案:C解析:[单选题]32.WhichwouldrequiretheuseofNCHAR,NVARCHAR2,andNCLOBdatatypestodisplaycharacterdatacolumnsproperly?A)whentheclientapplicationsusedifferentcharactersetsthanthedatabasecharacterset.B)Thedatabasedoesnothavetosupportmultilingualdata.C)whenthedatabaseusesanationalcharactersetandadatabasecharacterset.D)whenthedatabasedoesnotuseUnicodeforthedatabasecharacterset.E)Thedatabaseusesafixed-width,multibytecharactersetforthedatabasecharacterset.答案:B解析:[多选题]33.Whichtwoaretrueaboutdatabasepoint-in-timerecoveryforadatabaseinARCHIVELOGmode?A)Itcanuseincrementalbackups,redologs,andarchivedlogs.B)Itcanonlybeperformedifthedatabaseusesanincrementalbackupstrategy.C)Itcanbeusedtorecoverfromafaileddatabaseupgrade.D)Itcanbeperformedwhilethedatabaseisinopenormountstate.E)Itcanbeusedtorestoredatainasubsetofdatabasetables.答案:AC解析:[单选题]34.HowcanaDBAcontrolajobresourceutilizationusingOracleJobScheduler?A)byusingafilewatchertoassociatethejobwitharesourceplan.B)byusingajobclasstoassociatethejobwitharesourceconsumergroupthatismanagedbythecurrentresourcemanagerplan.C)byusingajobchaintoassociatethejobwitharesourceplan.D)byusingajobarraytoassociatethejobwitharesourceplan.E)byusingawindowtoassociatethejobwitharesourceconsumergroupthatismanagedbythecurrentresourcemanagerplan.答案:E解析:[多选题]35.AdatabaseisconfiguredinARCHIVELOGmode.YouissuedthisRMANcommandtotakebackuptomedia:BACKUPDATABASEPLUSARCHIVELOGTAGTESTDBKEEPUNTIL'SYSDATE+l'RESTOREPOINTTESTDB06;Whichtwostatementsaretrue?A)Onlinelogsarebackedup.B)Archivedlogsarebackedupiftheyhavenotyetbeenbackedup.C)Thebackupisalwaysautomaticallydeletedafteroneday.D)ThebackupiscategorizedasOBSOLETEafteroneday.E)ThebackupiscategorizedasEXPIREDafteroneday.答案:BD解析:[单选题]36.Aspartofarchivingthehistoricaldata,youwanttotransferdatafromonedatabasetoanotherdatabase,whichisonanotherserver.Alltablesbaseinthesoursedatabaseareread/writeandonline.Thesourceandtargetdatabasesusethesamecompatibilitylevelandcharactersets.ViewtheExhibltandexaminethefeaturesinthesourceandtargetdatabases.ExamIngthesesteps:第1Makethetablespaceread-onlyatthesoursedatabase.第2Exportmetadatafromthesoursedatabase.第3ConvertdatafilesbyusingRecoveryManager(RMAN.第4Transferthedumpfileanddatafilestothetargetmachine.第5Importmetadataatthetargetdatabase.第6Makethetablespaceread/writeatthetargetdatabase.Whichsetofthesestepsarerequiredtotransportatablespacefromthesourcedatabasetothetargetdatabase?A)1,2,4,5,and6B)2,4,and5C)2.3,4,and5D)allthesteps答案:A解析:[多选题]37.TheEMPtableexistsinyourschema.Youwanttoexecutethisquery:SELECTename,salFROMempASOFTIMESTAMP(SYSTIMESTAMP-INTERVAL?6?MINUTE.WHEREename=?ALLEN?;Whatarethetwominimumrequirementsforthestatementtoexecutesuccessfully?A)Rowmovementmustbeenabledforthetable.B)TheUNDO_RETENTIONparametermustbesetappropriately.C)FLASHBACKmustbesettoONforthedatabase.D)TheUNDO_MANAGEMENTparametermustbesettoauto.E)ARCHIVELOGmodemustbeenabled.答案:BD解析:[多选题]38.WhichtwostatementsaretrueaboutcompressedbackupsinRMAN?A)ThecompressionalgorithmisautomaticallyselectedbyRMAN.B)Compressedbackupscanonlybewrittenifusingamediamanager.C)Mediamanagercompressionshouldbeenabledwhenbackinguptotape.D)Binarycompressionaddssomeperformanceoverheadwhentakingbackups.答案:CD解析:[多选题]39.WhichtwoconditionsmustbemetbeforeyoucancreateanRecoveryManager(RMAN.VirtualPrivateCatalog(vpc)?A)Abasecatalogmustexist.B)Therecovery_catalog_ownerrolemustbegrantedtotheuserwhowillowntheVPC.C)Atargetdatabaseisregisteredintherecoverycatalog.D)Therecoverycatalogmustbeempty.E)ThedatabasecontainingthecatalogmustuseaFlashRecoveryArea(FRA)答案:BC解析:[单选题]40.Whichinitializationparameter(s.mustbedefinedintheOracleASMinstanceparameterfile?A)theASM_DISKGROUPandtheASM_DISKSTRINGparameters.B)theINSTANCE_TYPEandtheASM_DISKGROUPSparameters.C)onlytheINSTANCE_TYPEparameterD)onlytheASM_DISKSTRINGparameterE)onlytheASM_DISKGRoUpSparameter答案:C解析:[单选题]41.UsingRecoveryManager(RMAN),youtakeimagecopiesofaproductiondatabase?sdatafiles.Youthenrollthemforwardatregularintervals.AninstancestartupfailstoopenthedatabaseduetoanerroropeningtheUSERStablespacedatafile.Youmustrecoverthedatafileusingtheimagecopy.Examinethislistofsteps:第1Mountthedatabase.第2Takethedatafileoffline.第3Bringthetablespaceonline.第4UsetheRMANSWITCHTOcommandtoswitchtotheimagecopy.第5Recoverthedatafile.第6Openthedatabase.第7UsetheRMANRESTORETOcommandtoswitchtotheimagecopy.Whatistheminimumsequenceofstepsinthecorrectcorrectsequence?A)2,7,5,3,6B)1,2,4,6,3C)2,6,4,5,3D)1,2,6,4,5,3E)1,2,7,5,3,6答案:D解析:[多选题]42.OneofyourdatabasesisinarchivelogmodeandregisteredinanRMANcatalog.WhichtwocanaffecttheRMANrecoverywindow?A)usingthefastrecoveryarea.B)thefrequencyofcatalogresynchronization.C)thevalueofcontrol_file_record_keep_time.D)configuringbackupoptimization.E)usingbackupredundancy.答案:AE解析:[单选题]43.UsersareconnectedtoadatabaseinstancethatisusingAutomaticStorageManagement(ASM).TheDBAexecutesthecommandasfollowstodowntheASMinstance:SQL>SHUTDOWNIMMEDIATE;Whathappenstothedatabaseinstance?A)ItshutsdownonlyafterallpendingtransactionsarecompletedandtheASMinstancewaitsforthisbeforeshuttingdown.B)ItisabortedandtheASMinstanceshutsdownnormally.C)ItstaysopenandtheSHUTDOWNcommandfortheASMinstancefalls.D)ItshutsdownalongwiththeASMinstance.答案:C解析:[多选题]44.WhichthreearetrueabouttherecyclebininOracle11g?A)ObjectsintherecyclebinarestoredintheTEMPtablespaceoftheschemaowner.B)Objectsintherecyclebinarestoredinthesametablespaceastheywerebeforetheyweredropped.C)MorethanonetableoriginallycalledHR.EMPLOYEESmayresideintherecyclebin.D)Spaceoccupiedbyobjectsintherecyclebincountagainstthequotaoftheschemaowner.E)Adroppedindexmaybeflashedbackfromtherecyclebin.F)Adroppedtablemayalwaysbeflashedbackfromtherecyclebin.答案:BDF解析:[单选题]45.Inoneofyourdatabases:YouuseRecoveryManager(RMAN.toperformincrementalbackups.Youhavebackupsforthelast30days.ThedatabaseisinNOARCHIVELOGmode.Oneofitsdatafilesiscorrupt.Theonlineredologfilesarelostduetomediafailure.Theinstanceisshutdown.Examinethislistofsteps:第1StartupNOMOUNTthedatabase.第2Mountthedatabase.第3Restorethecontrolfile.第4Restorethedatabase.第5OpenthedatabaseRESETLOGS.第6RecoverthedatabaseNOREDO.第7Recoverthedatabase.第8StartupMoUNTthedatabase.Whichisthelistofrequiredstepsintorecoverthedata?A)8,3,2,4,6,5B)1,2,3,4,6,5C)8,4,7,5D)8,4,6,5E)1,3,2,4,6,5答案:C解析:[单选题]46.SQKK>selectblocksFROMuser_segmentsWHEREsegment_name=?ALTB?;#BLOCKS#704SQL>ALTERTABLEaltbSHRINKSOACECINOACT;TablealteredSQL>selectblocksFROMuser_segmentsWHEREsegment_name=?ALTB?;#BLOCKS#704whydoesthenumberofblocksforthetableremainthesaleaftertheshrinkoperation?A)BecausethetabledidnotcontainmigratedorchainedrowsB)BecausetherowIdsremainthesameforallrowsduringtheshrinkoperationC)BecausetheprogressoftheshrinkoperationisnotsavedinthebitmapblocksofthetableD)Becausethehigh-watermark(HWM.didnotmoveduetotheCoMPACToptionthatisusedintheshrinkoperation答案:D解析:[单选题]47.ViewtheseSQLstatements:TransactionT1INSERTINTOhr.regionsVALUES(5,?Pole?.COMMIT;TransactionT2UPDATEhr.regionsSETregion_name='poles'WHEREregion_id=5;COMMIT;TransactionT3UPDATEhr.regionsSETregion_name='NorthandSouthPoles'WHERERegion_id=5;YourrequirementistobackouttransactionT2.Whatisthepossibility?A)ItisnotpossiblebecausetransactionT2conflictswithtransactionT3.B)ItispossiblewiththeNONCONELICT_ONLYoption.C)Itispossible,buttransactionT3wouldalsobebackedout.D)ItispossiblewiththeNOCASCADE_FORCEoption.答案:C解析:[单选题]48.Youhaveconfiguredflashrecoveryareaandyousettheseparameters:LOG_ARCHIVE_DEST_1='LOCATION=/disk1/archMANDATORY'LOG_ARCHIVE_DEST_2='LOCATION=/disk2/arch'LOG_ARCHIVE_DEST_3='LOCATION=/disks3/arch'LOG_ARCHIVE_DEST_4='LOCATION=/disk4/arch'LOG_ARCHIVE_MIN_SUCCEED_DEST=2Whilethedatabaseinstanceisrunning,youdiscoverthattheLOG_ARCHIVE_DEST_1destinationdoesnotexist.Whathappensinaneventofanattemptedlogswitchbacktothefirstloggrouponcethelastloggroupbecomesfull?A)ThelogisarchivedtotheflashrecoveryareauntiltheMANdATORYdestinationismadeavailable.B)Thedatabaseinstancewillcrash.C)Thefirstloggroupfilesarenotoverwrittenandanytransactionswillhang.D)Thelogisarchivedtothenexttwoavailablelocations.答案:C解析:[多选题]49.YouwanttotakethebackupoftheUsERstablespace.Ithasas