单项选择题 WhichvalueisvalidfortheiterateparameterinSET_TIMERbuilt－inprocedure?（）

单项选择题 YouhavethreetemporarytablespacegroupsnamedG1，G2，andG3inyourdatabase.Youarecreatinganewtemporarytablespaceasfollows：CREATETEMPORARYTABLESPACETEMP1TEMPFILE’/u1/data/temp1.dbf’SIZE10MTABLESPACEGROUP；Whichstatementregardingtheabovecommandiscorrect？（）A.ItwillcreatethetablespaceTEMP1ingroupG1.B.ItwillcreatethetablespaceTEMP1ingroupG3.C.ItwillnotaddthetablespaceTEMP1toanygroup.D.ItwillcreatethetablespaceTEMP1inthedefaultgroup.

单项选择题 Integrationbetween（）multidatasourcesand（）isdefinedastheGridLinkforRAC.

单项选择题 A simple master－to－slave replication is currently being used. The following information is extracted from the SHOW SLAVE STATUS output:Last_SQL_Error: Error 'Duplicate entry '8' for key 'PRIMARY

单项选择题 WhathappenswhenthreadXexecutesawait（）methodonobjectA，withoutowningobjectA’slock？（）

单项选择题 byte[]arry1，array2[]；bytearray3[][]；byte[][]array4；Ifeacharrayhasbeeninitialized，whichstatementwillcauseacompilererror？（）

单项选择题 interfacefoo{2.intk=0；3.}4.5.publicclasstestimplementsFoo（6.publicstaticvoidmain（Stringargs[]）（7.inti；8.Testtest=newtest（）；9.i=test.k；10.i=Test.k；11.i=Foo.k；12.）13.）14.Whatistheresult？（）

单项选择题 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