【OCP｜052】2018最新考试题库原题-3-cuug

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

1、052题库解析CUUG-最新15道题www.cuug.com题库新特点：l更加灵活，题库的顺序与考试时的顺序每场都在变化l更加考验知识点的掌握，题库答案为二，考试时要求选择最佳一个答案l不断有新的考题出现，目前最新已经更新到130道题www.cuug.com•1、WhichtwoeventsalwaysrequesttheLGWRtowrite?•❑A)whenLGWRisnotifiedbyaserverprocessthatperformsaCommitorROLLBACK•❑B)WhenPMONrestartsaserverprocess •❑C)whenDBWnwr

2、itesdirtybuffers •❑D)whenalogswitchoccurs •❑E)whenacheckpointoccurs •Answer:CDwww.cuug.com•2、Examinethesecommandsandtheiroutput: •SQL>SELECT*FROMemp;•ENOENAME•---------•100Adam•101Alan•SQL>INSERTINTOempVALUES(102,'Ben"); •1rowcreated.•SQL>COMMIT;•Commitcompleted.•SQL>UPDATEempSETename='Bry

3、an'WHEREeno=102; •1rowupdated.•Apowerfailureoccurs.TheInstanceIsrestartedandthisqueryIsexecuted. •SQL>SELECTenameFROMemp;•WhatIstheoutcome?•❑A)OnlyAdamandAlanaredisplayed. •❑B)OnlyAdam,Alan,andBryanaredisplayed. •❑C)Adam,Alan,Ben,andBryanaredisplayed. •❑D)Norowsarereturned.www.cuug.com•❑E)

4、OnlyAdam,Alan,andBenaredisplayed. •Answer:Ewww.cuug.com•3、WhereIsbackupmetadatastoredforusebyRecoveryManager(RMAN)?•❑A)Inthecontrolfile •❑B)IntheSYSAUXtablespace •❑C)intheSPFILE•❑D)intheSYSTEMtablespace •❑E)Inthediagnosticdestinationflies •Answer:Awww.cuug.com•4、Whichtwocanbebackedupbyusin

5、gRMANwhena databaseIsopeninARCHIVELOGmode,sothatmedia recoverycanbeperformedIfrequired?•❑A)controlfiles •❑B)passwordfile •❑C)pfile•❑D)onlineredologs •❑E)flashbacklogs •❑F)datafiles•Answer:AFwww.cuug.com5、YourdatabaseisusingAutomaticMemoryManagement. WhichtwoSGAcomponentsmustbemanagedmanual

6、ly? •❑A)defaultbuffercache•❑B)redologbuffer•❑C)largepool•❑D)sharedpool•❑E)keepbufferpool•Answer:BEwww.cuug.com6、Whichtwoaretrueaboutroles?•❑A)Arolecanbegrantedacombinationofsystemandobjectprivilegesandotherroles.•❑B)TheCONNECTroleIsgrantedautomaticallytoauserwhenItIscreated.•❑C)Rolesareown

7、edbySYSTEM.•❑D)TheRESOURCEroleIsgrantedtheCREATESESSIONprivilege.•❑E)AsecureapplicationrolecanbesetonlybyItsassociatedPL/SQLpackage.•Answer:AEwww.cuug.com7、USER1grantsSELECT,INSERT,andUPDATEprivilegesonUSER1.EMPtoUSER2.SYSexecutesthiscommand:SQL>REVOKEUPDATEON