题目内容

YourcompanyusesaSQLServer2005database.Thisdatabasecontainsatriggernamedtrg_InsertOrders,whichfireswhenorderdataisinsertedintotheOrderstable.ThetriggerisresponsibleforensuringthatacustomerexistsintheCustomerstablebeforedataisinsertedintotheOrderstable.Youneedtoconfigurethetriggertopreventitfromfiringduringthedataimportprocess.Youmustaccomplishthisgoalwhileusingtheleastamountofadministrativeeffort.WhichtwoTransact-SQLstatementscanyouusetoachievethisgoal？（）

ALTERTABLEOrdersDISABLETRIGGERtrg_InsertOrders
B. DROPTRIGGERtrg_InsertOrders
C. DISABLETRIGGERtrg_InsertOrdersONOrders
D. ALTERTRIGGERtrg_InsertOrdersONOrdersNOTFORREPLICATION
E. sp_settriggerorder@triggername=‘trg_InsertOrders‘,@order=‘None‘

查看答案

搜索结果不匹配？点我反馈

更多问题

YourcompanyWebsiteincludesapagethatcustomersusetosendfeedbackaboutthecompanyanditsproducts.YouuseaSQLServer2005databasetostorethecommentsintheCommentscolumnofatablenamedFeedback.Youneedtoimplementfull-textsearchingsothatyoucanrunreportsonthecomments.Whichtwoactionsshouldyouperform？（）

A. CreateanonclusteredindexontheCommentscolumn.
B. ExecutetheUSEMasterTransact-SQLstatement.
Createafull-textcatalog.
D. Createafull-textindexontheCommentscolumn.

查看答案

YouneedtoensurethatthestoredprocedurethatinsertsnewloanrequestscanaccessdataintablesthatarestoredinanotherdatabaseonthesameSQLServerinstance.Whichtwoactionsshouldyouperform？（）

A. EnsurethatthestoredprocedureandthetablesareownedbyusersthatareassociatedwiththesameSQLServerlogin.
B. Ensurethatthestoredprocedureandthetablesareownedbythesamedatabaseuser.
C. Ensurethatthestoredprocedureandthetablesusethesamedatabaseschema.
D. Configurethemultiuserdatabaseoptiononbothdatabases.
E. Configurethecross-databaseownershipchainingoptiononbothdatabases.

查看答案

对S7－300进行编码时，可使用多种编程语言。（)

查看答案

当设置专用梯道时，梯道应设扶手栏杆，梯道的宽度不应小于lm。（)

查看答案

ALTERTABLEOrdersDISABLETRIGGERtrg_InsertOrders B. DROPTRIGGERtrg_InsertOrders C. DISABLETRIGGERtrg_InsertOrdersONOrders D. ALTERTRIGGERtrg_InsertOrdersONOrdersNOTFORREPLICATION E. sp_settriggerorder@triggername=‘trg_InsertOrders‘,@order=‘None‘

YourcompanyWebsiteincludesapagethatcustomersusetosendfeedbackaboutthecompanyanditsproducts.YouuseaSQLServer2005databasetostorethecommentsintheCommentscolumnofatablenamedFeedback.Youneedtoimplementfull-textsearchingsothatyoucanrunreportsonthecomments.Whichtwoactionsshouldyouperform？（）

YouneedtoensurethatthestoredprocedurethatinsertsnewloanrequestscanaccessdataintablesthatarestoredinanotherdatabaseonthesameSQLServerinstance.Whichtwoactionsshouldyouperform？（）

对S7－300进行编码时，可使用多种编程语言。（)

当设置专用梯道时，梯道应设扶手栏杆，梯道的宽度不应小于lm。（)

ALTERTABLEOrdersDISABLETRIGGERtrg_InsertOrders
B. DROPTRIGGERtrg_InsertOrders
C. DISABLETRIGGERtrg_InsertOrdersONOrders
D. ALTERTRIGGERtrg_InsertOrdersONOrdersNOTFORREPLICATION
E. sp_settriggerorder@triggername=‘trg_InsertOrders‘,@order=‘None‘