OracleOCP認證考試練習(xí)真題1Z0-063英文

試卷科目：OracleOCP認證考試練習(xí)OracleOCP認證考試練習(xí)真題1Z0-063英文PAGE"pagenumber"pagenumber/SECTIONPAGES"numberofpages"numberofpagesOracleOCP認證考試練習(xí)真題1Z0-063英文第1部分：單項選擇題，共134題，每題只有一個正確答案,多選或少選均不得分。[單選題]1.Youareadministeringamultitenantcontainerdatabase(CDB)cdb1.Examinethecommandanditsoutput:SQL>showparameterfileNAMETYPEVALUEDb_create_file_deststringDb_file_name_converstringDb_filesstring200Youverifythatsufficientdiskspaceisavailableandthatnofilecurrentlyexistsinthe?/u0l/app/oracle/oradata/cdb1/salesdb'location.Youplantocreateanewpluggabledatabase(PDB)byusingthecommand:SQL>CREATEPLUGGABLEDATABASESALESPDBADMINUSERsalesadmIDENTIFIEDBYpasswordROLES=(dba)DEFAULTTABLESPACEsalesDATAFILE'/u01/app/oracle/oradata/cdb1/salesdb/sales01.dbf?SIZE250MAUTOEXTENDONFILE_NAME_CONVERT=(?/u01/app/oracle/oradata/cdb1/pdbseed/','/u01/app/oracle/oradata/cdb1/salesdb/')STORAGE(MAXSIZE2G)PATH_PREFIX='/u01/app/oracle/oradata/cdb1/SALESPDB';Whichstatementistrue?A)SALESPDBiscreatedandisinmountstate.B)PDBcreationfailsbecausetheDB_file_name_convertparameterisnotsetintheCDB.C)SALESPDBiscreatedandisinread/writemode.D)PDBcreationfailsbecauseadefaulttemporarytablespaceisnotdefinedforSALESPDB.答案:A解析:[單選題]2.Youareadministeringamultitenantcontainerdatabase(CDB)thatcontainsmultiplePluggabledatabases(PDBs).Youareconnectedtocdb$rootasthesysuser.Youexecutethecommands:SQL>CREATEUSERC##ADMINIDENTIFIEDBYorcl123;SQL>CREATEROLEC##CONNECT;SQL>GRANTCREATESESSION,CREATETABLE,SELECTANYTABLETOC##CONNECT;SQL>GRANTC##CONNECTtoC##ADMINCONTAINER=ALL;Whichstatementistrueaboutthec##connectrole?A)Itiscreatedonlyincdb$rootandcannotbegrantedtothec##adminuserwiththeContainer=allclause.B)Itisgrantedtothec##adminuseronlyintheCDB.C)Itisgrantedtothec##adminuserinallPDBsandcanbegrantedonlytoalocaluserinaPDB.D)Itisgrantedtothec##adminuserinallPDBsandcanbegrantedobjectandsystemPrivilegesforaPDB.答案:D解析:[單選題]3.Examinethecommand:$expdpSYSTEMFULL=YDUMPFILE=dpump_dir1:full1%U.dmp,dpump_dir2:full2%U.dmp,Dpump_dir3:full3%U.dmpFILESIZE=400MPARALLEL=3JOB_NAME=expfullWhichstatementistrueabouttheexecutionofthecommand?A)Itfailsbecausethelogfileparameterisnotspecified.B)Itfailsbecausenoabsolutepathisspecifiedforthelogfileanddumpfile.C)Itsucceedsandexportsthefulldatabase,simultaneouslycreatingthreecopiesofdumpFilesatthreedifferentlocations.D)Itsucceedsandexportsthefulldatabase,simultaneouslycreatingthreedumpfilesatthreeDifferentlocations,butthetotalnumberofdumpfilescanexceedthree.答案:D解析:[單選題]4.YouareadministeringadatabasethatsupportsdatawarehousingworkloadandIsRunninginnoarchivelogmode.YouuseRMANtoperformalevel0backuponSundaysandLevel1Incrementalbackupsonalltheotherdaysoftheweek.OneofthedatafilesiscorruptedandthecurrentonlineredologfileislostbecauseofaMediafailure.Youwanttorecoverthedatafile.Examinethestepsinvolvedintherecoveryprocess:(1.Shutdownthedatabaseinstance.(2.Startupthedatabaseinstanceinnomountstate.(3.Mountthedatabase.(4.Takethedatafileoffline.(5.Putthedatafileonline.(6.Restorethecontrolfile.(7.Restorethedatabase.(8.Restorethedatafile.(9.Openthedatabasewiththeresetlogsoption.(10.Recoverthedatabasewiththenoredooption.(11.Recoverthedatafilewiththenoredooption.Identifytherequiredstepsinthecorrectorder.A)4,8,11,5B)1,3,8,11,9C)1,2,6,3,7,10,9D)1,3,7,10,9E)1,2,6,3,8,11,9答案:C解析:[單選題]5.YouexecutetheRMANcommands:BACKUPVALIDATEDATABASE;RMAN>RECOVERCORRUPTIONLIST;Whichtaskisperformedbythesecommands?A)Corruptedblocks,ifany,arerepairedinthebackupcreated.B)Onlythosedatafilesthathavecorruptedblocksarebackedup.C)CorruptedblocksinthedatafilesarecheckedandrepairedbeforeperformingtheDatabasebackup.D)ThedatabaseischeckedforphysicallycorruptblocksandanycorruptedblocksareRepaired.答案:D解析:[單選題]6.Yourmultitenantcontainerdatabase(CDB)containsmultiplepluggabledatabases(PDBs).Youexecutethecommandtocreateacommonuser:SQL>CREATEUSERc##a_adminIDENTIFIEDBYpasswordDEFAULTTABLESPACEusersQUOTA100MONusersTEMPORARYTABLESPACEtemp;Whichstatementistrueabouttheexecutionofthecommand?A)ThecommonuseriscreatedintheCDBandallthePDBs,andusestheusersandtempTablespacesoftheCDBtostoreschemaobjects.B)ThecommandsucceedsonlyifallthPDBshavetheusersandtemptablespaces.C)Thecommandgivesanerrorbecausethecontainer=allclauseismissing.D)ThecommandsucceedsandsetsthedefaultpermanenttablespaceofaPDBasthedefaulttablespaceforthec##a_adminuseriftheuserstablespacedoesnotexistinthatPDB.答案:A解析:[單選題]7.YouwanttoconsolidatedatabasesfortheCRM,ERP,andSCMapplicationsbymigratingthemtopluggabledatabases(PDBs).YouhavealreadycreatedatestsystemtosupporttheConsolidationofdatabasesinamultitenantcontainerdatabase(CDB)thathasmultiplePDBs.Whatistheeasiestwaytoperformcapacityplanningforconsolidation?A)capturingthemostresource-intensiveSQLstatementsinaSQLTuningSetontheProductionsystemandusingtheSQLPerformanceAnalyzeronthetestsystemB)capturingtheworkloadontheproductionsystemandreplayingtheworkloadforonePDBatatimeonthetestsystemC)capturingtheworkloadontheproductionsystemandusingConsolidatedDatabaseReplaytoreplaytheworkloadofallproductionsystemssimultaneouslyforallPDBsD)capturingthemostresource-intensiveSQLstatementsinaSQLTuningSetontheProductionsystemandusingtheSQLTuningAdvisoronthetestsystem答案:C解析:[單選題]8.YouarerequiredtomigrateyourdatabasetoanOracle12cdatabase.ExamineThelistofstepsthatmightbeusedtoaccomplishthistask:(1.Placealluser-definedtablespacesinread-onlymodeonthesourcedatabase.(2.UsetheRMANconvertcommandtoconvertdatafilestothetargetplatform'sendianformat,ifrequired.(3.PerformafulltransportableexportonthesourcedatabasewiththeparametersVERSI0N=I2,TRANSPORTABLE=ALWAYS,andFULL=Y.(4.Transportthedatafilesforalltheuser-definedtablespaces.(5.Transporttheexportdumpfiletothetargetdatabase.(6.Performanimportonthetargetdatabasebyusingthefull,network_link,andTransportable_datafilesparameters.(7.Performanimportonthetargetdatabasebyusingthefullandtransportable_datafilesParameters.Identifytherequiredstepsinthecorrectorder.A)1,3,5,4,2,and6B)1,2,4,6,5,3,and7C)1,2,4,and7D)2,4,5,6,and7答案:A解析:[單選題]9.Becauseoflogicalcorruptionofdatainatable,youwanttorecoverthetablefromanRMANbackuptoaspecifiedpointintime.ExaminethestepstorecoverthistablefromanRMANbackup:(1.Determinewhichbackupcontainsthetablethatneedstoberecovered.(2.IssuetherecovertableRMANcommandwithanauxiliarydestinationdefinedandthePointintimespecified.(3.ImporttheDataPumpexportdumpfileintotheauxiliaryinstance.(4.CreateaDataPumpexportdumpfilethatcontainstherecoveredtableonatargetDatabase.Identifytherequiredstepsinthecorrectorder.A)1,4,3B)1,2C)1,4,3,2D)1,2,4答案:B解析:[單選題]10.Yourdatabaseisrunninginarchivelogmode.Examinetheinitializationparametersyouplantosetforyourdatabaseinstance.LOG_ARCHIVE_DEST_1='LOCATION=/disk1/arch'LOG_ARCHIVE_DEST_2='L0CATI0N=/disk2/arch'LOG_ARCHIVE_DEST_3='LOCATION=/disk3/arch'L0G_ARCHIVE_DEST_4='L0CATI0N=/disk4/archMANDATORY'Identifythestatementthatcorrectlydescribesthesesettings.A)AnonlineredologfileisnotallowedtobeoverwrittenifthearchivedlogfilecannotbeCreatedinanyofthelog_archive_dest_.ndestinations.B)Optionaldestinationscannotusethefastrecoveryarea.C)AnonlineredologfileisnotallowedtobeoverwrittenifthearchivedlogfilecannotbeCreatedinthelocationspecifiedforlog_archive_dest_4.D)Thesesettingsworkonlyiflog_archive_min_succeed_destissettoavalueof4.答案:C解析:[單選題]11.InadatabasesupportinganOLTPworkload,tablesarefrequentlyupdatedonbothkeyAndnon-keycolumns.Reportsarealsogeneratedbyjoiningmultipletables.WhichtableorganizationortypewouldprovidethebestperformanceforthishybridWorkload?A)heaptablewithaprimarykeyindexB)externaltableC)hashclusteredtableD)globaltemporarytableE)indexclusteredtable答案:A解析:[單選題]12.YourdatabasesupportsaDecisionSupportSystem(DSS)workloadthatinvolvestheExecutionofcomplexqueries.Currently,thedatabaseisrunningwithpeakworkload.YouWanttoanalyzesomeofthemostresource-intensivestatementscachedinthelibrarycache.WhatmustyouruntoreceiverecommendationsontheefficientuseofindexesandMaterializedviewstoimprovequeryperformance?A)PerformanceAnalyzerB)SQLAccessAdvisorC)SQLTuningAdvisorD)AuaticWorkloadRepository(AWR)reportE)AutomaticDatabaseDiagnosticMonitor(ADDM)答案:B解析:[單選題]13.YouissuecommandsinSQL*PlusastheOracleowner,toenablemultithreadingforyourUNIX-basedOracle12cdatabase:CONNECT/ASSYSDBAALTERSYSTEMSETTHREADEDEXECUTION=TRUESCOPE=SPFILE;SHUTDOWNIMMEDIATEYouthenrestarttheinstanceandgetanerror:STARTUPORA-01031:insufficientprivilegesWhydoesthestartupcommandreturntheerrorshown?A)becausethethreadedarchitecturerequiresexitingfromsql*pIusandreconnectingwithSql*PIus/assysdbabeforeissuingastartupcommandB)becausethethreadedarchitecturerequiresissuinganewconnect/assysdbafromwithinSql*pIusbeforeissuingastartupcommandC)becausethethreadedarchitecturerequiresauthenticationusingapasswordfilebeforeIssuingastartupcommandD)becausethethreadedarchitecturerequiresconnectingtotheinstanceviaalistenerbeforeIssuingastartupcommandE)becausethethreadedarchitecturerequiresrestartingthelistenerbeforeissuingastartupCommand答案:C解析:[單選題]14.Yourproductiondatabaseisrunninginarchivelogmode.YouuseRMANwitharecoveryCatalogtobackupyourdatabasetomediaandthedatabaseisuniquelyidentifiedintheRecoverycatalog.YouwanttocreateatestdatabasefromtheproductiondatabaseandallowtheproductionDatabasetoremainopenduringtheduplicateprocess.YourestorethedatabasebackupstoanewhostwiththesamedirectorystructureastheproductiondatabaseandwanttousetheRecoverycatalogforfuturebackupsafterthedatabaseissuccessfullyrestoredtothenewHost.Howwouldyouachievethis?A)byusingtheRMANswitchcommandtosetthenewlocationforthedatafilesB)byusingtheRMANduplicatecommandwithnofilenamechecktorecoverthedatabasetothenewhostC)byusingtheRMANduplicatecommandwithdbidandsetnewnamefortablespacetoRecoverthedatabasetothenewhostD)bycreatinganewdatabaseinthenewhost,andthenusingtheRMANrecovercommand答案:B解析:[單選題]15.Youspecifiedthewarningandcriticalthresholdsforalocallymanagedtablespacetobe60%and70%,respectively.Fromthetablespacespaceusagemetrics,youfindthatthespaceUsagehasreachedthespecifiedwarningthresholdvalue,butnoalertshavebeengenerated.Whatcouldbethereasonforthis?A)Theeventparameterwasnotset.B)Thesql_traceparameterissettofalse.C)EnterpriseManagerwasnotused.D)Thestatistics_levelparameterissettobasic.E)Thetime_statisticsparameterissettofalse.答案:D解析:[單選題]16.Yourdatabaseisrunninginnoarchivelogmode.OneofthedatafileslongingtotheSystemtablespaceiscorrupted.YounoticethatallonlineredologshavebeenoverwrittenSincethelastbackup.Whichmethodwouldyouusetorecoverthedatafile?A)Shutdowntheinstanceifnotalreadyshutdown,restorealldatafilesbelongingtotheSystemtablespacefromthelastbackup,andrestarttheinstance.B)Shutdowntheinstanceifnotalreadyshutdown,restorethecorrupteddatafilebelongingTothesystemtablespacefromthelastbackup,andrestarttheinstance.C)Shutdowntheinstanceifnotalreadyshutdown,restorealldatafilesfortheentireDatabasefromthelastbackup,andrestarttheinstance.D)Mountthedatabase,restorealldatafilesbelongingtothesystemtablespacefromthelastbackup,andopenthedatabase.答案:C解析:[單選題]17.Youwanttoreducefragmentationandreclaimunusedspaceforthesalestablebutnotitsdependentobjects.Duringthisoperation,youwanttoensurethefollowing:I.Long-runningqueriesarenotaffected.Ii.Noextraspaceisused.Iii.Datamanipulationlanguage(DML)operationsonthetablesucceedatalltimesthroughouttheprocess.Iv.Unusedspaceisreclaimedbothaboveandbelowthehighwatermark.WhichalterTABLEOptionwouldyourecommend?A)DEALLOCATEUNUSEDB)SHRINKSPACEASCADEC)SHRINKSPACECOMPACTD)ROWSTORECOMPRESSBASIC答案:C解析:[單選題]18.Youwishtocreatejobstosatisfytheserequirements:(1.Automaticallybulkloaddatafromaflatfile.(2.RebuildindexesontheSALEStableaftercompletionofthebulkload.Howwouldyoucreatethesejobs?A)CreatebothjobsbyusingSchedulerraisedevents.B)Createbothjobsusingapplicationraisedevents.C)CreateonejobtorebuildindexesusingapplicationraisedeventsandanotherjobtoPerformbulkloadusingSchedulerraisedevents.D)CreateonejobtorebuildindexesusingSchedulerraisedeventsandanotherjobtoPerformbulkloadbyusingeventsraisedbytheapplication.答案:D解析:[單選題]19.Examinethebackuprequirementforyourcompany:1)EverySunday,abackupofalluseddatafileblocksisperformed.2)EveryWednesdayandFriday,abackupofallthechangedblockssincelastSunday'sBackupisperformed.3)Onalltheotherdays,abackupofonlythechangedblockssincethelastday'sbackupisPerformed.Whichbackupstrategysatisfiestherequirements?A)level0backuponSunday,cumulativeincrementalbackuponWednesdayandFriday,andDifferentialincrementallevel1backuponalltheotherdaysB)level0backuponSunday,differentialincrementalbackuponWednesdayandFriday,andCumulativeincrementallevel1backuponalltheotherdaysC)fulldatabasebackuponSunday,level0backuponWednesdayandFriday,andcumulativeIncrementallevel1backuponalltheotherdaysD)fulldatabsebackuponSunday,level0backuponWednesdayandFriday,anddifferentialIncrementallevel1backuponalltheotherdays答案:A解析:[單選題]20.Considerthefollowingscenarioforyourdatabase:-BackupoptimizationisenabledinRMAN.-recoverywindowissettosevendaysinRMAN.-mostrecentbackuptodiskforthetoolstablespacewastakenonMarch1,2013.-Thetoolstablespaceisread-onlysinceMarch2,2013.OnMarch15,2013,youissuetheRMANcommandtobackupthedatabasetodisk.Whichstatementistrueaboutthebackupofthetoolstablespace?A)TheRMANbackupfailsbecausethetoolstablespaceisread-only.B)RMANskipsthebackupofthetoolstablespacebecausebackupoptimizationisenabled.C)RMANcreatesabackupofthetoolstablespacebecausebackupoptimizationisapplicableonlyforthebackupswrittentomedia.D)RMANcreatesabackupofthetoolstablespacebecausenobackupofthetablespaceexistsWithintheseven-dayrecoverywindow.答案:D解析:[單選題]21.YourestoreandrecoveryourdatabasetoanewhostbyusinganexistingRMANopenDatabasebackup.Whichstepmustyouperformnext?A)Executecatproc.sqltorecompileinvalidPL/SQLmodules.B)Openthedatabasewiththeresetlogsoption.C)Setanewdatabaseidentifier(DBID)forthenewlyrestoreddatabase.D)UsetheRMANsetnewnameandswitchcommandstoswitchtonewfiles.答案:B解析:[單選題]22.ExaminetheRMANcommand:CONFIGUREENCRYPTIONFORDATABASEON;RMAN>BACKUPDATABASEPLUSARCHIVELOG;Whichprerequisitemustbemetbeforeaccomplishingthebackup?A)Thepasswordfortheencryptionmustbesetup.B)Oraclewalletfortheencryptionmustbesetup.C)Allthetablespacesinthedatabasemustbeencrypted.D)OracleDatabaseVaultmustbeenabled.答案:B解析:[單選題]23.InwhichsituationcanyouuseFlashbackDatabase?A)whenundoingashrinkdatafileoperationB)whenretrievingadroppedtablespaceC)whenreturningtoapointintimebeforetherestorationorre-creationofacontrolfileD)whenreturningtoapointintimebeforethemostrecentopenresetlogsoperation答案:D解析:[單選題]24.YoucreateadefaultFlashbackDataArchiveFLA1andenableitfortheEMPLOYEEStableIntheHRschema.Afterafewdays,youwanttoaltertheEMPLOYEEStablebyexecutingthecommand:SQL>ALTERTABLEEMPLOYEESADDPHONENUMBER(12);Whichstatementistrueabouttheexecutionofthecommand?A)ItgivesanerrorbecauseDDLstatementscannotbeexecutedonatablethatisenabledforFlashbackDataArchive.B)ItexecutessuccessfullyandallmetadatarelatedtotheEMPLOYEEStablebeforealteringThetabledefinitionispurgedfromFlashbackDataArchive.C)ItexecutessuccessfullyandcontinuestostoremetadatarelatedtotheEMPLOYEEStable.D)ItexecutessuccessfullybutFlashbackDataArchiveisdisabledfortheEMPLOYEEStable.答案:C解析:[單選題]25.Youwanttobackupadatabasesuchthatonlyformattedblocksarebackedup.Whichstatementistrueaboutthisbackupoperation?A)Thebackupmustbeperformedinmountstate.B)Thetablespacemustbetakenoffline.C)Allfilesmustbebackedupasbackupsets.D)Thedatabasemustbebackedupasanimagecopy.答案:C解析:[單選題]26.Yourdatabaseisrunninginarchivelogmodeandregularnightlybackupsaretaken.Duetoamediafailure,thecurrentonlineredologgroup,whichhasonemember,islostandtheinstanceisaborted.Examinethestepstorecovertheonlineredologgroupandmoveittoanewlocation.1).Restorethecorruptedredologgroup.2).Restorethedatabasefromthemostrecentdatabasebackup.3).Performanincompleterecovery.4).Relocatethememberofedamagedonlineredologgrouptoanewlocation.5).Openthedatabasewiththeresetlogsoption.6).Issueacheckpointandclearthelog.Identifytherequiredstepsinthecorrectorder.A)1,3,4,5B)6,3,4,5C)2,3,4,5D)6,4,3,5答案:C解析:[單選題]27.LDAP_DIRECTORY_SYSAUTHissettoYES.UsersrequiringDBAsaccesshavebeengrantedthesysdbaenterpriseroleinOracleInternetDirectory(OID)SSLhasbeenconfigureforthedatabaseandOIDandthepasswordfilehasbeenconfiguredForthedatabase.Userscottwithsysdbaprivilegetriestoconnectremotelyusingthiscommand:$sqlplusscott/tiger@DB0lAssysdbaWhereDB01isthenetservicename.Whichauthenticationmethodwillbeattemptedfirst?A)authenticationbypasswordfileB)authenticationbyusingcertificatesoverSSLC)authenticationbyusingtheOracleInternetDirectoryD)authenticationbyusingthelocalOSofthedatabaseserver答案:A解析:[單選題]28.YouhaveaproductionOracle12cdatabaserunningonahost.YouwanttoinstallandCreatedatabasesacrossmultiplenewmachinesthatdonothaveanyOracledatabaseSoftwareinstalled.YoualsowantthenewdatabasestohavethesamedirectorystructureandComponentsasyourexisting12cdatabase.Thestepsinrandomorder:1).Createdirectorystructuressimilartotheproductiondatabaseonallnewmachines.2).CreatearesponsefileforOracleUniversalInstaller(OUI)withthesameconfigurationsastheproductiondatabase.3).Createadatabaseclonetemplateforthedatabase.4).theDatabaseConfigurationAssistant(DBCA)tocreatethedatabase.5).graphicalmodeoneachmachine.6).RunOUIinsilentmodeusingtheOUIresponsefile.IdentifytherequiredstepsinthecorrectsequencetoachievetherequirementwithminimalHumanintervention.A)2,1,6,and4B)2,3,and6C)3,1,5,and6D)2,3,1,and6E)1,5,and4答案:D解析:[單選題]29.Yourdatabasehasatablecustomersthatcontainsthecolumnscust_name,amt_due,andold_status.Examinethecommandsexecutedandtheiroutput:SQL>UPDATEcustomersSETamt_due=amt_due+amt_due*l.1WHEREcust_name='JAMES';1rowupdated.SQL>ALTERTABLEcustomersDROPCOLUMNold_status;TableAlteredSQL>UPDATEcustomersSETamt_due=amt_due+amt_due*1.5WHEREcust_name='JAMES';1rowupdated.SQL>COMMIT;SQL>SELECTversions_xidASXID,versions_startscnASSTART_SCN,Vions_endscnASEND_SCN,versions_operationASOPERATION,amt_dueFROMCustomersVERSIONSBETWEENSCNMINVALULEANDMAXVALUEWHEREcustname='JAMES';XIDSTART_SCNEND_SCNOPERATIONAMT_DUE07002f00cl03000017063371706337U3300WhyisitthatonlyoneupdateislistedbytheFlashbackVersionQuery?A)Supplementalloggingisnotenabledforthedatabase.B)Theundodatathatexistedforversionsofrowsbeforethechangetothetablestructureisinvalidated.C)Thedb_flashback_retention_targetparameterissettoalowervalueandtheundodataPertainingtothefirsttransactionisflushedout.D)Undoretentionguaranteeisnotenabled.E)FlashbackDataArchiveisfullafterthefirstupdatestatement.答案:B解析:[單選題]30.WhenistheUNDO_RETENTIONparametervalueignoredbyatransaction?A)whenthedatafileofthtablespaceisautoextensibleB)whentherearemultipleundotablespacesavailableinadatabaseC)whentheundotablespaceisofafixedsizeandretentionguaranteeisnotenabledD)whenFlashbackDatabaseisenabled答案:D解析:[單選題]31.YouwanttocapturecolumngroupusageandgatherextendedstatisticsforbetterCardinalityestimatesforthecustomerstableintheSHschema.Examinethefollowingsteps:1).IssuetheSELECTDBMS_STATS.CREATE_EXTENDED_STATS(?SH?,'CUSTOMERS')fromDualstatement.2).Executethedbms_stats.seed_col_usage(null,?SH?,500)procedure.3).Executetherequiredqueriesonthecustomerstable.4).Issuetheselectdbms_stats.report_col_usage(?SH?,'customers')fromdualstatement.Identifythecorrectsequenceofsteps.A)3,2,1,4B)2,3,4,1C)4,1,3,2D)3,2,4,1答案:B解析:[單選題]32.Examinethesteps/operationsperformedduringtheRMANbackupoperationbyusingOracleSecureBackup(OSB):1).StarttheRMANtarget/command.2).StarttheRMANclientbyusingtheOSBuser.3).RMANcreatesthebackuppieces.4).RuntheRMANbackupcommandwiththesbtchannels.5).OSBcreatesabackupjobandassignsauniqueidentifier.6).OSBcreatesabackupjobrequestthroughtheOSBsbtlibrary.7).OSBstoresmetadataaboutRMANbackuppiecesintheOSBcatalog.8).OSBstartsthebackupoperation.9).OSBupdatestheRMANcatalog.Identifytherequiredsteps/operationsperformedincorrectorder.A)1,4,6,5,8,3,9B)1,6,4,5,8,3,9C)2,4,6,5,8,3,7D)2,4,5,8,3,7,9答案:C解析:[單選題]33.Theenvironmentalvariableoracle_Baseissetto/u01/app/oracleandoracle_homeissetto/u01/app/oracle/product/12.1.0/db_1.YouwanttocheckthedgnosticfilescreatedaspartoftheAutomaticDiagnosticRepository(ADR).Examinetheinitializationparameterssetinyourdatabase.WhatisthelocationoftheADRbase?A)Itissetto/u01/app/oracle/product:/12.1.0/db_1/log.B)Itissetto/u01/app/oracle/admin/eml2rep/adump.C)Itissetto/u01/app/oracle.D)Itissetto/u01/app/oracle/flash_recovery_area.答案:C解析:[單選題]34.ExaminethestepstoconfigureOracleSecureBackup(OSB)forusewithRMAN:1).Createmediafamiliesfordatafilesandarchivedredologfiles.2).ConfiguredatabasebackupstorageselectorsorRMANmediamanagementparameters.3).CreateanOSBuserpreauthorizedforRMANoperations.4).ConfigureRMANAccesstotheOSBSBT.5).DisableNon-UniformMemoryAccess(NUMA)awarenessbysettingtheob_ignore_numaParameterto0.Identifythestepsinthecorrectorder.A)1,4,3,2,5B)1,3,4,5,2C)4,3,1,2,5D)4,3,5,1,2答案:C解析:[單選題]35.Youareadministeringamultitenantcontainerdatabase(CDB)thatcontainstwoPluggabledatabases(PDBs),pdb1andpdb2.Youareconnectedtopdb2asacommonuserWithDBAprivileges.Thestatistics_levelparameterisPDBmodifiable.Astheusersys,executethefollowingcommandonpdb2:SQL>ALTERSYSTEMSETSTATISTICS_LEVEL=ALLSID='*'SCOPE=SPFILE;Whichstatementistrueabouttheresultofthiscommand?A)Thestatistics_levelparameterissettoallwhenanyofthePDBsisreopened.B)Thestatistics_levelparameterissettoallonlyforPDB2whenitisreopened.C)Thestatistics_levelparameterissettoallwhentherootdatabaseisrestarted.D)ThestatementisignoredbecausethereisnoSPFILEforaPDB.答案:B解析:[單選題]36.WhichstatementistrueaboutthelossordamageofatempfilethatbelongstotheTemporarytablespaceofapluggabledatabase(PDB)?A)ThePDBisclosedandthetempfileisre-createdautomaticallywhenthePDBisopened.B)ThePDBisclosedandrequiresmediarecoveryatthePDBlevel.C)ThePDBdoesnotcloseandthetempfileisre-createdautomaticallywhenevertheContainerdatabase(CDB)isopened.D)ThePDBdoesnotcloseandstartsbyusingthedefaulttemporarytablespacedefinedforTheCDB.答案:A解析:[單選題]37.Atelecomcompanywishestogeneratemonthlybillstoincludedetailsofcustomercalls,Listedinorderoftimeofcall.Whichtableorganizationallowsforgeneratingthebillswithminimumdegreeofrowsorting?A)ahashclusterB)anindexclusterC)apartitionedtableD)asortedhashclusterE)aheaptablewitharowidcolumn答案:D解析:[單選題]38.ExaminethecommandsexecutedintherootcontainerofyourmultitenantcontainerDatabase(CDB)thathasmultiplepluggabledatabases(PDBs):SQL>CREATEUSERc##a_adminIDENTIFIEDBYorcl123;SQL>CREATEROLEc##role1CONTAINER=ALL;SQL>CREATEVIEWTOC##role1CONTAINER=ALL;SQL>GRANTc##role1TOc##a_adminCONTAINER=ALL;SQL>REVOKEc##role1FROMc##a_admin;Whatistheresultoftherevokecommand?A)Itexecutessuccessfullyandthec##role1roleisrevokedfromthec##a_adminuseronlyIntherootcontainer.B)Itfailsandreportsanerrorbecausethecontainer=allclauseisnotused.C)Itexecutessuccessfullyandthec##rocl1roleisrevokedfromthec##a_adminuserintheRootdatabaseandallthePDBs.D)Itfailsandreportsanerrorbecausethecomtainer=currentclauseisnotused.答案:A解析:[單選題]39.ExaminethefollowingsetofRMANcommands:CONFIGURECHANNELdc1DEVICETYPEDISKFORMAT'/u02/backup/%U';RMAN>RUN{ALLOCATECHANNELchlDEVICETYPEDISK;EXECUTESCRIPTarc_backup;}WhichstatementistrueabouttheRMANrunblockexecution?A)ThescriptisexecutedandbothDC1andchichannelsareusedforscriptexecution.B)Theexecutionofthescriptfailsbecausemultiplechannelscannotexistsimultaneously.C)Thepersistentconfigurationparameter,DC1,isoverriddenbecauseanewchannelisAllocatedintheRMANrunblock.D)Thenewchannel,chi,isignoredbecauseachannelhasbeenconfiguredalready.答案:C解析:[單選題]40.ExaminetheRMANcommand:RMAN>BACKUPVALIDATEDATABASE;Whichstatementistrueabouttheexecutionofthecommand?A)Blockchangetrackingmustbe