数据库应用技术_在线作业_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@@charactersdefinedbythesystemvariablesandmaintenanc

3、eYoumustdeclarewithDECLAREstatementbeforeyoucanuseitKnowledgepoints:9.3SQLServervariablesAnswer:usersstartwith@@charactersdefinedbythesystemvariablesandmaintenance--------------------------------------------------------------------------------NineInthefollowingdescriptionofbatchprocessing,theincorre

4、ctoneis().(5)batchprocessingisacollectionofoneormoreT-SQLstatementsIfabatchcontainssyntaxerrors,theentirebatchcannotbeexecutedBatchusestheGOstatementastheendflagIfasentenceinabatchhasanexecutionerror,theentirebatchcannotbeexecutedKnowledgepoints:batchprocessing,scriptandannotationin9.1programUserans

5、wer:ifasentenceinabatchhasanexecutionerror,theentirebatchcannotbeexecuted--------------------------------------------------------------------------------TenThefollowingisincorrectinthedescriptionoftriggers.(5)triggerscanbeusedtocheckconstraints,defaultvalues,andintegritycheckingofrules,andtoimplemen

6、tmorecomplexdataintegrityconstraintsTriggersareaspecialtypeofstoredprocedureTriggerscanbecalleddirectlybytheuserbynameTriggersareautomaticallyactivatedwhenusersoperateandmanagethedatabaseKnowledgepoints:theconceptof10.2.1triggersUseranswer:triggerscanbecalleddirectlybytheuserbyname------------------

7、--------------------------------------------------------------ElevenThefollowingstatementdoesnotbelongtotheadvantageofaflip-flop.(5points)activatedimmediatelywhenthedataisupdatedonthetableParameterisn