题目内容

茶夹是在烫洗杯具时用来夹住杯子、分茶时用来夹取品茗杯或闻香杯的器具。（)

查看答案

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

更多问题

施工单位在编制施工组织设计时，应制定预防高处坠落事故的安全技术措施。（)

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.

查看答案