单项选择题
单项选择题 Whichdynamicviewdisplaysthestatusofblock-changetracking?()
单项选择题 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?()