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