单项选择题 YouhaverecoveredyourOracleDatabase10gbyusingthecontrolfilebackupbecauseallcopiesofthecurrentcontrolfilehavebeenlostduetoamediafailure.Youopenyourdatabasebyusingthefollowingstatement：SQL>ALTERDATABASEOPENRESETLOGS；WhichofthefollowingoptionsistrueaboutusingtheRESETLOGSoption？（）A.Thelogsequenceisresetto0.B.Alltheonlineredologsaredeleted.C.Allthearchivedredologsfromapreviousincarnationbecomeuseless.D.Thefulldatabasebackuptakenfromapreviousincarnationcanbeusedinfuture.E.OnlythecontrolfileandonlineredologfilesareupdatedwithanewRESETLOGSSCNandtimestamp.

单项选择题 YourtestdatabaseisrunninginNOARCHIVELOGmode.Whataretheimplicationsofthis？（）

单项选择题 TheSAVE_AMTcolumnintheACCOUNTStablecontainsthebalancedetailsofcustomersinabank.Aspartoftheyear-endtaxandinterestcalculationprocess，alltherowsinthetableneedtobeaccessed.Thebankauthoritieswanttotrackaccesstotherowscontainingbalanceamountsexceeding$200，000，andthensendanalertmessagetotheadministrator.Whichmethodwouldyousuggesttothebankforachievingthistask？（）A.implementingvalue-basedauditingbyusingtriggersB.implementingfine-grainedauditingwithauditconditionandeventhandlerC.performingstandarddatabaseauditingtoauditobjectprivilegesbysettingtheAUDIT_TRAILparametertoEXTENDEDD.performingstandarddatabaseauditingtoauditSQLstatementswithgranularitylevelsettoACCESS

单项选择题 InwhichscenarioisaDatabaseAdministratorNOTrequiredtoperformanincompleterecovery？（）

单项选择题 YouaremaintainingthedatabaseinOracle10g.YouareperforminganincompleterecoverybyusingRMANbecauseanimportanttable，EMPLOYEE，isdroppedandpurgedfromtheRecycleBin.WhichstatementisNOTtrueregardinganincompleterecovery？（）A.ThetargetdatabasemustbeintheMOUNTmodetoensurerestorationofthedatafiles.B.YoucanrestorethedatafilesfromthebackupbyusingtheRMANutilityonlyifthebackupsweretakenusingtheRMANutility.C.Thecontrolfilemustberecreated.D.ThedatabasemustbeopenedwiththeRESETLOGSoption.

单项选择题 Youhavealargeamountofhistoricaldatainaflatfile.Someanalystsinyourorganizationneedtoquerythisdatainthefile.Thefileistoolargetoloadthedatainitintoyourcurrentdatabase.Whichisthemosteffectivemethodtoaccessthisdatainyourdatabase（）A.Usethedatabaselink.B.UsetheSQL*Loaderutility.C.UsetheOracleDataPumputility.D.Createanexternaltableandleavethedataintheflatfile

单项选择题 ThebackupretentionpolicyisconfiguredasRECOVERYWINDOW2.YouexecutedthefollowingcommandinRecoveryManager（RMAN）againstyourdatabase：RMAN>REPORTOBSOLETE；Whatwouldyouseeintheoutput？（）

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