OracleOCP認(rèn)證考試練習(xí)真題OCP062

試卷科目：OracleOCP認(rèn)證考試練習(xí)OracleOCP認(rèn)證考試練習(xí)真題OCP062PAGE"pagenumber"pagenumber/SECTIONPAGES"numberofpages"numberofpagesOracleOCP認(rèn)證考試練習(xí)真題OCP062第1部分：單項(xiàng)選擇題，共64題，每題只有一個(gè)正確答案,多選或少選均不得分。[單選題]1.Whatisarequirementforcreatingaremotedatabaseschedulerjob?A)TheremotedatabasejobmustrunasauserthatisvalidontargetremotedatabaseB)AprivatedatabaselinkmustbecreatedfromtheoriginatingdatabasetothetargetremotedatabaseC)ThetargetremotedatabaseonwhichthejobisscheduledmustbeOracleDatabase11gRelease2orlaterD)Thetargetremotedatabasemustbeonadifferenthostfromtheoriginatingschedulerdatabasehost答案:A解析:[單選題]2.Yourproductiondatabaseusesfilesystemstorage.YouwanttomovestoragetoOracleAutomaticStorageManagement(ASM).Howwouldyouachievethis?A)byusingRMANB)byusingDataPumpC)byusingtheDatabaseUpgradeAssistant(DBUA)D)byusingatransportabledatabase答案:A解析:[單選題]3.ExaminetheparametersforadatabaseYourdatabasehasthreeundotablespacesandthedefaultundotablespaceisnotautoextensible.Resumablespaceallocationisnotenabledforanysessionsinthedatabaseinstance.Whatistheeffectonnewtransactionswhenallundospaceinthedefaultundotablespaceisinusebyactivetransaction?A)Transactionswritetheirundoinatemporarytablespace.B)Transactionsfail.C)TransactionswritetheirundointheSYSTEMundosegment.D)TransactionswaituntilspacebecomesavailableinUNDOTBS1.答案:B解析:[單選題]4.OneofyourdatabaseshasarchiveloggingenabledandRMANbackupsaretakenatregularintervals.ThedatafilefortheUSERStablespaceiscorrupt.Whichcommandmustyouexecutebeforestartingtherecoveryofthistablespace?A)SWITCHDATAFILEALL;B)STARTUPFORCEC)ALTERTABLESPACEusersOFFLINETEMPORARY;D)ALTERTABLESPACEusersOFELINENORMAL;E)ALTERTABLESPACEusersOFFLINEIMMEDIATE;答案:E解析:[單選題]5.YourdatabasehasarchiveloggingenabledandRMANbackupsaretakenatregularintervals.AdatafileintheUSERStablespaceisdamaged.Whichcommandmustyouexecutebeforestartingtherecoveryofthistablespace?A)SWITCHDATAFILEALLB)STARTUPFORCEC)STARTUPFORCENOMOUNTD)ALTERTABLESPACEusersOFFLINE答案:D解析:[單選題]6.Yourdatabaseinstanceisstartedbyusingaseverparameterfile(SPFILE)YouexecutethefollowingcommandtochangethevalueoftheLOG_BUFFERinitializationparameter.ALTERSYSTEMSETLOG_BUFFER=32M;Whatistheoutcomeofthiscommand?A)ItreturnsanerrorbecauseSCOPEshouldbesettoMEMORY.B)Itreturnsanerrorbecausethevalueofthisparametercannotbechangeddynamically.C)TheparametervalueischangedanditcomesintoeffectassoonasspacebecomesavailableintheSGA.D)Theparametervalueischangedanditcomesintoeffectatthenextinstancestartup.答案:B解析:[單選題]7.InyourOracle12cdatabase,youplantoexecutethecommand：SQL>CREATETABLESPACEtbs1DATAFILE?/u02/oracle/data/tbs01.dbf?SIZE50M;Theu02filesystemhas1GBoffreespaceavailable.Whatistheoutcome?A)Itcreatesalocallymanagedtablespacewithmanualsegmentspacemanagementenabled.B)Itcreatesadictionary-managedtablespacewithmanualsegmentspacemanagementenabled.C)Itraisesanerrorbecauseextentmanagementisnotspecified.D)Itcreatesalocallymanagedtablespacewithautomaticsegmentspacemanagementenabled.答案:D解析:[單選題]8.YouwanttocreateatestdatabaseasareplicaofyourproductiondatabasewithminimuminterventionfromaDBA.Whichmethodwouldyouuse?A)UseDBCAtocreateatemplatefromtheexistingdatabasetocontainthedatabasestructurewithdatafilesandthenusethesametemplatetocreatethedatabaseinthenewlocation.B)UseDBCAtocreateatemplatefromtheexistingdatabasetocontainthedatabasestructureandthenmanuallycopythedatabyusingOracleDataPump.C)UseDatabaseConfigurationAssistant(DBCA)tocreateatemplatefromtheexistingdatabasetocontainthedatabasestructure.D)CreatethedatabasebyusingtheCREATEDATABASE…commandandmanuallyimportdatabyusingDataPump.答案:A解析:[單選題]9.WhenistheUNDO_RETENTIONparametervalueignoredbyatransaction?A)whentheundotablespaceisofafixedsizeandretentionguaranteeisnotenabledB)whenthedatafileoftheundotablespaceisautoextensibleC)whentherearemultipleundotablespacesavailableinadatabaseD)whenFlashbackDatabaseisenabled答案:A解析:[單選題]10.TheHR.DEPARTMENTStableistheparentoftheHR.EMPLOYEEStable.TheEMPLOYEE.DEPARTMENT_IDcolumnhasaforeignkeyconstraintwiththeONDELETECASCADEoptionthatreferstotheDEPARTMENTS.DEPARTMENT_IDcolumn.AnindexexistsontheDEPARTMENTS.DEPARTMENT_IDcolumn.AtransactiondeleteaprimarykeyintheDEPARTMENTStable,whichhaschildrowsintheEMPLOYEEStable.Whichstatementistrue?A)OnlytherowsthataredeletedintheDEPARTMENTSandEMPLOYEEStablesarelockeduntilthetransactionontheDEPARTMENTStableiscomplete.B)ThetransactionacquiresatablelockontheEMPLOYEEStable.ThislockenablesothersessionstoquerybutnotupdatetheEMPLOYEEStableuntilthetransactionontheDEPARTMENTStableiscomplete.C)ThetransactionacquiresatablelockontheDEPARTMENTStable.ThislockenablesothersessionstoquerybutnotupdatetheDEPARTMENTStableuntilthetransactionontheDEPARTMENTStableiscomplete.D)ThetransactionacquiredatablelockonlyontheDEPARTMENTStableuntilthetransactioniscomplete.答案:A解析:[單選題]11.Unifiedauditingisenabledinyourdatabases.TheHR_ADMINandOE_ADMINrolesexistandaregrantedsystemprivileges.Youexecutethecommand：SQL>CREATEAUDTTPOLICYtable_audPRIVILEGESCREATEANYTABLE,DROPANYTAETEROLEShr_admin,oe_admin;whichstatementistrue?A)ItsucceedsandstartscapturingonlysuccessfulSQLstatementsforalluserswhohaveeitherthespecifiedprivilegesorrolesgrantedtothem.B)Itfailsbecausesystemprivilegescannotbegrantedwithrolesinthesameauditpolicy.C)ItsucceedsandneedstobeenabletocaptureallSQLstatementsthatrequireeitherthespecifiedprivilegesoranyprivilegegrantedtotheHR_ADMINorOE_ADMINrole.D)Itfailsbecausethecommanddoesnotspecifywhentheunifiedauditpolicyshouldbeenforced.答案:C解析:[單選題]12.YoucreatealocallymanagedtablespaceORDER_TBSwithautomaticsegmentmanagement.YouthencreatethetableDAILY_ORDS_LSTintheORDERS_TBStablespaceusingthecommand.CREATETABLEdaily_ords_lst(ordnoNUMBER,ord_dateDATE)PCTFREE20;HowdoesthePCTFREEstorageparameterinfluencedatastorageforthistable?A)Itallowsonly80%ofspacetobeoccupiedinalldatablocksofthistableB)ItminimizesrowmigrationduringexistingrowdataupdationC)Itautomaticallycoalescesfreespaceofadatablockwhenitreaches20%ofavailablespaceD)Itminimizesrowchainingduringrowinsertion答案:B解析:[單選題]13.Youdatabaseisopeninread/writemodeandmultipleusersareconnectedtothedatabaseinstance.Youexecutethefollowingcommand：SQL>ALTERSYSTEMENABLERESTRICTEDSESSION;Whatwouldbetheeffectoncurrentsessions?A)TheyarenotterminatedbutmayonlyissuequeriesB)TheyarenotaffectedC)TheyareterminatedaftercompletingthetransactionD)Theyareterminatedimmediately答案:B解析:[單選題]14.YourdatabaseisconfiguredinARCHIVELOGmode.ExaminetheRMANconfigurationparameters：CONFIGURERETENTIONPOLICYTOREDUNDANCY1;#defaultCONFIGUREBACKUPOPTIMIZATIONOFF;#defaultCONFIGURECONTROLFILEAUTOBACKUPOFF;#defaultCONFIGUREDEVICETYPEDISKPARALLELISM1BACKUPTYPETOBACKUPSET;CONFIGUREARCHIVELOGBACKUPCOPIESFORDEVICETYPEDISKTO1;#defaultExaminethecommand：RMAN>BACKUPDATABASEPLUSARCHIVELOGDELETEINPUT;Whatistheoutcome?A)ItfailsbecausetheDELETEINPUToptioncanbeusedonlywiththeBACKUPASBACKUPSETcommand.B)Itexecutessuccessfullyandcreatesabackupsetofthedatabasealongwitharchivedlogfilesandthendeletestheoriginalarchivedlogfiles.C)Itexecutessuccessfullyandcreatesanimagecopyofthedatabasealongwitharchivelogfilesandthendeletestheoriginalarchivedlogfiles.D)ItfailsbecausetheDELETEINPUToptioncanbeusedonlywiththeBACKUPASCOPYcommand.答案:B解析:[單選題]15.Examinethecommand：SQL>CREATETABLESPACEtest1DATAFILE?/u01/app/oracle/oradata/orcl/test01.dbf?size5MAUTOEXTENDONUNIFORM;Whichstatementistrue?A)Thedatafile,TEST01.DBF,canbeautoextendedtoamaximumsizeof5MB)Thetablespace,TEST1,cancontainamaximumofonedatafileC)AllocatedandfreeextentsaretrackedusingbitmapsD)Segmentfreespaceistrackedinthedatadictionary答案:C解析:[單選題]16.Whichtaskisperformedbyabackgroundprocessinadatabaseinstance?A)executingPL/SQLcodeB)creatededicatedserverconnectionsC)connectingbetweenaclientprocessandadispatcherD)copyingonlineredologfilestoofflinestorage答案:D解析:[單選題]17.YourdatabaseisinNOARCHIVELOGmode.Youwanttoenablearchivingfordatabase.Examinethesteps：ExecutetheALTERDATABASEARCHIVELOGcommand2.ExecuteSHUTDOWNIMMEDIATE3.ExecuteSTARTUPMOUNT4.SettheDA_RECOUVERY_FILE_DESTparameterto$ORACLE_HOME/dbs/5.ExecuteSTARTUPNOMOUNT6.OpenthedatabaseIdentifytherequirestepsinthecorrectsequence.A)4,2,5,1,6B)1,2,3,4,6C)2,3,1,6D)2,5,1,6答案:C解析:[單選題]18.Examinethedetailsoftheuncompressed,non-partitionedheaptableCITIES.Examinethecommand：SQL>ALTERTABLEcitiesSHRINKSPACECOMPACT;Whatmustyoudobeforeexecutingit?A)DisableallindexesonthetableB)EnablerowmovementisenabledC)ensuretherearenopendingtransactionsonthetableD)Ensurefreespacethatisapproximatelyequaltothespaceusedbythetableshouldbeavailable答案:B解析:[單選題]19.Youwantcreateatable,DAILY_ORDERS,foranOLTPapplication,wheredatashouldbecompressedduringbothdirect-pathINSERTandconventionalDML.Thetablewillalsobeusedforqueries.Whichcompressionoptionshouldbeused?A)ROWSTORECOMPRESSB)COLUMNSTORECOMPRESSFORQUERYC)COLUMNSTORECOMPRESSFORARCHIVELOWD)ROWSTORECOMPRESSADVANCED答案:D解析:[單選題]20.Whichstatementistrueaboutprofile?A)AusercanexistwithoutanyprofileB)AprofilecanbeassignedonlytooneuserC)PasswordmanagementusingprofilesisalwaysenabledD)Resourcelimitsspecifiedinaprofileassignedtoauserarealwaysenabled答案:C解析:[單選題]21.WhatistheoutcomeoftheSHUTDOWNABORTcommand?A)UncommittedtransactionsarerolledbackB)DirtybuffersinthebuffercacheandunwrittenredoarenotwrittentothedatafilesandredologfilesreceptivelyC)InstancerecoverymustberequestedbytheDBAatthenextstartupD)Pendingtransactionsarecommittedandthedatabaseisclosed答案:B解析:[單選題]22.TheschemaSALESexistsintwodatabases,ORCL1andORCL2,andhasthesamepassword,SALES123.UserSALEShasCREATEDATABASELINKandCREATESESSIONprivilegesonbothdatabases.Eaxminethesecommand：ConnSALES/SALES123CREATEDATABASELINKorcl2USING?orcl12?;WhatistheoutcomeofexecutingthesecommandsintheORCL1database?A)ORCL2iscreatedasashareddatabaselinktoconnectmultiplesessionstotheSALESschemaintheORCL2databaseB)ORCL2databaselinkcreationfailsC)ORCL2iscreatedasaprivatedatabaselinktoconnecttoonlytheSALESschemaintheORCL2databaseD)ORCL2iscreatedasapubliclinktoconnectasinglesessiontotheSALESschemaintheORCL2database答案:C解析:[單選題]23.WhichstatementistrueaboutadatabaseinARCHIVELOGmode?A)AllbackupstakenpriortoswitchingtoARCHIVELOGmodecanbeusedtoperformcompleterecoveryB)OnlineredologfileshavetobemultiplexedbeforeputtingthedatabaseinARCHIVELOGmodeC)AFastRecoveryArea(FRA)mustbeconfiguredforthedatabaseD)Fulldatabasebackupscanbeperformedwhenthedatabaseisopened答案:D解析:[單選題]24.IdentifytheaccessthatisinitiallyavailabletoconnecttoyourDatabaseasaService(DBaaS)environmentA)SSL/TLSonport443B)SSHonport22C)CloudControlonport7799D)telnetonport23E)EnterpriseManageronport1158答案:B解析:[單選題]25.WhichstatementistrueabouttheDatabaseasaService(DBaaS)instancesandDatabaseinstancesinOraclePublicCloud?A)ADBaaSinstancecansupportonlyoneOracledatabaseinstanceB)ADBaaSinstancecansupportmultipleOracledatabaseinstancesC)ADBaaSinstancerunsinapluggabledatabase(PDB),whichiscontainedinamulti-tenantcontainerdatabase(CDB)D.AnOracledatabaseinstancecansupportmultipleDBaaSinstancesD)AnOracledatabaseinstancecansupportoneDBaaSinstances答案:B解析:[單選題]26.YourdatabaseinstanceisstartedwithaPFILE.Examinetheparameters：Youwanttoincreasethesizeofthebuffercache.Freememoryisavailabletoincreasethesizeofthebuffercache.Youexecutethecommand：SQL>ALTERSYSTEMSETDB_CACHE_SIZE=1024M;Whichistheoutcome?A)ThevalueischangedforthecurrentinstanceandinthePFILEB)ItfailsbecausetheSCOPEclauseismissingC)ThevalueischangedonlyinthePFILEandtakeseffectatthenextinstancestartupD)Changeisappliedtothecurrentinstance,butdoesnotpersistafterinstancerestart答案:D解析:[單選題]27.Whatmustyouusetoreaddatafromatableinyourdatabaseandwriteittoanexternaltable?A)UseCREATETABLE...ORGANIZATIONEXTERNALcommandwithORACLE_DATAPUMPaccessdriverB)UseSQL*LOADERdirectpathloadC)UseSQL*LOADERconventionalpathloadD)UseCREATETABLE...ORGANIZATIONEXTERNALcommandwithORACLE_LOADERaccessdriver答案:A解析:[單選題]28.Inyourdatabase,archiveloggingandcontrolfileautobackupareenabled.Thedatafilesandredologfilesareintactbutcontrolfilesareimpactedduetomediafailure.InwhichrecoveryscenariomustyouusetheRESETLOGSoption?A)AllcopiesofthecontrolfilesaredamagedandtheautobackedupcontrolfileisusedforrecoveryB)AllcopiesofthecontrolfilesaredamagedandtheCREATECONTROLFILEstatementisexecutedmanuallyC)OnecontrolfilecopyisintactanddamagedcontrolfilecopieshavetoberestoredtothedefaultlocationD)Onecontrolfilecopyisintactanddamagedcontrolfilecopieshavetoberestoredtoanon-defaultlocationE)Onecontrolfilecopyisintactsothespfileischangedtorefertoonlyonecopy答案:A解析:[單選題]29.YouwanttocreatealocallymanagedtablespacecalledNEWTBStostoresegmentswithdifferentextentsizes.Whichsetoftablespaceattributescanbespecifiedforatablespacethesatisfiestherequirements?A)EXTENTMANAGEMENTLOCALSTORAGE(INITIAL5MMAXSIZE10M)B)REUSEAUTOEXTENDONMAXSIZEUNLIMITEDC)EXTENTMANAGEMENTLOCALAUTOALLOCATED)EXTENTMANAGEMENTLOCALSEGMENTSPACEMANAGEMENTUNIFOR答案:C解析:[單選題]30.WhichuserarecreatedandcanbeusedfordatabaseandhostmanagementofyourDBaaSdatabaseservers?A)root,opcandoracleusersB)rootandoracleusersC)root,oracleandcloudusersD)opcandoracleusersE)cloudandoracleusers答案:D解析:[單選題]31.Anapplicationrepeatedlyaccessessmalllookuptables,causingalotofphysicalI/Ooperations.Whatdoyourecommendtominimizethis?A)ConfigurethenonstandardbuffercachewithabuffersizegreaterthanthesizeofthedefaultbuffercacheB)IncreasethesizeofthesharedpoolC)ConfiguretheRECYCLEbuffercacheandalterthetablestousetheRECYCLEcacheD)ConfiguretheKEEPbuffercacheandalterthetablestousetheKEEPcache答案:D解析:[單選題]32.WhichstatementistrueabouttheDEFAULTprofile?A)ThevaluesassignedtotheresourcelimitsandpasswordparametersinthedefaultprofilecanbealteredB)AdifferentDEFAULTprofilecanbecreatedforeachuserinadatabaseC)ItcanbedroppedandrecreatedD)Itmustbeexplicitlyassignedtoauser答案:A解析:[單選題]33.WhichcomponentresideintheSystemGlobalArea(SGA)ofadatabaseinstanceonlyinsharedserverconnections?A)ProgramGlobalAreaB)UserGlobalAreaC)SQLQueryResultCacheD)PL/SQLFunctionResultCache答案:B解析:[單選題]34.Whendoesadatabasecheckpointoccur?A)WhenausersessionterminatesabnormallyB)WhenaserverprocessterminatesabnormallyC)WhenthereisanonlineredologswitchD)WhentheSHUTDOWNABORTcommandisissued答案:C解析:[單選題]35.Whatactionmustyoutaketoensurecompletedatabaserecoverytillthepointoffailure?A)MultiplexthecontrolfilesB)DuplextheRMANbackupsetsC)MultiplextheonlineredologfilesD)ConfigurethedatabasetoruninARCHIVELOGmode答案:D解析:[單選題]36.Youwanttodistributeasetofstructureddatatoyourcustomerswhocanintegratethisdataintotheirexistingdatabasesirrespectiveoftheplatform.Whichmethodprovidesthefastestwayofachievingthis?A)usingtheDBVERIFYutilityB)usingRMANtransporttabletablespaceoperationC)usingSQL*LoaderD)usingdirect-pathINSERTSQLstatements答案:B解析:[單選題]37.TheHRschemaexistsintwodatabases,BOSTONandDENVER,andhasthesamepassword,HR.YouhavetheCREATEDATABASELINKandCREATESESSIONprivilegesonboththedatabase.BOSTONisdefinedasaservicenameinthetnsnames.oraofboththedatabases.Youplantousethecommand：CREATEDATABASELINKhr_linkCONNECTTOhrIDENTIFIEDBYhrUSING?denver?;WhatmustbedonetoensureonlytheHRuserintheBOSTONdatabasecanaccesstheHRschemaintheDENVERdatabase?A)ExecutethiscommandasHRuserintheBOSTONdatabaseandSYSuserintheDENVERdatabase.B)ExecutethiscommandasHRuserintheDENVERdatabaseC)ExecutethiscommandasHRuserintheBOSTONdatabaseD)ExecutethiscommandasSYSuserinboththedatabase答案:C解析:[單選題]38.TheHRschemaexistsindatabases,BOSTONandDENVER,andhasthesamepassword,HR.YouhavetheCREATEDATABASELINKandCREATESESSIONprivilegesonboththedatabase.DENVERisdefinedasaservicenameinthetnsnames.oraofboththedatabases.Youplantousethecommand：CREATEDATABASELINKhr_linkCONNECTTOhrIDENTIFIEDBYhrUSING?denver?;WhatmustbedonetoensurethatallusersintheBOSTONdatabasecanaccesstheHRschemaintheDENVER?A)ChangethecommandtocreateapublicdatabaselinkinDENVERB)ExecutethecommandasSYSinbothdatabasesC)ExecutethecommandasHRinBOSTONandSYSinDENVERD)ChangethecommandtocreateapublicdatabaselinkinBOSTONE)ExecutethecommandasSYSinDENVERF.ExecutethecommandasSYSinBOSTON答案:D解析:[單選題]39.Examinetheparametersforyourdatabaseinstance：Youexecutethefollowingcommand：SQL>ALTERTABLESPACEundotbs1RETENTIONNOGUARANTEE;Whichstatementistrueinthisscenario?A)Anattemptismadetokeepinactiveundofor1200secondsbuttransactionsmayoverwritetheundobeforethattimehaselapsedB)Inactiveundodataisretainedfor1200secondsevenifsubsequenttransactionsfailduetolackofspaceintheundotablespaceC)YoucanperformaFlashbackDatabaseoperationonlywithinthedurationof1200secondsD)Undodataiswrittentoflashbacklogsafter1200seconds答案:A解析:[單選題]40.Whatisapre-requisitetoalterarole?A)YoushouldbegrantedtheDBArole.B)YoushouldsettheOS_ROLESparametertotrue.C)YoushouldhavetheALTERANYROLEsystemprivilege.D)YoushouldbegrantedtherolewiththeGRANTOPTION.答案:C解析:[單選題]41.TheORCLdatabaseisconfiguredtosupportsharedservermode.Youwanttoensurethatauserconnectingremotelytothedatabaseinstanceaone-to-oneratiobetweenclientandserverprocesses.Whichconnectionmethodguaranteesthatthisrequirementismet?A)connectingbyusingadirectorynamingmethodB)creatingaserviceinthedatabasebytheDBMS_SERVICE.CREATE_SERVICEprocedureandusingthisserviceforcreatingalocalnamingserviceC)connectingbyusingtheeasyconnectmethodD)connectingbyusingthelocalnamingmethodwiththeserver=dedicatedparametersetinthetnsnames.orafileforthenetserviceE)connectingbyusinganexternalnamingmethod答案:D解析:[單選題]42.Inyourdatabase,theSALEStableexistsintheSHschemaandunifiedauditingisenabled.AstheDBA,yousuccessfullyexecutethecommands：SQL>CREATEAUDITPOLICYsales_polACTIONSselectonsh.sales;SQL>AUDITPOLICYsales_pol;WhichstatementistrueabouttheSALES_POLauditpolicy?A)ItisenabledforalluserswhohavetheSELECTprivilegeontheSH.SALEStable.B)OnlysuccessfulexecutionsoftheSELECTstatementsarewrittentotheaudittrail.C)Theauditrecordsarealwaysstoredinanauditfileattheoperatingsystemlevel.D)ItgetsenabledonlyfortheSHuser.答案:B解析:[單選題]43.AuserestablishesaconnectiontoadatabaseinstancebyusinganOracleNetconnection.Youwanttoensurethefollowing：Theuseraccountmustbelockedafterfiveunsuccessfulloginattempts.2.Datareadpersessionmustbelimitedfortheuser.3.Theusercannothavemorethanthreesimultaneoussessions.4.Theusermusthaveamaximumof10minutessessionidletimebeforebeingloggedoffautomatically.Howwouldyouaccomplishthis?A)bygrantingasecureapplicationroletotheuserB)byimplementingDatabaseResourceManagerC)byusingOracleLabelSecurityoptionsD)byassigningaprofiletotheuser答案:D解析:[單選題]44.YourdatabaseisrunninginNOARCHIVELOGmode.Examinethefollowingparameters：NAMETYPEVALUElog_archive_deststringlog_archive_dest_1stringlogrecovery_file_deststring/u01/app/oracle/fast_recovery_areaYouexecutethefollowingcommandafterperformingaSTARTUPMOUNT：SQL>ALTERDATABASEARCHIVELOG;Whichstatementistrueabouttheexecutionofthecommand?A)ItfailsandreturnsanerroraboutLOG_ARCHIVE_DESTnotbeingset.B)ItexecutessuccessfulandissuesawarmingtosetLOG_ARCHIVE_DESTwhileopeningthedatabase.C)ItexecutessuccessfullyandsetstheFastRecoveryAreaasthelocalarchivedestination.D)ItexecutessuccessfullyandsetsSORACLE_HOME/dbsasthedefaultarchivedestination.答案:C解析:[單選題]45.TheHRuserownstheBONUSERStalbe.HRgrantsprivilegestotheuserTOMbyusingthecommand：SQL>GRANTSELECTONbonusestotomWITHGRANTOPTION;TOMthenexecutesthiscommandtograntprivilegestotheuserJIM：SQL>GRANTSELECTONhr.bonusesTOjim;Whichstatementistrue?A)JIMcangranttheSELECTONHR.BONUSESprivilegetootherusers,butcannotrevoketheprivilegefromthem.B)HRcanrevoketheSELECTONHR.BONUSESprivilegefromJIM.C)HRcanrevoketheSELECTONHR.BONUSEBprivilegefromTOM,whichwillautomaticallyrevoketheSELECTONHR.BONUSESprivilegefromJIM.D)TOMcannotrevoketheSELECTONHR.BONUSESprivilegefromJIM.答案:C解析:[單選題]46.YourdatabaseisopenandthelistenerLTSTENERisup.Youissuethecommand：LSNRCTL>RELOADWhatistheeffectofRELOADonsessionsthatwereoriginallyestablishedbyLISTENER?A)Onlysessionsbasedonstaticlistenerregistrationsaredisconnected.B)Existingconnectionsarenotdisconnected;however,theycannotperformanyoperationsuntilthelistenercompletesthere-registrationofthedatabaseinstanceandservicehandlers.C)Thesessionsarenotaffectedandcontinuetofunctionnormally.D)Allthesessionsareterminatedandactivetransactionsarerolledback.答案:C解析:[單選題]47.Whatshouldyoudotoensurethatajobstoresminimaljobmetadataandruntimedataondisk,andusesonlyexistingPL/SQLprograms?A)specifythejobasamemberofajobclassB)createalightweightjobC)createanevent-basedjobD)useajobarray答案:B解析:[單選題]48.WhatshouldyoudoforaSchedulertostartajobwhenafilearrivesonaremotesystem?A)Shutdownthefilewatcheronthelocalsystem.B)Ensurededicatedserverisenabledonboththelocalandremotedatabases.C)InstalltheScheduleragentontheremotesystemandregistertheagentwiththedatabaseonthelocalsystem.D)StartanOracledatabaseinstanceontheremotesystemandregistertheScheduleragentwiththisdatabase.答案:C解析:[單選題]49.Youwanttodistributeasetofstructureddatatoyourcustomerswhocanintegratethisdataintotheirexistingdatabasesirrespectiveoftheplatform.Whichmethodprovidesthefastestwayofachievingthis?A)usingSQL*LoaderB)usingRMANtransportabletablespaceoperationC)usingtheDBVERIFYutilityD)usingdirect-pathINSERTSQLstatements答案:B解析:[單選題]50.Whichstatementistrueaboutredologfilesduringinstancerecovery?A)Allredologentriesinthecurrentlogareappliedtodatafilesuntilthecheckpointpositionisreached.B)Allcurrent,online,andarchivedredologsarerequiredtocompleteinstancerecovery.C)AllredologentriesinthecurrentandactivelogsareappliedtodatafilestoreconstructchangesImadeafterthemostrecentcheckpoint.D)Allcurrent,active,andinactiveredologsarerequiredtocompleteinstancerecovery.答案:C解析:[單選題]51.Examinethisparametersetting：Nowexaminethiscommand：ALTERTABLEhr.empINMEMORY;Tablealtered.Whichistrueabouteffectsofthiscommandandanysubsequentprocessingonhr.emp?A)ItsdatagetsloadedintotheIMColumnStoreincolumnarformat.B)ItsdatagetsloadedintotheIMColumnStoreinrowformat.C)ThedatabaseinstanceusestheIMColumnStoretoprocessDMLs.D)Itsdatacannotbeloadedintothedefaultdatabasebuffercache.答案:A解析:[單選題]52.Examinetheseparametersettings：Youexecutethis：CREATEUNDOTABLESPACEUNDOTBS2SEGMENTSPACEMANAGEMENTAUTO;Whichistrue?A)ItfailsbecausethereisalreadyanactiveUNDOTABLESPACEforthedatabaseinstance.B)ItfailsbecauseAutomaticSegmentSpaceManagement(ASSM.isnotsupportedforanUNDOTABLESPACE.C)Itfailsbecausesizeanddatafileclausearemissing.D)ItexecutessuccessfullyandspaceintheUNDOTBS2tablespacewillbefreelistmanaged.E)ItexecutessuccessfullyandspaceintheUNDOTBS2tablespacewillbebitmapmanaged.答案:E解析:[單選題]53.Whichnamingmethodenablesclientstoconnecttoadatabaseinstancewithoutanyclientsideconfigurationinsqlnet.oraortnsnames.ora?A)thedirectorynamingmethodB)theexternalnamingmethodC)theeasyconnectmethodD)thelocalnamingmethod答案:C解析:[單選題]54.Examinethesecommands：Nowexaminethesesteps：1)STARTUPNOMOUNT2)STARTUPMOUNT3)STARTUPFORCE4)ALTERDATABASEARCHIVELOG;5)SHUTDOWNTRANSACTIONAL6)ALTERDATABASEOPEN;7)SHUTDOWNABORT8)ALTERDATABASEMOUNTIdentifytherequiredstepsinthecorrectordertochangethedatabasetoruninARCHIVELOGmode.A)5,1,4,8,6B)7,1,4,8,6C)5,1,4,6D)5,2,6,4E)5,3,4,6F)5,2,4,6答案:F解析:[單選題]55.Inoneofyourdatabases,unifiedauditingisenabledandanSH.SALEStableexists.Yousuccessfullyexecutethesecommands：SQL>CREATEAUDITPOLICYsales_polACTIONSselectonsh.sales;SQL>AUDITPOLICYsales_pol;WhichstatementistrueaboutSALES_POL?A)Auditrecordsarealwaysstoredinanexternalauditfile.B)ItisonlyenabledforuserSH.C)OnlysuccessfulqueriesofSH.SALESarewrittentotheaudittrail.D)ItisenabledforallusershavingSELECTprivilegeonSH.SALES答案:C解析:[單選題]56.Examinethesecommands：CONNECT/ASSYSDBACREATEDIRECTORYdumpdirAS'/u01/app/';Directorycreated.GRANTREAD,WRITEONDIRECTORYdumpdirTOPUBLIC;Grantsucceeded.CREATEUSERTESTIDENTIFIEDBYtest;Usercreated.GRANTCREATESESSION,RESOURCE,UNLIMITEDTABLESPACETOtest;Grantsucceeded.CONNtest/testConne