单项选择题 Youareresponsibleforadatawarehouseapplicationthatusesrecordsfromanexternaltabletoupdateoneofthedimensiontablesperiodically.Therecordsintheexternaltablemaycontaindatafornewrowsinthedimensiontable，orforupdatestoitsexistingrows.WhichtypeofSQLcommandwouldyouusetotransferthedatafromtheexternaltabletothedimensiontableasefficientlyaspossible？（）A.MERGEB.SELECT…CROSSJOINC.INSERTALL…SELECTD.CREATEVIEW…CONSTRAINT

单项选择题 Youwanttoperforminincompleterecoveryofyourdatabase.Youplantousethesecommandstorecoveryourdatabase：SETUNTILTIME=’2000－12－09：11：44：00’；RESTOREDATABASE；RECOVERDATABASE；Howshouldthecommandsbeexecuted？（）

单项选择题 Whenperforminganincompleterecoverofthewholedatabase，whichdatafilesmustyourestore？（）

单项选择题 YourdatabaseisrunningintheARCHIVELOGmode.Youplacedatablespace，tbs_1，offlinewiththeimmediateoption.Whichstatementiscorrectinthisscenario？（）

单项选择题 下列哪项任务只能在动态磁盘上执行（）

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