网友您好， 请在下方输入框内输入要搜索的题目：

题目内容 （请给出正确答案）

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

参考答案

更多 “ Youissuethefollowingstatement：SQLSELECTFIRSTNAME，LASTNAMEFROMHR.EMPLOYEE；Youreceivethefollowingerror：01578：ORACLEdatablockcorrupted（file6，block54）ORA-01110：datafile6：’u01/oracle/oradata/data1.dbf’Howwillyouresolvethisproblemofdatablockcorruptionbyreducingthemeantimetorecover（MTTR）？（）A.byusingtheDBMS_REPAIRpackageB.byusingtheDBVERIFYutilityC.byusingBlockMediaRecoveryD.byissuingtheANALYZETABLEHR.EMPLOYEESVALIDATESTRUCTUREcommand ” 相关考题
考题 YousetthevalueoftheSGA_TARGETinitializationparameterto1GtoenableOracletoautomaticallyresizemostofthememorycomponentsaccordingtothecurrentworkloadinthedatabase.Youissuethefollowingstatement：SQLSELECTname，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.
查看答案
考题 YouaremaintainingyourdatabaseinOracle10g.Youwanttostoretheinformationaboutthebackupofthedatabaseinthecontrolfile.Youissuethefollowingstatement：SQLALTERSYSTEMSETCONTROL_FILE_RECORD_KEEP_TIME=400；Whatistheoutcomeofthisstatement？（）A.Thestatementwillnotexecutesuccessfully.B.Thestatementwillexecutesuccessfully，andthebackupsmetadatawillbemaintainedinthecontrolfilefor400daysC.Thestatementwillexecutesuccessfully，andthebackupsmetadatawillbemaintainedintherecoverycatalogfor400days.D.Backupswillbedeletedfromthemediaafter400days.
查看答案
考题 YouuseMicrosoft.NETFrameworkv3.5tocreateaMicrosoftASP.NETapplicationforCertkiller.com.Thecodesegmentbelowiswrittentocreateaclient-scriptThisnewlycreatedscriptwillmakeuseofASP.NETAJAX.ThescriptwillalsoupdatethetextofalltheLabelcontrolsinthewebform.IthascometoyourattentionthattheLabelcontrolsarenotupdatedwhentheclientscriptfunctionistested.However，youreceivethe’null’isnullornotanobjectJavaScripterrormessageinthebrowser.Whatshouldyoudo？（）
查看答案
考题 通过 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'
查看答案
热门标签
最新试卷