【OCP-052】最新考试题库(考试原题)-3-20180525-

052题库解析最新15道题052-题库解析-3-20180525题库新特点：更加灵活，题库的顺序与考试时的顺序每场都在变化更加考验知识点的掌握，题库答案为二，考试时要求选择最佳一个答案不断有新的考题出现，目前最新已经更新到130道题每周五晚8点-直播地址：ke.qq.com/course/326223ocp考试讨论群：836361015验证：ocpCUUG整理，官网：•1、WhichtwoeventsalwaysrequesttheLGWRtowrite?•❑A)whenLGWRisnotifiedbyaserverprocessthatperformsaCommitorROLLBACK•❑B)WhenPMONrestartsaserverprocess•❑C)whenDBWnwritesdirtybuffers•❑D)whenalogswitchoccurs•❑E)whenacheckpointoccurs•Answer:CD•2、Examinethesecommandsandtheiroutput:•SQLSELECT*FROMemp;•ENONAME•---------•100Adam•101Alan•SQLINSERTINTOempVALUES(102,'Ben);•1rowcreated.•SQLCOMMIT;•Commitcompleted.•SQLUPDATEempSETename='Bryan'WHEREeno=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、WhereIsbackupmetadatastoredforusebyRecoveryManager(RMAN)?•❑A)Inthecontrolfile•❑B)IntheSYSAUXtablespace•❑C)intheSPFILE•❑D)intheSYSTEMtablespace•❑E)Inthediagnosticdestinationflies•Answer:A•4、WhichtwocanbebackedupbyusingRMANwhenadatabaseIsopeninARCHIVELOGmode,sothatmediarecoverycanbeperformedIfrequired?•❑A)controlfiles•❑B)passwordfile•❑C)pfile•❑D)onlineredologs•❑E)flashbacklogs•❑F)datafiles•Answer:AF5、YourdatabaseisusingAutomaticMemoryManagement.WhichtwoSGAcomponentsmustbemanagedmanually?•❑A)defaultbuffercache•❑B)redologbuffer•❑C)largepool•❑D)sharedpool•❑E)keepbufferpool•Answer:BE6、Whichtwoaretrueaboutroles?•❑A)Arolecanbegrantedacombinationofsystemandobjectprivilegesandotherroles.•❑B)TheCONNECTroleIsgrantedautomaticallytoauserwhenItIscreated.•❑C)RolesareownedbySYSTEM.•❑D)TheRESOURCEroleIsgrantedtheCREATESESSIONprivilege.•❑E)AsecureapplicationrolecanbesetonlybyItsassociatedPL/SQLpackage.•Answer:AE7、USER1grantsSELECT,INSERT,andUPDATEprivilegesonUSER1.EMPtoUSER2.SYSexecutesthiscommand:SQLREVOKEUPDATEONuser1.empFROMuser1;Whatwillbetheoutcome?•❑A)ItwillsucceedandonlyUSER2willbeunabletoperformSELECT,INSERT,OrUPDATEonUSER1.EMU.•❑B)ItwillsucceedandonlyUSER1willbeunabletoperformSELECT,INSERT,OrUPDATEonUSER1.EMP.•❑C)ItwillsucceedbutneitherUSER1norUSER2willbeabletoperformSELECT,INSERT,orUPDATEonUSER1.EMP.0•❑D)ItwillfallbecauseUSER1IstheownerofUSER1.EMP.•❑E)ItwillsucceedandneitherUSER1norUSER2willbeabletoperformINSERTorUPDATEonUSER1.EMP,butbothwillbeabletoqueryUSER1.EMP).•Answer:D8、WhichthreearetrueabouttheAutomaticDatabaseDiagnosticMonitor(ADDM)?•❑A)ItsfindingsareaccessibleonlybyusingOracleEnterpriseManager.•❑B)ItimprovesdatabaseperformancebyautomaticallyimplementingOracle'sbestpractices.•❑C)ItcanassisttheDBAindiagnosingdatabaseinstancestartupfailures.•❑D)ItcanbeusedbyexecutingthePL/SQLproceduresintheDBMS_ADDMpackage.•❑E)ItrunsautomaticallyaftereachAutomaticWorkloadRepositorysnapshotiscreated.•❑F)Itprovidesrecommendationstoimprovedatabaseperformance.•Answer:DEF9、Examinethesecomponents:•1.Executionplanforanon-embeddedSQLstatement•2.Local,global,andpackagevariablesforasession•3.ExecutionplanforaSQLstatementcontainedInaPL/SQLprogramunit•4.ResultsofexecutedqueriesandqueryfragmentsS.PL/SQLfunctionresultsets•WhichofthesearestoredinthesharedSQLarea?•❑A)1and4•❑B)1,2and3•❑C)1and3•❑D)1,3,4,and5•Answer:C•10、ExaminethisLISTENER.ORAfile:•LISTENER=•(DESCRIPTION_LIST=•(DESCRIPTION=•(ADDRESS_LIST=•(ADDRESS=(PROTOCOL=TCP)(HOST=srvl.example.com)(PORT=1522))•)))•SIDLISTLISTENER=•(SIDLIST=•(SID_DESC=•(GLOBAL_DBNAME=orcl.example.com)•(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.ORA•❑D)AddLISTENER2anditsSID_LISTdetailsseparatelyunderthenameLISTENER2inLISTENER.ORA•Answer:D11、YourdatabaseIsopeninARCHIVELOGmode.•LOG_ARCHIVE_DESTIssettoFastRecoveryArea(FRA)anditIs100%fullwhenalogswitchtakesplace.•Noalternativeoroptionalarchivedestinationsaredefined.•WhatIstheoutcome?•❑A)Allactivesessionsaredisconnectedandtheirtransactionsrolledback.•❑B)ThearchivelogentriesaremadeinthediagnosticdestinationandwhenspaceIsavailable,newarchivelogsaregenerated.•❑C)Noarchivelogsaregenerated.•❑D)Obsoletebackupsareautomaticallydeletedandnewarchivelogsaregenerated.•❑E)Allactivesessionshanguntilthedatabaseadministrator(DBA)makesspaceavailableIntheFRA.•Answer:E12、Whichtwoaretrueaboutdatadictionaryviews?•❑A)ALLorUSERprefixedviewsdisplayoutputthataresubsetsoftheoutputfromtheDBAprefixeddataviews.•❑B)DBAprefixedviewsareaccessiblewhenadatabaseisInmountstate.•❑C)AusermaynotnecessarilybetheownerofallobjectsthatcanbeviewedbyusingtheALLprefixedviews.•❑D)AusercanquerytheDBAprefixedviewsonlyiftheyhavetheSYSDBAprivilege•❑E)AlldatadictionaryviewsareprefixedwithDBA.OrALLorUSER•Answer:AD13、USER1.EMPhasaref