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

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

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

2、segment.•B.MultipletransactionsrunbydifferentOracleuserscanshareasingleundosegment.•C.Aserialtransactioncanusemultipleundosegments.•D.Undosegmentsareautomaticallydroppedshortlyaftertransactionsthatusethemcommit.•E.Anewundosegmentisalwayscreatedforeachtransaction. •F.Adatabase

3、canhavemultipleundotablespaces. •CorrectAnswer:ABFwww.cuug.com2、WhichtwoaretrueabouttheDataRecoveryAdvisor?•A.ItcanbeusedonlyfordatabasesthatarerunninginARCHIVELOGmode.•B.Itcanbeusedwhenthedatabaseisclosed. •C.Itcanbeusedtovalidatedatabaserecoverystrategies. •D.Itprovidesinte

4、lligentdatabaseproblemanalysis. •E.Itcanbeusedtovalidatedatabasebackupstrategies. •F.ItcanbeusedonlyfordatabaseswithFLASHBACKenabled. •CorrectAnswer:CDwww.cuug.com3、WhichtwoaretrueaboutOracleDataPumpinOracleDatabase11gRelease2?•A.Ifthedirectoryusedintheexportoperationhasexist

5、ingdumpfiles,itoverwritesthem.•B.Itallowsencryptiontobeperformedwithoutusingapassword.•C.Itsupportstherenamingoftablesduringimport. •D.Itsupportstheexportofspecificviewsastables. •E.Itallowscompressionlevelstobedefinedfortheexport. •CorrectAnswer:BEwww.cuug.com4、ForyourORCLda

6、tabase.1.Theinstanceisstartedusinganspfile.2.Thedatabaseisopened.3.ItisinARCHIVELOGmode.4.CONTROLFILEAUTOBACKUPISON. Examinethiscommand:RMAN>backupascopydatafile‘users01.dbf’,’example01.dbf’;Whichfourfilesarebackedup?•A.spfile•B.undo01.dbf•C.users01.dbf•D.archivelogs•E.sysaux

7、01.dbf•F.controlfile•G.system01.dbfwww.cuug.com•H.example01.dbfCorrectAnswer:ACFHwww.cuug.com5、Whendoesanincrementalcheckpointoccur? •A.whenDBWnwritesdirtybuffersaspartofitsnormalprocess •B.whenthealtersystemcheckpointstatementisexecuted. •C.whenausertablespaceistakenoffline

8、•D.whenanonlineredologswitchoccurs •CorrectAnswer:Awww.cuug.com6、Exa