OracleOCP认证考试练习真题OCP083

试卷科目：OracleOCP认证考试练习OracleOCP认证考试练习真题OCP083PAGE"pagenumber"pagenumber/SECTIONPAGES"numberofpages"numberofpagesOracleOCP认证考试练习真题OCP083第1部分：单项选择题，共65题，每题只有一个正确答案,多选或少选均不得分。[单选题]1.AusercomplainsaboutpoordatabaseperformanceYouwanttoverifyiftheuser'ssessionhaswaitedforcertaintypesofI/OactivityWhichviewdisplaysallWaitswaitedonbyasessionatleastonce?A)V$SESSTATB)V$SESSIONWAITC)V$SESSIONEVENTD)V$SESSIONE)V$SESSIONWAITCLASS答案:C解析:[单选题]2.Examinethisconfiguration1CDB1isacontainerdatabaserunninginARCHIVELOGmode.2MultipleuncommittedtransactionsarerunninginCDB13Redologgroups1and2areINACTIVE4edologgroup3istheCURRENTgroupAllmembersofredologgroup3arelostbeforeitisarchivedExaminethesePossiblesteps1SHUTDOWNABORT2STARTUPNOMOUNT3STARUPMOUNT4ALTERDATABASEMOUNT5RESTOREDATABASE6RECOVERDATABASENOREDO7RECOVERDATABASEUNTILAVAILABLE8RESTOREARCHIVELOGALL9ALTERDATABASEOPEN10ALTERDATABASEOPENRESETLOGSChoosetheminimumrequiredstepsinthecorrectordertorecoverthedatabaseA)1,3,5,6,9B)1,3,5,8,6,10C)1,2,5,7,4,10D)1,3,5,7,10E)1,3,5,6,10F)1,3,5,6,10答案:D解析:[单选题]3.AschemaownertruncatedatableinerrorandmustrecoverthedataWhichOracleFlashbackfeaturecouldbeusedtorecoverthedata?A)FLASHBACKVERSIONQUERYB)FLASHBACKTABLEC)FLASHBACKTRANSACTIOND)FLASHBACKDATABASEE)FLASHBACKDATAARCHIVE答案:D解析:[单选题]4.WhichshouldbetunedfirstwhendoingaperformancetuningexerciseforanOracleDatabaseenvironment?A)logwriterperformanceB)SQLstatementsC)databaseinstancememorymanagementandsizesD)generaloperatingsystemhealthE)databasewriterperformance答案:A解析:[单选题]5.YouwanttotransporttheUNIVERSIRYtablespacefromonedatabasetoanother.Theuniversirytablespaceiscurrentlyopenread/write.Thesourceanddestinationplatformshavethesameendianformat.Examinethislistofsteps:1MaketheUNIVERSIRYtablespaceread-onlyonthesourcesystem2ExporttheUNIVERSIRYtablespacemetadatausingEXPDP3CreateacrossplatformbackupsetfromtheUNIVERSITYtablespaceonthesourcesystem.usinganRMANcommandthatincludestheDAMAPUMPclause4Copythecross-platformbackupsetstothedestinationsystem5CopytheDataPumpdumpsetfromthesourcetothedestinationsystem6Restorethecross-platformbackupsetonthedestinationsystemusinganRMANcommandthatincludesthepamapumpclause7ImporttheUNIVERSIRYtablespacemetadatausingIMPDP8MaketheUNIVERSIRYtablespaceread/writeonthedestinationsystemWhicharetheminimumnumberofstepsrequired.inthecorrectorder,totransporttheUNIVERSIRYtablespace?A)3,4,6B)1,3,4,6,8C)1,2,3,4,5,6,7,8D)2,3,4,5,6,7答案:B解析:[单选题]6.Examinethisconfiguration1CDB1isacontainerdatabase.2APP__ROOTisanapplicationrootinCDB1.3APPPDB1isanapplicationPDBinAPP_ROOT.4FLASHBACKDATABASEisON.Youexecutethesecommands:$sqlplussys/oracle_4U@localhost:1521/cdb1SQL>SELECTcurrent_scnFROMv$database;CURRENTSCN2074756SQL>CREATETABLEcdb1_tab(c1NUMBER、;Tablecreated.SQL>ALTERSESSIONSETCONTAINER=apP_root;Sessionaltered.SQL>CREATETABLEapp_root_tab(c1NUMBER、;Tablecreated.SQL>ALTERSESSIONSETCONTAINER=app_pdb1;Sessionaltered.SQL>CREATETABLEapp_pdb1_tab(c1NUMBER、;Tablecreated。SQL>conn/assysdbaConnectedWhichtableorsetoftableswillexistaftertheFlashbackoperationhascompleted?A)noneofthetables,becauseallthreetableswillbedroppedB)CDB1_TABandAPP_PDB1_TABC)CDB1_TABandAPPROOT_TABD)CDB1TABonlyE)CDB1_TAB,APP_ROOT_TAB,andAPP_PDB1_TAB答案:D解析:[单选题]7.WhichstatementcorrectlydescribestheSQLprofilingperformedbytheSQLTuningAdvisor?A)ItisasetofrecommendationsbytheoptimizertocreatenewindexesB)ItisasetofrecommendationsbytheoptimizertochangetheaccessmethodsusedC)ItisauxiliaryinformationcollectedbytheoptimizerforaSQLstatementtohelpusebetterjoinsordersD)ItisasetofrecommendationsbytheoptimizertorestructureaSQLstatementtoavoidSuboptimalexecutionplansE)ItisauxiliaryinformationcollectedbytheoptimizerforaSQLstatementtoeliminateestimationerror答案:B解析:[单选题]8.Examinethisconfiguration:1CDB1isacontainerdatabase.2COMMON_USER_PREFIXissettoanemptystring.3PDB1isapluggabledatabaseinCDB1.4APP1_ROOTisanapplicationcontainerinCDB1.5APP1_PDB1isanapplicationPDBinAPP1__ROOT.Youexecutethesecommands:Ssq1plussys/oracle@localhost:1521/cdb1assysdbaSQL>CREATEROLErole1CONTAINER=CURRENT;Whichistrue?.A)Itwillreturnanerrorbecausecreationofa1ocalroleisnotallowedinCDBSROOTB)ROLE1willbecreatedonlyinCDBSROORandApp1_ROOT.C)ROLE1willbecreatedonlyinCDBSROORD)Itwillreturnanerrorbecausecommonrolesmuststartwithc##E)ROLE1willbecreatedinCDBSROOR,PDB1,App1_Root,andAPP1PDB1答案:E解析:[单选题]9.Onthe10thofAugust,youimplementanincrementaldatabasebackupstrategyandconfigurearecoverywindowoffivedaysLeve10backupsaretakenonthe10th,17th,and24thofAugustDifferentiallevel1incrementalbackupsaretakendailybetweenthe1eve10backupTodayisthe26thofAugustWhichbackupswillbeobsolete?A)allbackupspriorto24thofAugustB)allbackupspriorto17thofAugustC)allbackupspriorto10thofAugustD)allbackupspriorto22ndofAugustE)allbackupspriorto20thofAugust答案:B解析:[单选题]10.Examinethisconfiguration1CDB1isanOracleDatabase12cRelease2containerdatabase(CDB、.2PDB1andPDB2aretwopluggabledatabases(PDBs、inCDB1.Aftersuccessfullyperformingallthepreupgradetasks,youexecutethesecommandsfromtheOracleDatabase18cenvironment:SexportORACLESID=cdb1Ssqlplus/assysdbaSQL>STARTUPUPGRADE;SQL>SHOWpdbsCON_IDCON_NAMEOPEN_MODERESTRICTED....2PDBSSEEDMIGRATEYES3PDB1MOUNTEDYES4PDB2MOUNTEDYESSQL>ALTERPLUGGABLEDATABASEpdb1OPENUPGRADE;Pluggabledatabasealtered.SQL>exit$$ORACLE_HOME/perl/bin/per1catctl.pl-C'PDB2'Whatistheoutcome?A)ItfailsbecausePDB$SEEDisinMIGRATEstateB)ItfailsbecausePDB2isnotinUPGRADEstateC)OnlyCDB$ROOT,PDB$SEED,andPDB2areupgraded.D)OnlyCDB$ROOTandPDB$SEEDareupgraded.E)CDB$ROOT,PDB$SEED,PDB1,andPDB2areupgradedF)OnlyCDB$ROOT,PDB$SEED,andPDB1areupgraded答案:F解析:[单选题]11.ExaminethisoutputofanexportfromthecurrentreleaseofanOraclemultitenantdatabase$sqlplussystem/oracleSQL>colnamefora10SQL>selectname,open_modefromv$pdbs;NAMEOPENMODEPDB$SEEDREADONLYPDB1READWRITEPDB2MOUNTEDSQL>exitNextyouexecute:$expdpsystem/oraclefull=yWhatistheoutcome?A)ItcreatesafulexportoftherootcontainerandPDB1B)ItcreatesafullexportoftherootcontainerandallopenPDBS.C)ItcreatesafullexportoftherootcontainerandallPDBSD)ItfailsbecauseDataPumpcannotbeusedwhileconnectedtotherootcontainerE)Itcreatesafullexportofonlytherootcontainer答案:E解析:[单选题]12.ApplicationPDBS,SALES_App1andSALES_App2,mustbecreatedandtheymustaccesscommontablesoftheSALES_Appapplication1InstalltheSALES_APPapplication,includingthecommontables,intheapplicationroot.2InstalltheSALES_APPapplicationintheapplicationrootandthecommontablesinboththeCDBrootAndtheapplicationroot.3Createanapplicationseed.4InstalltheSALESAPPapplicationintheapplicationseed.5CreatetheSALES_APP1andSALESAPP2applicationPDBs.6SynctheSALES_APP1andSALES_APP2applicationPDBswiththeapplicationroot.7SynctheSALES_APP1andSALES_APP2applicationPDBswiththeapplicationseed.8Synctheapplicationseedwiththeapplicationroot.Examinethesesteps:Whicharetheminimumrequiredstepsinthecorrectsequence?A)3,4,1,6,8B)1,5,6C)2,5,6D)1,3,5,7E)1,3,5,6,7答案:B解析:[单选题]13.Examinethisconfiguration1cdb1isacontainerdatabase2Thereareseveralpluggabledatabases(PDBS、inCDB15EachPDBhasseveraltableswithreferentialintegrityconstraints6FLASHBACKDAABASEisON7UNDORETENTIONGUARANTEEisenabledMultipleundesiredmultitablechangesweremadeinallthePDBSWhichmethodcanbeUsedtoundothechangesusingasinglecommandA)flashbackdatabaseB)flashbacktableandtransactionC)flashbacktransactionD)flashbacktableE)restoreandrecoverdatabase答案:C解析:[单选题]14.Examinethisconfiguration:1CDB1isanOraclecontainerdatabasefromanolderrelease.2PDB1,PDB2,PDB3,andPDB4arepluggabledatabasesinCDB1.AprioritylistUpgrdListhastheseentries:1,pdb22,pdb1,pdb3Youexecutethiscommand:$/u01/app/orac1e/product/18.1.0/db_1/rdbms/admin/dbupgrade-LUpgrdListInwhichorderwilltheupgradeoccur?A)CDB$ROOT,PDB$SEED,PDB2,PDB1,andPDB3B)CDB$ROOT,PDB$SEED,PDB2,PDB1,PDB3,andPDB4C)CDB$ROOTPDB$SEED,PDB,PDB3,PDB2,andPDB4D)CDB$ROOT,PDB2,PDB1,andPDB3E)CDB$ROOT,PDB1,PDB2,PDB3,andPDB4答案:A解析:[单选题]15.WhichoperatingsystemgroupisNOTneededtoperformanOracleDatabaseinstallation?A)OSRACDBAB)OSDBAC)OSASMD)OSKMDBAE)OSOPER答案:E解析:[单选题]16.YourCDBhastworegularPDBsaswellasoneapplicationcontainerwithtwoapplicationPDBsandanapplicationseed.NochangeshavebeenmadetothestandardPDB$SEED.HowmanydefaulttemporarytablespacescanbeassignedintheCDB?A)eightB)sixC)fiveD)threeE)seven答案:A解析:[单选题]17.Choosethebestanswer.Examinethisconfiguration:1CDB1isacontainerdatabaserunninginARCHIVELOGmode.2MultipleuncommittedtransactionsarerunninginCDB1.3Redo1oggroups1and2areINACTIVE.4Redo1oggroup3istheCURRENTgroup.Allmembersofredo1oggroup3arelostbeforeitisarchived.Examinethesepossiblesteps:1SHUTDOUNABORT2STARTUPNOMUNT3STARTUPMOUNT.4YALTERDATABASEMOUNT5RESTOREDATABASE6RECOVERDATABASENOREDO7RECOVERDATABASEUNTILAVAILABLE8RESTOREARCHIVELOGALL9ALTERDATABASEOPEN10ALTERDATAB&SEOPENRESETLOGSChoosetheminimumrequiredstepsinthecorrectordertorecoverthedatabase..A)1,3,5,6,9B)1,3,5,7,10C)1.2,5,7,4,10D)1,3,5,6,10E)1,3.,5,6,10F)1,3.5,8,6,10答案:D解析:[单选题]18.YouwanttocreateatestdatabaseasareplicaofyourproductiondatabasewithMinimuminterventionfromaDBA..Whichmethodwouldyouuse?A)UseDBC&tocreateatemplatefromtheexistingdatabasetocontainthedatabaseStructurewithdatafilesandthenusethesametemplatetocreatetheDatabaseinthenewlocation.B)UseDatabaseConfigurationAssistant(DBCA、tocreateatemplatefromtheExistingdatabasetocontainthedatabasestructure.C)UseDBC&tocreateatemplatefromtheexistingdatabasetocontaintheDatabasestructureandthenmanuallycopythedatabyusing0racleDataPump.D)CreatethedatabasebyusingtheCREATEDATABASE...commandandmanuallyImportdatabyusingDataPump.答案:A解析:[单选题]19.YourCDBhastworegularPDBsaswellasoneapplicationcontainerwithtwo.ApplicationPDBsandanapplicationseed.NochangeshavebeenmadetothestandardPDB$SEED.HowmanydefaulttemporarytablespacescanbeassignedintheCDB?A)sevenB)fiveC)eightD)threeE)six答案:C解析:[单选题]20.Choosethebestanswer.ApplicationPDBs,SALES_APP1andSALES__APP2,mustbecreatedandtheymustaccesscommontablesoftheSALES_APPapplication.Examinethesesteps:1InstalltheSALES_APPapplication,includingthecommontables,intheapplicationroot.2InstalltheSALES_APPapplicationintheapplicationrootandthecommontablesinboththeCDBrootandtheapplicationroot.3Createanapplicationseed.;4InstalltheSALES_APPapplicationintheapplicationseed..5CreatetheSALES_APP1andSALES_APP2applicationPDBs.6SynctheSALES_APP1andSALES_APP2applicationPDBswiththeapplicationroot.7SynctheSALES_APP1andSALES_APP2applicationPDBswiththeapplicationseed.8Synctheapplicationseedwiththeapplicationroot.Whicharetheminimumrequiredstepsinthecorrectsequence?A)1,3,5,7B)3,4,1,6,8C)1,3,5,6,7D)1,5,6E)2,5,6答案:D解析:[单选题]21.Choosethebestanswer.Examinethisconfiguration:1CDB1isacontainerdatabase.2COMMON__USER_PREFIXissettoanemptystring.3PDB1isapluggabledatabaseinCDB1.4APP1_ROOTisanapplicationcontainerinCDB1.5APP1_PDB1isanapplicationPDBinAPP1_R0OT.Youexecutethesecommands:$sqlplussys/oracle@localhost:1521/cdb1assysdbaSQL>CREATEROLErole1CONTAINER=CURRENT;Whichistrue?老师说选EA)ItwillreturnanerrorbecausecreationofalocalroleisnotallowedinCDB$ROOT.B)R0LE1willbecreatedonlyinCDB$ROOT.C)ItwillreturnanerrorbecausecommonrolesmuststartwithC##.D)R0LE1willbecreatedonlyinCDB$ROOTandAPP1__R0OT.E)R0LE1willbecreatedinCDB$R0OT,PDB1,APP1_R0OT,andAPP1_PDB1.答案:E解析:[单选题]22.Choosethebestanswer.Examinethisconfiguration:1CDB1isacontainerdatabase.2DEFAULT_SHARINGisMETADATA.3APP_ROOTisanapplicationrootcontainedinCDB1.4APP_PDB1isanapplicationPDBcontainedinAPPROOT.5COMPANYAPPisanapplicationcontainedinAPP_R0OT.6EMPisacommontablecreatedinAPP_ROOTandallitsapplicationPDBs,createdWhenversion1.0ofCOMPANYAPPwasinstalled.Youexecutethesecommands:$sqlplussys/oracle@localhost:1521/cdb1assysdbaSQL>ALTERSYSTEMSETDEFAULT_SHARING=DATA;Systemaltered.SQL>ALTERSESSIONSETCONTAINER=app_root;Sessionaltered.SQL>ALTERPLUGGABLEDATABASEAPPLICATIONcompanyappBEGINUPGRADE?1.0?TO?2.0?;Pluggabledatabasealtered.SQL>ALTERTABLEempADD(salNUMBERNOTNULL、;Tablealtered.SQL>ALTERPLUGGABLEDATABASEAPPLICATIONcompanyappENDUPGRADETO?2.0?;Pluggabledatabasealtered.SQL>ALTERSESSIONSETCONTAINER=app-pdb1;Sessionaltered.SQL>DESCemp;NameNu1l?TypeENONUMBERENAMEVARCHAR2(20、SQL>SELECT*FR0Memp;ENOENAME100Alan200BenSQL>ALTERPLUGGABLEDATABASEAPPLICATIONcompanyappSYNC;Whatwillbetheoutcomeandwhy?A)SALwillbeaddedtoAPP_PDB1.EMP,with0incolumnsofexistingrows.B)SALwillbe.addedtoAPP_PDB1.EMP,withNULLsincolumnsofexistingrows.C)ItwillreturnanerrorbecausetheSYNCoperationisnotallowedwhenconstraintsareaddedtocommonobjects.D)ItwillreturnanerrorbecauseEMPisnotemptyinAPP_ROOT.E)ItwillreturnanerrorbecauseEMP.SALisemptyinAPP_ROOT答案:C解析:[单选题]23.Choosethebestanswer.Examinethisconfiguration:1CDB1isacontainerdatabase.2APP_R0OTisanapplicationrootinCDB13APP_PDB1isanapplicationPDBinAPP._R0OT.4FLASHBACKDATABASEisON.Youexecutethesecommands:$sq1p1ussys/orac1e_4U@localhost:1521/cdb1SQL>SELECTcurrent_scnFR0Mv$database;CURRENT_SCN2074756SQL>ALTERSESSI0NSETCONTAINER-app_root;Sessionaltered.SQL>CREATETABLEapp_root_tab(c1NUMBER、Tablecreated.SQL>ALTERSESSI0NSETCONTAINER=app.pdb1:Sessionaltered.SQL>CREATETABLEApp_pdb1_tab(c1NUMBER、:Tablecreated.SQL>conn/assysdbaConnected.SQL>ALTERPLUGGABLEDATABASEapp_rootCLOSE:Pluggabledatabasealtered.SQL>FLASHBACKPLUGGABLEDATABASEapp_rootT0SCN2074756;F1ashbackcomplete.WhichtableorsetoftableswillexistaftertheF1ashbackoperationhascompleted?A)CDB1_TAB,APP_R00T_TAB,andAPP_PDB1_TABB)CDB1_TABandAPP_PDB1_TABC)CDB1_TABandAPP_R00T_TABD)CDB1_TABonlyE)noneofthetables,becauseallthreetableswillbedropped答案:D解析:[单选题]24.Choosethebestanswer.ExamineThisconfiguration:;1CDB1isan0racleDatabase12cRelease2containerdatabase(CDB、.2PDB1andPDB2aretwopluggabledatabases(PDBs、inCDB1.Aftersuccessfullyperformingallthepreupgradetasks,youexecutethesecommandsFromthe0racleDatabase18cenvironment:QL>ALTERPLUGGABLEDATABASEpdb10PENUPGRADE:Pluggabledatabasealtered.SQL>exit$$0RACLE_H0ME/perl/bin/perlcatct1.pl-C?PDB2?Whatistheoutcome?A)Itfai1sbecausePDB$SEED1sinMIGRATEstate.B)0nlyCDB$R00T,PDB$SEED,andPDB1areupgraded.C)0nlyCDB$R00T,PDB$SED,andPDB2areupgraded.D)ItfailsbecausePDB2isnotinUPGRADEstate.E)CDB$R00T,PDB$SEED,PDB1,andPDB2areupgraded.F)0nlyCDB$R00TandPDB$SEEDareupgraded.答案:B解析:[单选题]25.Examinethesequeriesandtheiroutput:AnonlineRJMLANbackupoftheCDBwastakenanhourbeforeRestorePointR1wascreated.YouwanttorecoverPDB1toRestorePointR1.Howdoyouachievethis?A)ExecuteFLASHBACKPLUGGABLEDATABASEPDB1T0REST0REP0INTR1byusingRMANwhileconnectedtoPDB1.B)ExecuteFLASHBACKPLUGGABLEDATABASEPDB1T0REST0REP0INTR1byusingSQLwhileconnectedtoPDB1.C)ExecuteFLASHBACKPLUGGABLEDATABASEPDB1T0REST0REP0INTR1byusingSQLwhileconnectedtoCDB$R00T.D)ExecuteFLASHBACKPLUGGABLEDATABASEPDB1T0REST0REP0INTR1byusingHANwhileconnectedtoCDB$R00T.E)Thiscannotbedoneduetothe1ackofacleanrestorepoint.答案:E解析:[单选题]26.Choosethebestanswer.Examinethisconfiguration:1CDB1isacontainerdatabase.2There.areseveralpluggabledatabases(PDBs)inCPB15EachPDBhasseveraltableswithreferentialintegrityconstraints.6FLASHBACKDATABASEisON.7UMNDORETENTITONTGUARANTEEisenabled.MultipleundesiredmultitablechangesweremadeinallthePDBs.WhichmethodcanbeusedtoundothechangesusingsinglecommandA)restoreandrecoverdatabase.B)flashbacktransactionC)flashbackdatabaseD)flashbacktableandtransactionE)flashbacktable答案:B解析:[单选题]27.Examinethisconfiguration:1The0RCL,databasedatafilesareinAutomaticStorageManagement(OracleASMDdiskgroup+DATA.2ORCLusesdiskgroup+FRAfortheFastRecoveryArea.3LISTENERisthelistenerforORCL.4Thedatabase,listener,ASMinstance,andASMdiskgroupsaremanagedbyOracleRestart.5Allcomponentsarecurrentlyshutdown.Youexecutethiscommand:$srvct1startdatabase-dORCLWhatistheoutcome?A)TheORCLdatabase,theOracleASMinstances,the+DATAand+FRAdiskGroups,andtheLISTENERarestartedB)0nlytheORCLdatabaseinstanceisstarted.C)0nlytheORCLdatabaseandtheASMinstancesarestarted.D)0nlythe0RCLdatabaseinstance,theOracleASMinstance,andthe+DATAandFRAdiskgroupsarestarted.E)OnlytheORCLdatabaseinstanceandthe+DATAandHFRAdiskgroupsarestarted答案:D解析:[单选题]28.ExaminetheRMANCommand:RMAN>RUN{ALLOCATECHANNELc1DEVICETYPEsbt:ALLOCATECHANNELc2DEVICETYPEsbt;ALLOCATECHANNELc3DEVICETYPEsbt:BACKUPINCREMENTALLEVEL=0(DATAFILE1,4,5CHANNELc1、(DATAFILE2,3,9CHANNELc2、(DATAFILE6,7,8CHANNELc3、:SQL'ALTERSYSTEMARCHIVELOGCURRENT':Whichstatementistrueaboutthecommand?A)Itusesmultisectionbackup.B)Itusesparallelizationforthebackupset.C)ItusesasynchronousI/0forthebackup.D)Itcreatescompressedbackupsets.答案:B解析:[单选题]29.YoutakeregularbackupsofoneofyourproductiondatabasesbyusingRMANwitharecoverycatalog.Y0uhaveaddedtwonewtablespacestothisdatabaseWhichmustbeincludedinfuturebackups.Whichprocessoccurswhichallowsthenewbackupstocontainthenewdatafi1es?A)Thetargetdatabasecontrolfileissynchronizedfromtherecoverycata1ogWithapartialresyncatthenextbackup.B)TherecoverycatalogissynchronizedfromthetargetdatabasecontrolfileWithafullresyncatthenextbackup.C)Thetargetdatabasecontrolfilc1ssynchronizedfromtherecoverycatalogWithafullresyncatthenextbackup.D)TherecoverycatalogissynchronizedfromthetargetdatabasecontrolfileWithapartialresyncatthenextbackup.答案:B解析:[单选题]30.ExaminetheRMANcommand;RMAN>CONFIGUREENCRYPII0NFORDATABASEON:RMLAN>BACKUPDATABASEPLUSARCHIVELOG:Whichprerequisitemustbemetbeforeaccomplishingthebackup?A)Thepasswordfortheencryptionmustbesetup.B)Oraclewalletfortheencryptionmustbesetup.C)A11thetablespacesinthedatabasemustbeencryptedD)0racleDatabaseVaultmustbeenabled.答案:B解析:[单选题]31.Choosethebestansweronthe10thofAugust,youimplementanincrementaldatabasebackupstrategyandconfigurearecoverywindowoffivedays.Level0backupsaretakenonthe10th,17th,and24thofAugust.Differentiallevel1incrementalbackupsaretakendailybetweenthelevel0backups.Todayisthe26thofAugust.Whichbackupswillbeobsolete?A)allbackupspriorto10thofAugustB)allbackupspriorto22ndofAugustC)allbackupspriorto20thofAugustD)allbackupspriorto24thofAugustE)allbackupspriorto17thofAugust答案:E解析:[单选题]32.Aschemaownertruncatedatableinerrorandmustrecoverthedata.WhichOracleFlashbackfeaturecouldbeusedtorecoverthedata?A)FLASHBACKDATABASEB)FLASHBACKTABLEC)FLASHBACKVERSIONQUERYD)FLASHBACKDATAARCHIVEE)FLASHBACKTRANSACTION答案:A解析:[单选题]33.chooseoneYouenableFlashbackDataArchiveforatableforwhichyouwanttotrackandsavealltransactionsforfouryears.Aftersometime,therequirementchangesforkeepingtransactionsfromfourtotwoyears.Youexecutethefollowingcommandtochangetherequirement:SQL>ALTERFLASHBACKARCHIVEfdalMODIFYRETENTION2YEAR;Whatistheoutcome?A)Allhistoricaldataolderthantwoyears,ifany,ispurgedfromtheflashbackarchiveFDA1.B)Anerrorisreturnedbecausetheretentionperiodcannotbereduced.C)Alltheflashbackdataarchivesarepurgedandthesubsequentlycreatedflashbackarchivesaremaintainedfortwoyears.D)Allhistoricaldataolderthantwoyears,ifany,isarchivedtoflashbacklogsandtheflashbackarchiveissettonewretentiontime.答案:A解析:[单选题]34.Examinethestatementsthatuseflashbacktechnologies:1FLASHBACKTABLEcustomersTOTIMESTAMPTO_TIMESTAMP(?2013-02-0409:30:00',YYYY-MM-DDIHI:MI:SS'、;2SELECT*FROMcustomersAsOFSCN123456;3FLASHBACKTABLEcustomersTOBEFOREDROP:4FLASHBACKDATABASETOTIMESTAMPTO_TIMESTAMP('2013-02-0409:30:00','YYYY-MM-DHH:MM:SS'、;5SELECT*FROMcustomersVERSIONSBETWEENSCN123456AND123999;6ALTERTABLEcustomersFLASHBACKARCHIVE;Whichsetofstatementsdependsontheavailabilityofrelevantundodataintheundotablespace?A)1,3,6B)1,2,5C)3,4,5D)2,3,5,6答案:B解析:[单选题]35.RMANisconnectedtoatargetdatabaseinstanceandanauxilaryinstance.Youexecutethecommand:RMAN>DUPLICATETARGETDATABASETodupdbFROMACTIVEDATABASESECTIONSIZE1G;Whatistheoutcome?A)RMANusesthepullmethodtorestorefilesusingimagecopies.B)RMANusesthepushmethodtotransferimagecopies.C)RMANusesthepushmethodtotransferbackupsets.D)RMANusesthepullmethodtorestorefilesusingbackupsets.答案:D解析:[单选题]36.ChoosethebestanswerYouwanttocreateaduplicatedatabaseDUP_DBfromyourproductiondatabasePRODonthesamehost.ThePRODdatabaseusesAutomaticStorageManagement(ASM、forstorage.RegularbackupsaretakenusingRMANconnectedtoarecoverycatalog.Youcreateanauxiliaryinstanceandwanttoexecutethecommand:RMAN>DUPLICATETARGETDATABASETodup_dbFROMACTIVEDATABASE;WhatisaprerequisiteforthesuccessfulexecutionofthiscommandA)RMANmustbeconnectedtothetargetdatabaseinstanceandtheauxiliaryinstance.B)AmostrecentbackupsetofthePRODdatabasemustexist.C)FlashbackmustbeenabledforthePRODdatabase.D)ThetargetdatabasemustbeinMOUNTstate.答案:A解析:[单选题]37.ExaminetheRMANcommands:RMAN>CONNECTTARGET?sbu@prodAsSYSBACKUP?:RMAN>CONNECTAUXILIARY"sbu@dup_dbASSYSBACKUP?;RMAN>DUPLICATETARGETDATABASETodup_dbFROMACTIVEDATABASEPASSWORDFILESECTIONSIZE400M;WhichstatementistrueabouttheDUPLICATEcommand?(chooseone、A)Itsucceedsandcreatesmultisectionbackupsetsthatareusedforactivedatabaseduplication.B)Itfailsbecausethereisnoconnectiontoarecoverycatalog.C)ItsucceedsonlyifthetargetdatabaseisinMOUNTstate.D)Itfailsbecausenoparallelchannelsareallocatedfortheauxiliarydatabase.答案:A解析:[单选题]38.Examinethisconfiguration:1CDB1isacontainerdatabaserunninginARCHIVELOGmode.2ControlfilesofCDB1aremultiplexedin'/u01/app/oracle/oradata/cDB1/controlfile/controlfile01.ctl'and'/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl'3TheonlybackupofCDB1wastakenwhenCONTROLFILEAUTOBACKwasOFF4SNAPSHOTCONTROLFILENAMEis'/u01/app/oracle/product//db_1/dbs/snapcf_cdb1.f'.WhileCDB1isopen,'/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl'accidentallydeleted.Torecoverfromthiscriticalfailure,youexecutethesecommands:$rmantargetsys/oracle_4U@localhost:1521/cdb1RMAN>SHUTDOWNABORT…OracleinstanceshutdownRMAN>STARTUPNOMOUNTRMANRESTORECONTROLFILEFROM'/u01/app/oracle/oradata/CDB1/controlfile/controlfile01.ctl';Whatwillbetheoutcome?A)Itwillcreate?$ORACLE_HOME/dbs/cdb1/CDB1/controlfile02.ctlB)Itwillcreate?/u01/app/oralce/oradata/CDB1/controlfile/controlfile02.ctl'.C)Itwillre-create?/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl?.D)Itwillcreate?/u01/app/oracle/product//db_1/dbs/snapcf_cdb1control02.ctl?.E)Itwillfailbecausethereisnoautobackupofthecontrolfiles.答案:C解析:[单选题]39.YoumusttransporttheUNIVERSITYtablespacefromonedatabasetoanother.TheUNIVERSITYtablespaceiscurrentlyopenread/write.Thesourceanddestinationplatformshavedifferentendianformats.Examinethislistofactions:1MaketheUNIVERSITYtablespaceread-onlyonthesourcesystem.2ExporttheUNIVERSITYtablespacemetadatausingEXPDP.3ConverttheUNIVERSITYtablespacedatafilestothedestinationplatformformatusingRMANonthesourcesystem.4CopytheUNIVERSITYtablespacedatafilestothedestinationsystem.5CopytheDataPumpdumpsettothedestinationsystem.6ConverttheUNIVERSITYtablespacedatafilestothedestinationplatformformatusingRMANonthedestinationsystem.7ImporttheUNIVERSITYtablespacemetadatausingIMPDP.8MaketheUNIVERSITYtablespaceread/writeonthedestinationsystem.Whichistheminimumnumberofactionsrequired,inthecorrectorder,totransporttheUNIVERSITYtablespace?A)1,2,4,5,7,8B)1,2,4,6,7,8C)1,2,3,4,5,7,8D)1,2,3,4,5,6,7,8E)2,4,5,6,7答案:B解析:[单选题]40.Choosethebestanswer.YouwanttotransporttheUNIVERSITYtablespacefromonedatabasetoanother.TheUNIVERSITYtablespaceiscurrentlyopenread/write.Thesourceanddestinationplatformshavethesameendianformat.Examinethislistofsteps:.1MaketheUNIVERSITYtablespaceread-onlyonthesourcesystem.2ExporttheUNIVERSITYtablespacemetadatausingEXPDP.3Createacross-platformbackupsetfromtheUNIVERSITYtablespaceonthesourcesystem,usinganRMANcommandthatincludestheDATAPUMPclause.4Copythecross-platformbackupsetstothedestinationsystem.5CopytheDataPumpdumpsetfromthesourcetothedestinationsystem.6Restorethecross-platformbackupsetonthedestinationsystemusinganRMANcommandthatincludestheDATAPUMPclause.7ImporttheUNIVERSITYtablespacemetadatausingIMPDP.8MaketheUNIVERSITYtablespaceread/writeonthedestinationsystem.Whicharetheminimumnumberofstepsrequired,inthecorrectorder,totransporttheUNIVERSITYtablespace?A)3,4,6B)2,3,4,5,6,7C)1,3,4,6,8D)1,2,3,4,5,6,7,8答案:C解析:[单选题]41.Choosethebestanswer.Examinethisoutputofanexportfromt