OCP认证考试052最新考试题库解析ppt课件 (2).pptx

2018年OCP052最新考试题库解析-20180525,题库新特点：更加灵活，题库的顺序与考试时的顺序每场都在变化更加考验知识点的掌握，题库答案为二，考试时要求选择最佳一个答案整理：CUUG,1,2018年OCP052最新考试题库解析-20180525,1、WhichtwoeventsalwaysrequesttheLGWRtowrite?A)whenLGWRisnotifiedbyaserverprocessthatperformsaCommitorROLLBACKB)WhenPMONrestartsaserverprocessC)whenDBWnwritesdirtybuffersD)whenalogswitchoccursE)whenacheckpointoccursAnswer:CD,2,2018年OCP052最新考试题库解析-20180525,2、Examinethesecommandsandtheiroutput:SQLSELECT*FROMemp;ENOENAME-100Adam101AlanSQLINSERTINTOempVALUES(102,Ben);1rowcreated.SQLCOMMIT;Commitcompleted.SQLUPDATEempSETename=BryanWHEREeno=102;1rowupdated.Apowerfailureoccurs.TheInstanceIsrestartedandthisqueryIsexecuted.SQLSELECTenameFROMemp;WhatIstheoutcome?A)OnlyAdamandAlanaredisplayed.B)OnlyAdam,Alan,andBryanaredisplayed.C)Adam,Alan,Ben,andBryanaredisplayed.D)Norowsarereturned.E)OnlyAdam,Alan,andBenaredisplayed.Answer:E,3,2018年OCP052最新考试题库解析-20180525,3、WhereIsbackupmetadatastoredforusebyRecoveryManager(RMAN)?A)InthecontrolfileB)IntheSYSAUXtablespaceC)intheSPFILED)intheSYSTEMtablespaceE)InthediagnosticdestinationfliesAnswer:A,4,2018年OCP052最新考试题库解析-20180525,4、WhichtwocanbebackedupbyusingRMANwhenadatabaseIsopeninARCHIVELOGmode,sothatmediarecoverycanbeperformedIfrequired?A)controlfilesB)passwordfileC)pfileD)onlineredologsE)flashbacklogsF)datafilesAnswer:AF,5,2018年OCP052最新考试题库解析-20180525,5、YourdatabaseisusingAutomaticMemoryManagement.WhichtwoSGAcomponentsmustbemanagedmanually?A)defaultbuffercacheB)redologbufferC)largepoolD)sharedpoolE)keepbufferpoolAnswer:BE,6,2018年OCP052最新考试题库解析-20180525,6、Whichtwoaretrueaboutroles?A)Arolecanbegrantedacombinationofsystemandobjectprivilegesandotherroles.B)TheCONNECTroleIsgrantedautomaticallytoauserwhenItIscreated.C)RolesareownedbySYSTEM.D)TheRESOURCEroleIsgrantedtheCREATESESSIONprivilege.E)AsecureapplicationrolecanbesetonlybyItsassociatedPL/SQLpackage.Answer:AE,7,2018年OCP052最新考试题库解析-20180525,7、USER1grantsSELECT,INSERT,andUPDATEprivilegesonUSER1.EMPtoUSER2.SYSexecutesthiscommand:SQLREVOKEUPDATEONuser1.empFROMuser1;Whatwillbetheoutcome?A)ItwillsucceedandonlyUSER2willbeunabletoperformSELECT,INSERT,OrUPDATEonUSER1.EMU.B)ItwillsucceedandonlyUSER1willbeunabletoperformSELECT,INSERT,OrUPDATEonUSER1.EMP.C)ItwillsucceedbutneitherUSER1norUSER2willbeabletoperformSELECT,INSERT,orUPDATEonUSER1.EMP.0D)ItwillfallbecauseUSER1IstheownerofUSER1.EMP.E)ItwillsucceedandneitherUSER1norUSER2willbeabletoperformINSERTorUPDATEonUSER1.EMP,butbothwillbeabletoqueryUSER1.EMP).Answer:D,8,2018年OCP052最新考试题库解析-20180525,8、WhichthreearetrueabouttheAutomaticDatabaseDiagnosticMonitor(ADDM)?A)ItsfindingsareaccessibleonlybyusingOracleEnterpriseManager.B)ItimprovesdatabaseperformancebyautomaticallyimplementingOraclesbestpractices.C)ItcanassisttheDBAindiagnosingdatabaseinstancestartupfailures.D)ItcanbeusedbyexecutingthePL/SQLproceduresintheDBMS_ADDMpackage.E)ItrunsautomaticallyaftereachAutomaticWorkloadRepositorysnapshotiscreated.F)Itprovidesrecommendationstoimprovedatabaseperformance.Answer:DEF,9,2018年OCP052最新考试题库解析-20180525,9、Examinethesecomponents:1.Executionplanforanon-embeddedSQLstatement2.Local,global,andpackagevariablesforasession3.ExecutionplanforaSQLstatementcontainedInaPL/SQLprogramunit4.ResultsofexecutedqueriesandqueryfragmentsS.PL/SQLfunctionresultsetsWhichofthesearestoredinthesharedSQLarea?A)1and4B)1,2and3C)1and3D)1,3,4,and5Answer:C,10,2018年OCP052最新考试题库解析-20180525,10、ExaminethisLISTENER.ORAfile:LISTENER=(DESCRIPTION_LIST=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=1522)SIDLISTLISTENER=(SIDLIST=(SID_DESC=(GLOBAL_DBNAME=)(ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)(SID_NAME=orcl)HowshouldyouconfigureanadditionallistenerLISTENER2thatlistensforthesameSID?A)AddrelevantdetailsInDESCRTPTIONundertheexistingLTRTENERwithadifferentportnumberinLISTENER.ORA.B)CreateanotherconfigurationfilecalledLISTENER2.ORAwithonlyLISTENER2detailsinit.C)AddrelevantdetailsinSID_LIST_LISTENERundertheexistingLISTENERinLISTENER.ORAD)AddLISTENER2anditsSID_LISTdetailsseparatelyunderthenameLISTENER2inLISTENER.ORAAnswer:D,11,2018年OCP052最新考试题库解析-20180525,11、YourdatabaseIsopeninARCHIVELOGmode.LOG_ARCHIVE_DESTIssettoFastRecoveryArea(FRA)anditIs100%fullwhenalogswitchtakesplace.Noalternativeoroptionalarchivedestinationsaredefined.WhatIstheoutcome?A)Allactivesessionsaredisconnectedandtheirtransactionsrolledback.B)ThearchivelogentriesaremadeinthediagnosticdestinationandwhenspaceIsavailable,newarchivelogsaregenerated.C)Noarchivelogsaregenerated.D)Obsoletebackupsareautomaticallydeletedandnewarchivelogsaregenerated.E)Allactivesessionshanguntilthedatabaseadministrator(DBA)makesspaceavailableIntheFRA.Answer:E,12,2018年OCP052最新考试题库解析-20180525,12、Whichtwoaretrueaboutdatadictionaryviews?A)ALLorUSERprefixedviewsdisplayoutputthataresubsetsoftheoutputfromtheDBAprefixeddataviews.B)DBAprefixedviewsareaccessiblewhenadatabaseisInmountstate.C)AusermaynotnecessarilybetheownerofallobjectsthatcanbeviewedbyusingtheALLprefixedviews.D)AusercanquerytheDBAprefixedviewsonlyiftheyhavetheSYSDBAprivilegeE)AlldatadictionaryviewsareprefixedwithDBA.OrALLorUSERAnswer:AD,13,2018年OCP052最新考试题库解析-20180525,13、USER1.EMPhasareferentialIntegrityconstraintdefinedonEMP.DNOthatreferencesUSER1.DEPT.DNO.user1executesthesecommands:SQLUPDATEdeptSET1oc=UKwheredno=1;1rowupdatedSQLUPDATEempSETsal=1000whoreeno=100;1rowupdatedSQLALTERTABLEdeptDROP(dno);Whatwillbetheoutcomeandwhy?A)ItwillfailbecauseareferentialIntegrityconstraintIsdefinedonUSER1.EMP.B)ItwillfallbecausethereIsanuncommittedtransactiononUSER1.EMP.C)ItwillfailbecausethereisanuncommittedtransactiononUSER1.DEPT.D)ItwillexecutesuccessfullyanddropDEPT.DNO.E)ItwillexecutesuccessfullyanddroptheDEPT.DNOandEMP.DNOcolumns.Answer:A,14,2018年OCP052最新考试题库解析-20180525,14、Whichtwoaretrueaboutundotablespaces?A)Theyalwaysretainu