单项选择题 Inwhichsituationwillyourunthescriptcontainingthefollowingstatement？（）CREATECONTROLFILEREUSEDATABASESALESNORESETLOGSARCHIVELOGMAXLOGFILES20MAXLOGMEMBERS3MAXDATAFILES30MAXINSTANCES10MAXLOGHISTORY1200LOGFILEGROUP1（’/disk1/prod/orders/db/log1a.dbf’，’/disk2/prod/orders/db/log1b.dbf’）SIZE100KGROUP2（’/disk1/prod/orders/db/log2a.dbf’，’/disk2/prod/orders/db/log2b.dbf’）SIZE100K，DATAFILE’/disk1/prod/orders/db/database1.dbf’，’/disk2/prod/orders/db/file1.dbf’；

单项选择题 Youneedtocreateapartitionedtabletostorehistoricaldataandyouissuedthefollowingcommand：CREATETABLEpurchase_intervalPARTITIONBYRANGE（time_id）INTERVAL（NUMTOYMINTERVAL（1，’month’））STOREIN（tbs1，tbs2，tbs3）（PARTITIONp1VALUESLESSTHAN（TO_DATE（’1-1-2005’，’dd-mm-yyyy’）），PARTITIONp2VALUESLESSTHAN（TO_DATE（’1-1-2007’，’dd-mm-yyyy’）））ASSELECT*FROMpurchasesWHEREtime_id<TO_DATE（’1-1-2007’，’dd-mm-yyyy’）；Whatistheoutcomeoftheabovecommand？（）A.ItreturnsanerrorbecausetherangepartitionsP1andP2shouldbeofthesamerange.B.Itcreatestworangepartitions（P1，P2）.Withineachrangepartition，itcreatesmonthwisesubpartitions.C.Itcreatestworangepartitionsofvaryingrange.Fordatabeyond’1-1-2007，’itcreatespartitionswithawidthofonemontheach.D.Itreturnsanerrorbecausethenumberoftablespaces（TBS1，TBS2，TBS3）specifieddoesnotmatchthenumberofrangepartitions（P1，P2）specified.

单项选择题 Youexecutethefollowingcommandtoauditthedatabaseactivities：SQL>AUDITDROPANYTABLEBYscottBYSESSIONWHENEVERSUCCESSFUL；Whatistheeffectofthiscommand？（）

单项选择题 Youareperformingadatabaserecoverybecauseauser’sschemaisdropped.Whileperformingtherecovery，youusetheUNTILSEQUENCEclause.Whichtypeofdatabaserecoveryareyouperforming？（）

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