单项选择题 Youfindthatsomequeriesonatablearetakingalongtimetoexecutebecausetherearenoindexescreatedonthetable.YoudecidetoinvoketheSQLAccessAdvisortodeterminetheappropriateindextobecreated.WhichpackagewillyouusetoinvoketheSQLAccessAdvisor？（）A.DBMS_SERVER_ALERTB.DBMS_ADVISORC.DBMS_RESOURCE_MANAGERD.DBMS_REPAIR

单项选择题 YouaremaintainingtheSALESdatabaseforeSoftCorporation.YouhavenotconfiguredASMMonthedatabase.YouwanttoknowwhatsizeoftheSGAwillprovidethebestperformance.WhichadvisorwouldyouusetodeterminethesuitablesizeoftheSGA？（）A.SQLTuningAdvisorB.UndoAdvisorC.ADDMD.MemoryAdvisor

单项选择题 Whichofthefollowingdoestherecovercommandnotdo？（）

单项选择题 Ifyoulostyourentiredatabase，includingthedatabasespfile，controlfiles，onlineredologs，anddatabasedatafiles，whatkindofrecoverywouldberequiredwithRMAN？（）

单项选择题 YouworkasadatabaseadministratorforSupportcenter.cn.Oneoftheusersessionswasterminatedabnormallyinthemiddleofatransaction.WhatdoesOracledatabasedotorecoverit？（）

单项选择题 YouworkasadatabaseadministratorforSupportcenter.cn.Yoususpectthatinoneofyourapplicationsthecustomertableisbeingaccessedbysomeunauthorizedusers.Whichoptionwouldyouusetomonitorthequeriesbeingexecutedonthecustomertable？（）A.Monitorthealert.logfileB.Enableserver-sideSQLtracingforusersessionsC.Enablefine-grainedauditingforthecustomertableD.EnableFine-GrainedAccessControl（FGAC）forthecustomertableE.WriteadatabasetriggeronthecustomertableontheSELECTevent

单项选择题 Theperformanceofyourdatabaseisaffectedbythepresenceoftwologmembersineachonlineredologgroupandtheplacementofredologmembersofagrouponthesamedisk.Youdecidetoplacetheredologmembersofagrouponseparatedisks.Whichviewwillyouquerytofindthenameandlocationofalltheonlineredologmembers？（）A.V$LOGB.V$LOGFILEC.DBA_LOG_GROUPSD.V$LOG_HISTORY

单项选择题 Whichcommandisusedtoopenthedatabaseafteranincompleterecovery？（）

单项选择题 Inwhichscenariowillyouperformauser－managedincompleterecovery？（）

单项选择题 YouexecutedthefollowingPL/SQLblocksuccessfully：VARIABLEtnameVARCHAR2（20）BEGINdbms_addm.insert_finding_directive（NULL，DIR_NAME=>’DetailCPUUsage’，FINDING_NAME=>’CPUUsage’，MIN_ACTIVE_SESSIONS=>0，MIN_PERC_IMPACT=>90）；：tname：=’databaseADDMtask4’；dbms_addm.analyze_db（：tname，150，162）；END；/Thenyouexecutedthefollowingcommand：SQL>SELECTdbms_addm.get_report（：tname）FROMDUAL；TheabovecommandproducesAutomaticDatabaseDiagnosticMonitor（ADDM）analysis（）A.withtheCPUUsagefindingifitislessthan90B.withouttheCPUUsagefindingifitislessthan90C.withtheCPUUsagefindingforsnapshotsbelow90D.withtheCPUUsagefindingforsnapshotsnotbetween150and162

单项选择题 Whichisthevalididentifier？（）

单项选择题 WhilerunningtheOracleUniversalInstalleronaUnixplatformtoinstallOracleDatabase10gsoftware，youarepromptedtorunorainstRoot.shscript.Whatdoesthisscriptaccomplish？（）

单项选择题 classGuy｛Stringgreet（）｛returnhi｝｝classCowboyextendsGuy｛Stringgreet（）｛returnhowdy”｝｝classSurferextendsGuy｛Stringgreet（）｛returndudel”｝｝classGreetings{publicstaticvoidmain（string[]args）{Guy[]guy={newGuy（），newCowboy（），newSurfer（）}；for（Guy0：guys）System.out.print（g.green（））；｝｝结果为：A.运行时异常被输出B.第7行出现一个错误，编译失败C.第8行出现一个错误，编译失败D.hihihiE.hihawdydoude

单项选择题 GiventhecommandlinejavaPass2and：publicclassPass2{publicvoidmain（String[]args）{intx=6；Pass2p=newPass2（）；p.doStuff（x）；System.out.print（”mainx=+x）；}voiddoStuff（intx）{System.out.print（”doStuffx=+x++）；}}Whatistheresult？（）A.Compilationfails.B.Anexceptionisthrownatruntime.C.doStuffx=6mainx=6D.doStuffx=6mainx=7E.doStuffx=7mainx=6F.doStuffx=7mainx=7

单项选择题 publicclassPerson{privatename；publicPerson（Stringname）{this.name=name；}publicbooleanequals（Objecto）{if（!oinstanceofPerson）returnfalse；Personp=（Person）o；returnp.name.equals（this.name）；}}Whichistrue？（）

单项选择题 Dated=newDate（0L）；17.Stringds=December15，2004”；18.／／insertcodehereWhatupdatesd?svaluewiththedaterepresentedbyds？（）

单项选择题 //pointXpublicclassfoo{publicstaticvoidmain（Stringargs）throwsException{java.io.printWriterout=newjava.io.PrintWriter{newjava.io.outputStreamWriter（System.out），true；out.printIn（Hello”）；}}}WhichstatementatPointXonline1allowsthiscodetocompileandrun？（）A.Importjava.io.*；B.Includejava.io.*；C.Importjava.io.PrintWriter；D.Includejava.io.PrintWriter；E.Nostatementisneeded.

单项选择题 Youwanttolimitaccesstoamethodofapublicclasstomembersofthesameclass.Whichaccessaccomplishesthisobjective？（）

单项选择题 publicclassTest{publicstaticvoidmain（String[]argv）{//insertstatementhere}}Whichstatement，insertedatline3，producesthefollowingoutput？（）Exceptioninthreadmain”java.lang.AssertionError：trueatTest.main（Test.java：3）A.asserttrue；B.assertfalse；C.assertfalse：true；D.assertfalse==true；E.assertfalse：false；

单项选择题 Youobservethatdatabaseperformancehasdegradedoveraperiodoftime.Whileinvestigatingthereason，youfindthatthesizeofthedatabasebuffercacheisnotlargeenoughtocachealltheneededdatablocks.Whichadvisorycomponentwouldyoureferto，inordertodeterminetherequiredsizeofthedatabasebuffercache？（）A.MemoryAdvisorB.SegmentAdvisorC.SQLTuningAdvisorD.SQLAccessAdvisorE.AutomaticDatabaseDiagnosticMonitor（ADDM）