0５２题库解析最新１6道题０52-题库解析-５-201８0608题库新特点:更加灵活,题库的顺序与考试时的顺序每场都在变化更加考验知识点的掌握,题库答案为二，考试时要求选择最佳一个答案不断有新的考题出现，目前最新已经更新到130道题每周五晚8点-直播地址：ｋｅ.qq.com/cｏurse／３26223oｃｐ考试讨论群：8３63６1015验证：oｃpCUＵG整理，官网：www.cuug.ｃｏm1、Whichtｈreearetruｅaboutuｎｄosegmentｓandundotａblｅsｐaｃesintheｓamｅｄatａbaseaｎｄinstaｎcｅ?•A．MuｌtipletｒaｎsａctiｏnsｒunｂｙthesａmｅOraｃlｅｕsercaｎsｈareasinglｅuｎdoseｇment．•B.MultｉpｌetｒansactionsrunbydiffｅrentOracleｕsｅrscａｎshaｒeasｉnglｅundoｓegmeｎt．•C．Ａsｅrｉaltransａｃtioｎcaｎuｓｅｍｕltｉpleundoｓeｇments．•D.Uｎｄoseｇｍeｎtsaｒeａｕtomatｉｃａlｌｙｄroppedshｏrｔlyaftertranｓactionｓｔhatuseｔｈemｃｏｍｍiｔ．•E.Ａnｅｗuｎｄosegmenｔｉsalwaｙｓcrｅａteｄforeaｃhtrａnｓaｃtioｎ．ﻭ•F.Ａdatabaｓeｃａnhaｖemｕltipｌeundotablespaces．ﻭ•CorｒectＡnsweｒ：ABＦ2、WhichtwoaretrueａbouttｈeDaｔａＲecoveryAdvisｏｒ?•Ａ.ItｃaｎbeusedonｌyｆordatabaｓｅsthａtareｒunninginARCＨIVELOGmode.•B．Itcanbｅｕsedwheｎthedatabasｅisｃlosed.ﻭ•C.Itcａｎbeｕsedtoｖalidatedatａbaserecｏverystrategies．ﻭ•D.Iｔprｏvｉdesinｔeｌligentdataｂasepｒｏｂleｍａｎａｌysis.•E.Itcanbeuｓeｄtｏvalidatｅｄatabasｅbackupstratｅgies.•F.ＩｔｃanbeusｅｄonｌyfoｒｄataｂasｅsｗitｈFLASHＢＡCＫenａblｅd.ﻭ•CorrectＡnswｅr:ＣＤ3、WhichtwoaretｒueａｂoutOｒａclｅＤataPuｍpinOracleＤataｂａse１1ｇReｌeａｓｅ2?•A.Iｆthedirｅctoryuｓedinthｅexｐortoperatｉonhasｅｘistｉngｄumｐfilｅs，iｔoverwritesthｅm．•B．Ｉtalｌowsｅncrｙｐｔiontoｂeperformｅdwiｔhｏutusinｇapassｗord.•C．Itsuppoｒtｓthｅｒeｎamiｎgｏｆｔａｂｌesdurinｇimporｔ.ﻭ•D.Ｉtsｕpｐoｒｔstheexportofｓpeｃifiｃｖieｗsａｓtaｂleｓ.•E.Ｉtallｏwscｏmpressionlevelｓtｏbedefinedｆorｔｈeexport.•CoｒｒｅctAｎswer:BＥ4、FoｒyoｕrＯRCLdaｔabaｓe.1.Ｔｈeinstanｃeiｓsｔaｒtedusingaｎsｐfile．2．Thedataｂaseiｓopeｎed.3.ＩtiｓｉｎAＲＣHＩＶEＬＯＧmode.4.CＯNTROLFILEAUTOＢAＣKUＰISＯＮ.Examineｔhiｓcommand：RMAN＞ｂackupａscopydatafｉle‘ｕｓers01.ｄｂｆ’,’examplｅ01.dbf’;Ｗｈｉchfoｕrｆilesareｂaｃkedｕp?•Ａ．spfile•B.uｎdo01．dbf•C.userｓ01.dbf•D.arcｈivｅｌogs•E.sysａux01.dｂf•F.ｃonｔrolｆｉle•G.ｓｙstｅｍ０１.dｂf•Ｈ.example01．dｂfＣｏｒrectＡnswｅｒ:AＣFH5、Whendｏｅｓaninｃrｅｍｅntaｌcheｃkpointｏcｃur？ﻭ•Ａ.wｈenDBＷnwriteｓdiｒtｙbuｆfｅrsaspartｏfitsnｏrmalpｒocｅsｓﻭ•B.wｈentheaｌtersyｓtｅmcｈeｃkpｏintstatｅmｅｎｔisexecuted．ﻭ•C.ｗｈｅnａuｓerｔabｌespaｃeiｓｔakeｎｏｆflｉne•D.ｗhｅnaｎｏnlineｒeｄologswｉtchｏcｃuｒs•CorrｅctＡnsｗeｒ:A6、Examｉnethisｑuerｙａｎdｉtsｏutput:Whｉchtwoaretrue？•A．Theｂloｃkｅｄｓesｓioniswaitiｎgｏｎasharｅｄtablelock．ﻭ•Ｂ.Thｅblockｅdsｅｓsioｎiｓｗaｉｔingoｎanenｑｕeue.•C.Thｅbｌockiｎgsessioｎiswaitiｎgonａｒow－leveｌlock.•D.Ｓesｓiｏｎ１05isbloｃkｅdｂｙｓessiｏn15.•Ｅ．Sesｓioｎ1０５isblockingｓｅsｓion１５.•CorrectAnｓwer:BD•7、Inｏｎeofyourdaｔabaｓes:1.USER1ａndUSＥR2hａｖenoｓysteｍｐｒiｖiｌｅｇes.2.RＯLE1onlyhaｓtｈｅsｅprｉvｉlegｅs:ﻭ*creatｅsession*creａtetaｂle*crｅaｔeviewＥxａminethesecoｍmands:7Whichｃoｍｍａndwouldyｏuｅxecutｅanｄaswhiｃhｕser，ｔoreｖokｅｔhecreatetａbleｐｒivｉlｅgｅfｒomＵSER2?•A．Ｒevoｋeｃrｅatetabｌefｒｏmｕser2asuseｒ1•B.Reｖokecrｅatetableｆromｕｓer...
