单项选择题 YouareaDatabaseAdministratorwithWonderWeb.You&en

单项选择题 InSolaris10，thistoolprovidesanautomatedandproactiveapproachtopatchmanagement.Itprovidesagraphicaluserinterfaceaswellasacommandlineinterface.Whichtoolisit？（）

单项选择题 Yoususpectunauthorizeddatamanipulationlanguage（DML）operationsonaparticulartable.Youwanttotrackuserswhoareperformingthetransactionsandthevaluesusedinthetransactions.Also，youplantotransferthesevaluestoanothertableforanalysis.Howwouldyouachievethis？（）A.byusingtriggersB.byusingexternaltablesC.byusinganonymousPL/SQLblocksD.byauditingallDMLoperationsonthetable

单项选择题 YouusedtheIMMEDIATEoptiontoshutdownyourdatabaseinstance.Considerthestepsthatmayoccurwhenadatabaseinstanceisstartedanddatabaseisopened：1：SGAisallocated.2：Controlfileisread.3：Redologfilesareopened.4：Instancerecoveryisstarted.5：Backgroundprocessesarestarted.6：Datafileheadersarecheckedforconsistency.7：Serverparameterfileortheinitializationparameterfileisread.Whichoptionhasthecorrectorderinwhichthesestepsoccur（）A.7，1，5，2，3，6，4B.1，5，7，2，3，6；step4isnotrequiredC.7，1，5，2，3，6；step4isnotrequiredD.1，2，3，5，6，4；step7isnotrequired

单项选择题 hichofthefollowingRMANstructurescandatafromadatafilespan?（）

单项选择题 YouwanttheuserAPP_DBAtoadministertheOracledatabasefromaremotemachine.APP_DBAisgrantedtheSYSDBAprivilegetoperformadministrativetasksonthedatabase.WhichfileisusedbytheOracledatabaseservertoauthenticateAPP_DBA？（）A.controlfileB.passwordfileC.listenercontrollerfileD.controlfileandpasswordfile

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