单项选择题 Inwhichscenariowillyouperformanincompleterecovery？（）

单项选择题 Youexecutedthefollowingcommands：SQL>ALTERSESSIONSETOPTIMIZER_USE_PENDING_STATISTICS=false；SQL>EXECUTEDBMS_STATS.SET_TABLE_PREFS（’SH’，’CUSTOMERS’，’PUBLISH’，’false’）；SQL>EXECUTEDBMS_STATS.GATHER_TABLE_STATS（’SH’，’CUSTOMERS’）；WhichstatementiscorrectregardingtheabovestatisticscollectionontheSH.CUSTOMERStableintheabovesession？（）A.Thestatisticsarestoredinthependingstatisticstableinthedatadictionary.B.Thestatisticsaretreatedasthecurrentstatisticsbytheoptimizerforallsessions.C.Thestatisticsaretreatedasthecurrentstatisticsbytheoptimizerforthecurrentsessionsonly.D.Thestatisticsaretemporaryandusedbytheoptimizerforallsessionsuntilthissessionterminates.

单项选择题 WhilesettingupanOracledatabaseforoneofyourcriticalapplications，youwanttoensurethatthedatabaseisbackedupatregularintervalswithoutyourintervention.Whatshouldyoudotoachievetheobjective？（）

单项选择题 ExaminethefollowingPL/SQLblock：SETSERVEROUTPUTONSETLONG10000ECLAREreportclob；BEGINreport：=DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE（）；DBMS_OUTPUT.PUT_LINE（report）；END；WhichstatementdescribestheeffectoftheexecutionoftheabovePL/SQLblock？（）A.TheplanbaselinesareverifiedwiththeSQLprofiles.B.Allfixedplanbaselinesareconvertedintononfixedplanbaselines.C.AllthenonacceptedSQLprofilesareacceptedintotheplanbaseline.D.ThenonacceptedplansintheSQLManagementBaseareverifiedwiththeexistingplanbaselines.

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