单项选择题 Theapplicationworkloadonyourdatabaseissamebetween10a.m.and11a.m.onweekdays.Suddenlyyouobservepoorperformancebetween10a.m.and11a.m.inthemiddleoftheweek.Howwouldyouidentifythechangesinconfigurationsettings，workloadprofile，andstatisticstodiagnosethepossiblecausesoftheperformancedegradation？（）A.byusingtheSQLaccessadvisorB.byusingtheAutomaticWorkloadRepositoryreportC.byrunningtheAutomaticDatabaseDiagnosticMonitor（ADDM）D.byusingtheAutomaticWorkloadRepositoryComparePeriodreportE.byanalyzingtheoutputoftheV$ACTIVE_SESSION_HISTORYview

单项选择题 Whichstatementistrueaboutthelossofsystem－criticaldatafilesinARCHIVELOGmode？（）

单项选择题 YouquerytheORDERStableanddiscoverthatordernumber1101ismissing.Oneofyourreports，generatedat5：00A.M.onApril23，2005usingOracleReports，includesthisordernumberintheoutput.Youhaveinserted100newordersintotheORDERStablesincegeneratingthisreport.Whichflashbacktechnologywouldyouusetorecoverordernumber1101intotheORDERStablewithoutlosingthe100ordersthatyouaddedafterthereportwasgenerated？（）A.FlashbackTableB.FlashbackQueryC.FlashbackVersionQueryD.FlashbackTransactionQuery

单项选择题 Whichofthefollowingmostcloselyrepresentsanimagecopy?（）

单项选择题 InwhichscenariowillyouusetheFlashbackVersionQueryfeature？（）

单项选择题 YouaremanagingasingleinstanceOracle10gdatabasethatutilizesthefollowingparameters：WhichofthefollowingsetofcommandsmustyouexecutetoenableFlashbackDatabase？（）

单项选择题 YouareworkingasaDBAinanorganization.Theflashrecoveryareafilesarecreatedin’+disk1’.Youwanttocreatenewflashrecoveryareafilesinthe’+disk2’location.Thenewlocationoftheflashrecoveryareafilesshouldbewritteninthecontrolfileandthespfile.Whichcommandwillyouissuetochangethelocationoftheflashrecoveryareafiles？（）A.ALTERSYSTEMSETDB_RECOVERY_FILE_DEST=’+disk2’；B.ALTERSYSTEMSETDB_RECOVER_FILE_DEST=’+disk2’SCOPE=BOTH；C.ALTERSYSTEMSETDB_CREATE_FILE_DEST=’+disk2’；D.ALTERSYSTEMSETDB_CREATE_ONLINE_LOG_DEST_n=’+disk2’；

单项选择题 YouaremaintainingtheSALESdatabaseforanorganization.YouhaveenabledtheFlashbackDatabasefeatureandwanttoestimatetheflashbackspacerequiredforfutureoperations.Whichviewwouldyouquerytoestimatetheflashbackspacerequired？（）A.V$DATABASEB.V$FLASHBACK_DATABASE_STATC.V$FLASHBACK_DATABASE_LOGD.V$RECOVERY_FILE_DEST

单项选择题 YouupgradedOracleDatabase10gtoOracleDatabase11g.Howwouldthisaffecttheexistingusers’passwords？（）

单项选择题 YourOracleDatabase10gisonlinewhenyouexecutethefollowingstatement：SQL>ALTERTABLESPACEMY_TABLESPACEFLASHBACKOFF；WhatistheresultofexecutingthisstatementiftheFlashbackDatabasefeatureisalreadyenabledinthedatabase？（）A.ThedatabasedoesnotrecordflashbacklogsforMY_TABLESPACEB.ThetablesresidinginMY_TABLESPACEarenotprotectedbytheRecycleBin.C.AllthetablespacesexceptMY_TABLESPACEcanberecoveredusingFlashbackDatabasefeature.D.Noneoftheflashbacktechnologies，suchasFlashbackTable，FlashbackTransactionQueryandFlashbackVersionQuerycanbeusedtorecoverindividualrowswithintheobjectsfromMY_TABLESPACE

单项选择题 Whatisthepropercommandtoshutdownthedatabaseinaconsistentmanner?（）

单项选择题 Yourdatabaseinstanceiscurrentlyconfiguredtosupport1，500connections.TheWebapplicationthatusesthedatabaseallowsalargenumberofuserstoworkwiththedatabasesimultaneously.SomeusersoftheWebapplicationdonotinteractwiththeserverallthetime.Youwanttoincreasethescalabilitybyconfiguringthedatabaseinstancetohandlemoreconnections.AsaDBA，whichconfigurationwouldyousettosupportmorethan1，500connectionsatatime（）A.Youwouldconfiguremorelistenersforthedatabase.B.Youwouldconfigurethedatabaseinsharedservermodetousetheconnectionpoolingfeature.C.YouwouldincreasethevalueofthePGA_AGGREGATE_TARGETinitializationparameterthatassignsmoresessionmemorytousers.D.YouwoulddecreasethevalueofthePRIVATE_SGAresourcelimitintheprofilesusedbytheuserstoaccommodatemoresessioninformation.

单项选择题 YouaremaintainingthePRODdatabaseofTeleSoftCorporation.YouhaveinitializedthefollowingDB_BLOCK_CHECKINGparameterintheinit.orafile：DB_BLOCK_CHECKING=TRUE；Whatwillbetheresultofsettingthisparameter？（）

单项选择题 YouareusingtheBlockMediaRecoveryfeaturetorecovertheblocksthataremarkedcorruptsincethelastbackup.Whichviewwillyouquerytodisplayinformationaboutthedatablocksthataremarkedcorruptsincethelastbackup？（）

单项选择题 ThedatafilesofyourdatabaseareASMfiles.YouareperformingacheckfordatafileblockcorruptionbyusingtheDBVERIFYutility.WhatisaprerequisiteforcheckingblockcorruptiononanASMdatafilebyusingtheDBVERIFYutility？（）

单项选择题 ouhavebackedupyourdatabasetwicewithoutconnectingtotherecoverycatalog.Whatcommanddoyouissuetotransferthecontrol－filemetadatatotherecoverycatalog?（）

单项选择题 Youareusingflatfilesasthedatasourceforoneofyourdatawarehousingapplications.YouplantomovethedatafromtheflatfilestructurestoanOracledatabasetooptimizetheapplicationperformance.Inyourdatabaseyouhaveclusteredtables.Whilemigratingthedata，youwanttohaveminimalimpactonthedatabaseperformanceandoptimizethedataloadoperation.WhichmethodwouldyouusetoloaddataintoOracledatabase？（）A.usetheexternaltablepopulationB.usetheOracleDataPumpexportandimportutilityC.usetheconventionalpathdataloadofSQL*LoaderutilityD.usethedirectpathdataloadofOracleexportandimportutility

单项选择题 WhatwillbetheresultofusingtheSQL>DROPUSERSCOTTCASCADE；command？（）

单项选择题 Youwanttomakesurethatyourdatabasebackupdoesnotexceed10hoursinlength.Whatcommandwouldyouissuethatwouldmeetthiscondition?（）

单项选择题 TheSQLTuningAdvisorhasbeenconfiguredwithdefaultconfigurationsinyourdatabaseinstance.WhichrecommendationisautomaticallyimplementedwithouttheDBA’sinterventionaftertheSQLTuningAdvisorisrunaspartoftheAUTOTASKframework？（）A.statisticsrecommendationsB.SQLprofilerecommendationsC.index-relatedrecommendationsD.restructuringofSQLrecommendations