OCP考试052最新考试题库原题-5-20180608

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

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

2、atabaseandinstance?•A.MultipletransactionsrunbythesameOracleusercanshareasingleundosegment.•B.MultipletransactionsrunbydifferentOracleuserscanshareasingleundosegment.•C.Aserialtransactioncanusemultipleundosegments.•D.Undosegmentsareautomaticallydroppedshortlyafter

3、transactionsthatusethemcommit.•E.Anewundosegmentisalwayscreatedforeachtransaction. •F.Adatabasecanhavemultipleundotablespaces. •CorrectAnswer:ABF2、WhichtwoaretrueabouttheDataRecoveryAdvisor?•A.ItcanbeusedonlyfordatabasesthatarerunninginARCHIVELOGmode.•B.Itcanbeuse

4、dwhenthedatabaseisclosed. •C.Itcanbeusedtovalidatedatabaserecoverystrategies. •D.Itprovidesintelligentdatabaseproblemanalysis. •E.Itcanbeusedtovalidatedatabasebackupstrategies. •F.ItcanbeusedonlyfordatabaseswithFLASHBACKenabled. •CorrectAnswer:CD3、Whichtwoaretruea

5、boutOracleDataPumpinOracleDatabase11gRelease2?•A.Ifthedirectoryusedintheexportoperationhasexistingdumpfiles,itoverwritesthem.•B.Itallowsencryptiontobeperformedwithoutusingapassword.•C.Itsupportstherenamingoftablesduringimport. •D.Itsupportstheexportofspecificviews

6、astables. •E.Itallowscompressionlevelstobedefinedfortheexport. •CorrectAnswer:BE4、ForyourORCLdatabase.1.Theinstanceisstartedusinganspfile.2.Thedatabaseisopened.3.ItisinARCHIVELOGmode.4.CONTROLFILEAUTOBACKUPISON. Examinethiscommand:RMAN>backupascopydatafile‘users01

7、.dbf’,’example01.dbf’;Whichfourfilesarebackedup?•A.spfile•B.undo01.dbf•C.users01.dbf•D.archivelogs•E.sysaux01.dbf•F.controlfile•G.system01.dbf•H.example01.dbfCorrectAnswer:ACFH5、Whendoesanincrementalcheckpointoccur? •A.whenDBWnwritesdirtybuffersaspartofitsnormalpr

8、ocess •B.whenthealtersystemcheckpointstatementisexecuted. •C.whenausertablespaceistakenoffline •D.whenanonlineredologswitchoccurs •CorrectAnswer:A6、Exam