数据库应用技术_在线作业_d（application of database technology _ online operation _d）

《数据库应用技术_在线作业_d（application of database technology _ online operation _d）》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、数据库应用技术_在线作业_d（Applicationofdatabasetechnology_onlineoperation_d）ExclusivelockmeansthatotherusersarenotallowedtoreadorupdatethedataonthemodifieddataKnowledgepoints:transactionin9.2programUseranswer:sharedlockreferstothedatabeingreadthatdoesnotallowotheruserstomodifythedata------

2、--------------------------------------------------------------------------EightTheglobalvariableofSQLServer2005is().(5points)canbeusedasavariablecountorasastorageunitforothervariablevalueswhentheuserneedsitStartwitha@character,definedandassignedbytheuseritselfStartwith@@characte

3、rsdefinedbythesystemvariablesandmaintenanceYoumustdeclarewithDECLAREstatementbeforeyoucanuseitKnowledgepoints:9.3SQLServervariablesAnswer:usersstartwith@@charactersdefinedbythesystemvariablesandmaintenance--------------------------------------------------------------------------

4、------NineInthefollowingdescriptionofbatchprocessing,theincorrectoneis().(5)batchprocessingisacollectionofoneormoreT-SQLstatementsIfabatchcontainssyntaxerrors,theentirebatchcannotbeexecutedBatchusestheGOstatementastheendflagIfasentenceinabatchhasanexecutionerror,theentirebatchca

5、nnotbeexecutedKnowledgepoints:batchprocessing,scriptandannotationin9.1programUseranswer:ifasentenceinabatchhasanexecutionerror,theentirebatchcannotbeexecuted--------------------------------------------------------------------------------TenThefollowingisincorrectinthedescription

6、oftriggers.(5)triggerscanbeusedtocheckconstraints,defaultvalues,andintegritycheckingofrules,andtoimplementmorecomplexdataintegrityconstraintsTriggersareaspecialtypeofstoredprocedureTriggerscanbecalleddirectlybytheuserbynameTriggersareautomaticallyactivatedwhenusersoperateandmana

7、gethedatabaseKnowledgepoints:theconceptof10.2.1triggersUseranswer:triggerscanbecalleddirectlybytheuserbyname--------------------------------------------------------------------------------ElevenThefollowingstatementdoesnotbelongtotheadvantageofaflip-flop.(5points)activatedimmedi

8、atelywhenthedataisupdatedonthetableParameterisn