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

单项选择题 YouwanttorebuildafreelistinthefreelistsoftheEMPLOYEEtableintheScottschema.Whichpackagewillyouusetoaccomplishthis？（）

单项选择题 Youareworkingonthe24X7databasewithhightransactionvolume，toensurefasterinstancerecoveryonyourdatabaseyousettheFAST_START_MTTR_TARGETinitializationparametertoaverylowvalue.Whateffectitwillhaveonthedatabase？（）A.Thedatabaseperformancewouldbeenhanced.B.Theredologfileswouldbegetfilledmorefrequently.C.Theoveralldatabaseperformancewouldbedegraded.D.Themeantimetorecover（MTTR）wouldbeincreased.

单项选择题 Youissuethefollowingstatement：SQL>SELECTFIRSTNAME，LASTNAMEFROMHR.EMPLOYEE；Youreceivethefollowingerror：01578：ORACLEdatablockcorrupted（file6，block54）ORA-01110：datafile6：’u01/oracle/oradata/data1.dbf’Howwillyouresolvethisproblemofdatablockcorruptionbyreducingthemeantimetorecover（MTTR）？（）A.byusingtheDBMS_REPAIRpackageB.byusingtheDBVERIFYutilityC.byusingBlockMediaRecoveryD.byissuingtheANALYZETABLEHR.EMPLOYEESVALIDATESTRUCTUREcommand

单项选择题 YourdatabaseisopenandusersareconnectedusingtheLISTENERlistener.ThenewDBAofthesystemstopsthelistenerbyusingthefollowingcommand：LSNRCTL>STOPWhatwouldhappentothesessionsthatarepresentlyconnectedtothedatabaseinstance？（）A.Thesessionsareabletoperformonlyqueries.B.Thesessionsarenotaffectedandcontinuetofunctionnormally.C.Theactivetransactionsarerolledbackandthesessionsgetterminated.D.Thesessionsarenotallowedtoperformanyoperationstillthelistenerisstarted.

单项选择题 WhatcommandwouldyouusetosetapersistentsettinginRMANsothatbackupsareallwrittentoatapedevice?（）

单项选择题 Whichdynamicviewdisplaysthestatusofblock－changetracking?（）

单项选择题 Youcreatedaresponsefileandwanttocheckitbeforestartinginstallationsinsilentmode.YoustartedinstallationofOraclesoftwareininteractivemodebyprovidingtheresponsefile.Inthemiddleoftheinstallation，yourealizethatthebehavioroftheOracleUniversalInstaller（OUI）isnotconsistentwiththeresponsefile.Whatactionwouldyoutaketodetectthecauseofthisbehavior？（）A.Comparethecontentsoftheinstall.logfilewiththeresponsefile.B.RefertothecontentsoftheoraInst.locfiletoverifythestepsperformedbyOUI.C.ComparethecontentsoftheinstallActions.logfilewiththatoftheresponsefile.D.RefertothealertlogfileforinformationregardingtheactionsperformedbyOUIduringinstallation.

单项选择题 Whatfeaturecomesintoplaytohelpensurethecompletionofthebackupshouldoneofthreebackupdevicesfailduringabackupthatisusingthreedifferentchannels?（）