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

单项选择题 Whatfeaturecomesintoplaytohelpensurethecompletionofthebackupshouldoneofthreebackupdevicesfailduringabackupthatisusingthreedifferentchannels?（）

单项选择题 YouwanttousetheFlashbackTransactionQueryfeaturetoidentifyallthechangesmadetoyourdatabasewithinaspecifictimeperiod.WhatisaprerequisiteforusingtheFlashbackTransactionQueryfeature？（）

单项选择题 Youbackedupthecontrolfiletotrace.Whichstatementistrueaboutthetracefilegenerated？（）

单项选择题 TheuserHRownstheEMPtable.TheuserHRgrantsprivilegestotheuserSCOTTbyusingthiscommand：SQL>GRANTSELECT，INSERT，UPDATEONempTOscottWITHGRANTOPTION；TheuserSCOTTexecutesthiscommandtograntprivilegestotheuserJIM：SQL>GRANTSELECT，INSERT，UPDATEONhr.empTOjim；Now，theuserHRdecidestorevokeprivilegesfromJIMusingthiscommand：SQL>REVOKESELECT，INSERT，UPDATEONempFROMjim；WhichstatementistrueafterHRissuestheREVOKEcommand（）A.ThecommandfailsbecauseSCOTTstillhasprivileges.B.ThecommandsucceedsandprivilegesarerevokedfromJIM.C.ThecommandfailsbecauseHRcannotrevoketheprivilegesfromJIM.D.ThecommandsucceedsandonlyHRhastheprivilegetoperformtheSELECT，INSERT，andUPDATEoperationsontheEMPtable.

单项选择题 Youwanttomonitorandcontroltheresourceusagebysessions.Youwanttobewarnedautomaticallywhenmorethan100sessionsareopenedwithyourdatabase.Whatactionwouldyoutaketoachievethis？（）

单项选择题 YouareperformingflashbackoftheORDERStableintheScott’sschemabecausesomeimportantdataisdeletedinthetablebymistake.TheSCNnumberwas771513atthetimeofdeletion.YouissuedthefollowingstatementtoperformFlashbackTable：SQL>FLASHBACKTABLEORDERSTOSCN771513；WhatistheprerequisitetoperformFlashbackTable？（）A.YoumustconfigureOMFinyourdatabase.B.Youmustenableblockchangetrackingfeatureinyourdatabase.C.YoumustenableROWMOVEMENTfeatureontheORDERStable.D.YoumustusetheFlashbackVersionQuerybeforeusingtheFlashbackTablefeature.

单项选择题 Yourdatabaseishavingtwocontrolfiles，threeredologfilegroupswithtwomembersineachgroup.Failureofwhichfilewouldcauseaninstancetoshutdown？（）

单项选择题 Whichcommanddoyouusetocreatearecovery－catalogschema?（）

单项选择题 YourdatabaseisinARCHIVELOGmode.Youlostanindextablespaceduetoadiskfailurewhilethedatabasewasopen.YouhaveneitherabackupofthelostindextablespacenorthescriptscontainingtheCREATEINDEXstatementstorecreatetheindexes.Currently，severalusersareexecutinglong-runningqueriesonthedatabase.Whatwillhappentotheongoingactivityinthedatabase？（）A.Thequeriesthatarecurrentlyexecutingwillabortandanerrormessagewillbereturnedtotheuser.B.Thequeriesthatarecurrentlyexecutingwillexecutenormallybutfuturequerieswillnotexecuted.C.DataManipulationLanguage（DML）statementscannotbeperformedonthetablesonwhichtheindexesarebased.D.Thecurrentlyexecutingandfuturequerieswillexecutenormally，butwillbeslower

单项选择题 OracleCoherenceisbestclassifiedas（）?

单项选择题 YouperformabackupusingthefollowingBACKUPcommand:RMAN>BACKUPASCOMPRESSEDBACKUPSETDATABASE,Whichstatementistrueofthiscommand?（）

单项选择题 Youhavecreatedapasswordfileusingthefollowingcommand：ORAPWDfile=d：oracleora9iorapwU01password=change_on_installentries=3Whichofthefollowingistrueaboutthispasswordfile？（）

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