单项选择题 Inyourdatabase，theRESULT_CACHE_MODEparameterhasbeensettoMANUALintheinitializationparameterfile.Youissuedthefollowingcommand：SQL>SELECT/*+RESULT_CACHE*/sale_category，sum（sale_amt）FROMsalesGROUPBYsale_category；Wherewouldtheresultofthisquerybestored（）？A.databasebuffercacheB.sharedpoolC.PGAD.largepool

单项选择题 Redologfilesarenotmultiplexedinyourdatabase.Redologblocksarecorruptedingroup2，andarchivinghasstopped.Alltheredologsarefilledanddatabaseactivityishalted.Databasewriterhaswritteneverythingtodisk.Whichcommandwouldyouexecutetoproceedfurther？（）A.RECOVERLOGFILEBLOCKGROUP2；B.ALTERDATABASEDROPLOGFILEGROUP2；C.ALTERDATABASECLEARLOGFILEGROUP2；D.ALTERDATABASERECOVERLOGFILEGROUP2；E.ALTERDATABASECLEARUNARCHIVEDLOGFILEGROUP2；

单项选择题 YouhaveanAutomaticStorageManagement（ASM）instancemanagingthedatabasefilesofyourproductiondatabase.ThedatabasecontainsASMfilesandnon-ASMfiles.UsingRecoveryManager（RMAN），youmigratethecompleteproductiondatabasetousetheASMinstance.Whichstatementistrue？（）A.RMANwouldrelocateallthedatafilestoanASMdiskgroupandotherfilestoanoperatingsystemlocation，definedusingOracleManagedFiles（OMF）.B.RMANwouldrelocatetheASMfilestoanASMdiskgroupandthenon-ASMfilestoanoperatingsystemlocation，definedusingOMFC.RMANwouldrelocateallthedatabasefilestoanASMdiskgroup.D.RMANwouldchangethefiledefinitionsinthecontrolfiletousetheASMbutwouldnotrelocatethedatabasefilesphysically.

单项选择题 OnMonday，youdroppedtheDEPTtablefromyourschemaandthenyoure－createdtheDEPTtableinyourschema.OnWednesday，youhavearequirementtorestoretheDEPTtablefromtherecyclebin.Whichstatementiscorrect？（）

单项选择题 Whenisanimplicitanchorcreated?（）

单项选择题 Youareusingthefollowingcommandtoclearthelogfilegroup：ALTERDATABASECLEARLOFFILEGROUP2；Inwhichcasewouldthecommandbesuccessful？（）

判断题 5GNR中的CU－DU分离架构便于实现RAN的虚拟化。( )

单项选择题 Youwanttoconfigureandscheduleofflinedatabasebackupstorunautomatically.Whichtoolorutilitywouldyouusetoachievethis（）

单项选择题 Youhavearead-onlytablespaceonread-onlymedia.Youwanttoperformamediarecoveryontheexistingdatafiles，butusingabackupcontrolfile.Thebackupcontrolfileindicatesthatthestatusoftheread-onlytablespacewasread/writewhenthecontrolfilewasbackedup.Whatshouldyouconsider？（）A.takedatafilesfromtheread-onlytablespaceofflinebeforeperformingarecoveryB.recoveryusingbackupcontrolfileisnotpossible，sorestoreallthefilesfromthelastfulldatabasebackup，andthenopenthedatabaseC.droptheread-onlytablespaceandre-createthetablespaceafterrecoveryD.performarecovery；statusofthetablespaceincontrolfilewillbechangedautomatically

单项选择题 Givenamethodthatmustensurethatitsparameterisnotnull：11.publicvoidsomeMethod（Objectvalue）{12.//checkfornullvalue...20.System.out.println（value.getClass（））；21.}Whatinsertedatline12，istheappropriatewaytohandleanullvalue？（）A.assertvalue==null；B.assertvalue!=null，"valueisnull"；C.if（value==null）{thrownewAssertionException（"valueisnull"）；}D.if（value==null）{thrownewIllegalArgumentException（"valueisnull"）；}

单项选择题 YouaremaintainingyourdatabaseinOracle10g.Youwanttostoretheinformationaboutthebackupofthedatabaseinthecontrolfile.Youissuethefollowingstatement：SQL>ALTERSYSTEMSETCONTROL_FILE_RECORD_KEEP_TIME=400；Whatistheoutcomeofthisstatement？（）A.Thestatementwillnotexecutesuccessfully.B.Thestatementwillexecutesuccessfully，andthebackupsmetadatawillbemaintainedinthecontrolfilefor400daysC.Thestatementwillexecutesuccessfully，andthebackupsmetadatawillbemaintainedintherecoverycatalogfor400days.D.Backupswillbedeletedfromthemediaafter400days.

单项选择题 Youhaveissuedthefollowingcommand：RMAN>CONFIGURERETENTIONPOLICYTORECOVERYWINDOWOF100DAYS；Whatwillbetheresultofusingtheabovecommand？（）

单项选择题 YouwanttoadministeryourPRODdatabasefromaremotehostmachineusingaWeb－enabledinterface.WhichOracletoolwouldyouusetoaccomplishthistaskefficientlywithoutusingcommand－lineinterfaces？（）

单项选择题 Usingthereportsserverhowwouldyouforcetheordersreportintheordersentryapplicationtoruneverysixhours?（）

单项选择题 YouaremaintainingtheSALESdatabaseofacompany.YouhaveneverbackeduptheUSERStablespacethatiscurrentlyoffline.OnSunday，youissuedthefollowingcommands：CONFIGUREDEFAULTDEVICETYPETOsbt；CONFIGUREBACKUPOPTIMIZATIONON；CONFIGURERETENTIONPOLICYTOREDUNDANCY3；FromMondaytoSaturday，youperformedthefollowingactions：DayActionMondayBACKUPDATABASETuesdayBACKUPDATABASEWednesdayBACKUPDATABASEThursdayBACKUPDATABASEFridayBACKUPDATABASESaturdayBACKUPDATABASEHowmanytimeswillthebackupoftheUSERStablespacebeperformed？（）

单项选择题 Youareusingflatfilesasthedatasourceforoneofyourdatawarehousingapplications.Tooptimizetheapplicationperformance，youplantomovethedatafromtheflatfilestoclusteredtablesinanOracledatabase.Whilemigratingthedata，youwanttohaveminimalimpactonthedatabaseperformanceandoptimizethedataloadoperation.WhichmethodwouldyouusetoloaddataintotheOracledatabase（）A.Usetheexternaltablepopulation.B.UsetheOracleDataPumpexportandimportutility.C.UsetheconventionalpathdataloadoftheSQL*Loaderutility.D.UsetheINSERTINTO...SELECTcommandtoloadthedata.

单项选择题 Youarecreatingasalesdatatemplateandneedtoaddapicturetothemargin.Whatisthebestwaytoaddthismargin?（）

单项选择题 AcustomerhasawebapplicationwithHTTPSessionsthatneedtobereplicatedtoabackupsitethatismorethan100milesawayfromtheprimarysite,connectedovertheInternet.WhichtypeofsessionreplicationinWebLogicisrecommended?（）A.MANReplicationB.WANReplicationC.SynchronousReplicationD.AsynchronousReplicationE.DatabaseReplication

单项选择题 Howwouldyoudefaultthelayoutofaparameterform?（）

单项选择题 WhichmethodintheThreadclassisusedtocreateandlaunchanewthreadofexecution？（）