OCP考试052最新考试题库原题-3-20180525-

《OCP考试052最新考试题库原题-3-20180525-》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、052题库解析最新15道题052-题库解析-3-20180525题库新特点：l更加灵活，题库的顺序与考试时的顺序每场都在变化l更加考验知识点的掌握，题库答案为二，考试时要求选择最佳一个答案l不断有新的考题出现，目前最新已经更新到130道题每周五晚8点-直播地址：ke.qq.com/course/326223ocp考试讨论群：836361015验证：ocpCUUG整理，官网：www.cuug.com•1、WhichtwoeventsalwaysrequesttheLGWRtowrite?•❑A)whenLGWRisnotifiedbyaserverprocessthatperfor

2、msaCommitorROLLBACK•❑B)WhenPMONrestartsaserverprocess •❑C)whenDBWnwritesdirtybuffers •❑D)whenalogswitchoccurs •❑E)whenacheckpointoccurs •Answer:CD•2、Examinethesecommandsandtheiroutput: •SQL>SELECT*FROMemp;•ENONAME•---------•100Adam•101Alan•SQL>INSERTINTOempVALUES(102,'Ben"); •1rowcreated.•SQL

3、>COMMIT;•Commitcompleted.•SQL>UPDATEempSETename='Bryan'WHEREeno=102; •1rowupdated.•Apowerfailureoccurs.TheInstanceIsrestartedandthisqueryIsexecuted. •SQL>SELECTenameFROMemp;•WhatIstheoutcome?•❑A)OnlyAdamandAlanaredisplayed. •❑B)OnlyAdam,Alan,andBryanaredisplayed. •❑C)Adam,Alan,Ben,andBryanare

4、displayed. •❑D)Norowsarereturned.•❑E)OnlyAdam,Alan,andBenaredisplayed. •Answer:E•3、WhereIsbackupmetadatastoredforusebyRecoveryManager(RMAN)?•❑A)Inthecontrolfile •❑B)IntheSYSAUXtablespace •❑C)intheSPFILE•❑D)intheSYSTEMtablespace •❑E)Inthediagnosticdestinationflies •Answer:A•4、Whichtwocanbeback

5、edupbyusingRMANwhena databaseIsopeninARCHIVELOGmode,sothatmedia recoverycanbeperformedIfrequired?•❑A)controlfiles •❑B)passwordfile •❑C)pfile•❑D)onlineredologs •❑E)flashbacklogs •❑F)datafiles•Answer:AF5、YourdatabaseisusingAutomaticMemoryManagement. WhichtwoSGAcomponentsmustbemanagedmanually? •

6、❑A)defaultbuffercache•❑B)redologbuffer•❑C)largepool•❑D)sharedpool•❑E)keepbufferpool•Answer:BE6、Whichtwoaretrueaboutroles?•❑A)Arolecanbegrantedacombinationofsystemandobjectprivilegesandotherroles.•❑B)TheCONNECTroleIsgrantedautomaticallytoauserwhenItIscreated.•❑C)RolesareownedbySYSTEM.•❑D)TheRE

7、SOURCEroleIsgrantedtheCREATESESSIONprivilege.•❑E)AsecureapplicationrolecanbesetonlybyItsassociatedPL/SQLpackage.•Answer:AE7、USER1grantsSELECT,INSERT,andUPDATEprivilegesonUSER1.EMPtoUSER2.SYSexecutesthiscommand:SQL>REVOKEUPDATEONuser1.empFROMu