Youissuethefollowingstatement：SQL>SELECTFIRSTNAME，LASTNAMEFROMHR.EMPLOYEE；Youreceivethefollowingerror：01578：ORACLEdatablockcorrupted（file6，block54）ORA-01110：datafile6：’u01/oracle/oradata/data1.dbf’Howwillyouresolvethisproblemofdatablockcorruptionbyreducin

题目

Youissuethefollowingstatement：SQL>SELECTFIRSTNAME，LASTNAMEFROMHR.EMPLOYEE；Youreceivethefollowingerror：01578：ORACLEdatablockcorrupted（file6，block54）ORA-01110：datafile6：’u01/oracle/oradata/data1.dbf’Howwillyouresolvethisproblemofdatablockcorruptionbyreducingthemeantimetorecover（MTTR）？（）

A.byusingtheDBMS_REPAIRpackage

B.byusingtheDBVERIFYutility

C.byusingBlockMediaRecovery

D.byissuingtheANALYZETABLEHR.EMPLOYEESVALIDATESTRUCTUREcommand

相似考题

1.YousetthevalueoftheSGA_TARGETinitializationparameterto1GtoenableOracletoautomaticallyresizemostofthememorycomponentsaccordingtothecurrentworkloadinthedatabase.Youissuethefollowingstatement：SQL>SELECTname，value，isdefault2FROMv$parameter3WHEREnameLIKE’%size%’；TheoutputofthisstatementdisplaysthattheDB_CACHE_SIZE，SHARED_POOL_SIZE，LARGE_POOL_SIZE，andJAVA_POOL_SIZEinitializationparameterscontainazerovalue.Whatdoesthisimply？（）A.TheSGA_TARGETinitializationparametercannotbesettoavaluelessthan1GB.TheSGA_TARGETinitializationparametercannotbesettoavaluegreaterthan1GC.TheMemoryAdvisoroftheOracleEnterpriseManager10gcannotbeusedtoobtainadviceontheimportantmemorycomponentsoftheSGAD.ThevaluesoftheDB_CACHE_SIZE，SHARED_POOL_SIZE，LARGE_POOL_SIZE，andJAVA_POOL_SIZEinitializationparameterscannotbesetmanually.E.NominimumlimitsareimposedontheDB_CACHE_SIZE，SHARED_POOL_SIZE，LARGE_POOL_SIZE，andJAVA_POOL_SIZEinitializationparameters.F.TheAutomaticSharedMemoryManagementfeaturecannotbedisabledunlessyouspecifyvaluesfortheDB_CACHE_SIZE，SHARED_POOL_SIZE，LARGE_POOL_SIZE，andJAVA_POOL_SIZEinitializationparametersintheinitializationparameterfile.

2.YouuseMicrosoft.NETFrameworkv3.5tocreateaMicrosoftASP.NETapplicationforCertkiller.com.Thecodesegmentbelowiswrittentocreateaclient-scriptThisnewlycreatedscriptwillmakeuseofASP.NETAJAX.ThescriptwillalsoupdatethetextofalltheLabelcontrolsinthewebform.IthascometoyourattentionthattheLabelcontrolsarenotupdatedwhentheclientscriptfunctionistested.However，youreceivethe"’null’isnullornotanobject"JavaScripterrormessageinthebrowser.Whatshouldyoudo？（）

3.通过 SQL，在表 Actor 中选择 FirstName 等于 Jim 而 LastName 等于 Carter 的所有记录的表述正确的是（）。A．SELECT * FROM Actor WHERE FirstName LIKE 'Jim' AND LastName LIKE 'Carter'B．SELECT FirstName='Jim', LastName='Carter' FROM ActorC．SELECT * FROM Actor WHERE FirstName='Jim' AND LastName='Carter'D．SELECT * FROM Actor WHERE FirstName='Jim' OR LastName='Carter'

4.YouaremaintainingyourdatabaseinOracle10g.Youwanttostoretheinformationaboutthebackupofthedatabaseinthecontrolfile.Youissuethefollowingstatement：SQL>ALTERSYSTEMSETCONTROL_FILE_RECORD_KEEP_TIME=400；Whatistheoutcomeofthisstatement？（）A.Thestatementwillnotexecutesuccessfully.B.Thestatementwillexecutesuccessfully，andthebackupsmetadatawillbemaintainedinthecontrolfilefor400daysC.Thestatementwillexecutesuccessfully，andthebackupsmetadatawillbemaintainedintherecoverycatalogfor400days.D.Backupswillbedeletedfromthemediaafter400days.

相关内容