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

[单选题]

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

A.ALTERTABLEOrdersDISABLETRIGGERtrg_InsertOrders

B.DROPTRIGGERtrg_InsertOrders

C.DISABLETRIGGERtrg_InsertOrdersONOrders

D.ALTERTRIGGERtrg_InsertOrdersONOrdersNOTFORREPLICATION

E.sp_settriggerorder@triggername=‘trg_InsertOrders‘,@order=‘None‘

查看答案

如搜索结果不匹配，请联系老师获取答案

您可能会需要：

重置密码查看订单联系客服

安装上学吧APP，拍照搜题省时又省心！

更多“YourcompanyusesaSQLServer2005d…”相关的问题

第1题

Youaredesigningtheloanapplicationprocessforthecustomerterminals.YouneedtodesignaTransact-S

QLstoredprocedurethatfulfillsthebusinessandtechnicalrequirements.WhichtypeofTransact-SQLstoredprocedureshouldyouuse?（）

A.onethatusesaninternalSQLServerWebserviceendpoint

B.onethatrunsaSQLServerIntegrationServices（SSIS）package

C.onethatusesServiceBroker

D.onethatrunsauser-definedfunction

点击查看答案

第2题

YouworkwithaSQLServer2005databasethatprovidesbankinginformationforcustomers.Youwantcustome

rstoseebankingreportsthatcombinedatathatisretrievedfromthedatabasewithreal-timeinvestmentinformationthatcomesfromaWebserviceprovidedbyathirdparty.Theinvestmentinformationmustbecurrentwhenthereportsareexecuted.Youneedtocreatetheappropriateobjectsthatsupportthereports.Whatshouldyoudo?（）

A.PublishthedatainthedatabaseasanXMLWebservicebyusingtheFORXMLAUTOclause.

B.Createatabletostorethebankinginformationforeachcustomer.CreateatriggerthatfireswhendataisinsertedintothetablethatjoinswiththedatacomingfromtheWebservice.

C.CreateaTransact-SQLstoredprocedurethatusesatemporarytabletostorethebankinginformationforeachcustomer.UpdatethetablewiththevaluesfromtheWebservice.

D.HaveadeveloperinyourcompanycreateanassemblythatcallstheremoteWebservice.CreateaCLRfunctionbyusingtheassembly.CalltheCLRfunctionandcombinetheresultswithbankinginformationinthedatabase.

点击查看答案

第3题

Youneedtodesigntheretrievalofadvertisingstatisticswithoutcompromisingsecurity.Whatshouldyoudo?（）

A.DesignaNotificationServicessolutionthatsendstheadvertisingstatisticstospecifiedsubscribersbye-mail.

B.DesignaSQLServerWebservicethatrunsastoredproceduretoreturnthestatisticsonacallfromtheadvertisersapplication.

C.DesignaDatabaseMailsolutionthatsendstheadvertisingstatisticstoe-mailaddressesthatarespecifiedinatable.

D.Designastoredproceduretoreturnthestatisticsonacallfromtheadvertisersapplication.

E.Designauser-definedfunctiontoreturnthestatisticsonacallfromtheadvertisersapplication.

点击查看答案

第4题

Youneedtodesignthestorageoftheloanresponsemessage.Whichactionsoractionsshouldyouperform?（）

A.Usethexmldatatypetostorethemessage.

B.Useauser-defineddatatypetostorethemessage.

C.Usethenvarchar（max）datatypetostorethemessage.

D.Useacheckconstrainttovalidatethatthecorrecttagsareused.

E.UseanXMLschemadefinition（XSD）tovalidatethatthecorrecttagsareused.

F.Useaforeignkeyconstrainttovalidatethatthecorrecttagsareused.

点击查看答案

第5题

YourcompanyusesSQLServer2005.Youareimpleme

ntingaseriesofviewsthatareusedinadhocqueries.Theviewsareusedtoenforceyourcompanyssecuritypolicyofabstractingdata.Someoftheseviewsperformslowly.Youcreateindexesonthoseviewstoincreaseperformance,whilestillmaintainingthecompanyssecuritypolicy.Oneoftheviewsreturnsthecurrentdateasoneofthecolumns.TheviewreturnsthecurrentdatebyusingtheGETDATE()function.Thisviewdoesnotallowyoutocreateanindex.Youneedtocreateanindexontheview.

Whichtwoactionsshouldyouperform?（）

点击查看答案

第6题

YouneedtodesigntherestrictionsontheBank.Customerstable.Whichthreeactionsshouldyouperform?（）

A.Designatriggerthatverifiesthatthefirstnamesandsurnamesarenotemptystrings.

B.Designacheckconstraintthatverifiesthatthefirstnamesandsurnamesarenotemptystrings.

C.DesignacheckconstraintthatusesaCLRuser-definedfunctiontoverifythateitherthephonenumberisanullvalueortheformatofthephonenumberisvalid.

D.DesignatriggerthatusesaCLRuser-definedfunctiontoverifythateitherthephonenumberisanullvalueortheformatofthephonenumberisvalid.

E.Designacheckconstraintthatensuresthatthephonenumbercannotbechangedfromavalidformattoanullvalueortoaninvalidformat.

F.Designatriggerthatensuresthatthephonenumbercannotbechangedfromavalidformattoanullvalue.

点击查看答案

第7题

YouarecreatingaviewtojointheCustomersandOrderstablesinaSQLServer2005database.Youneedtoensu

rethattheviewcannotbeaffectedbymodificationstounderlyingtableschemas.Youwanttoaccomplishthisgoalbyusingtheleastpossibleamountofoverhead.Whatshouldyoudo?（）

A.CreateCHECKconstraintsonthetables.

B.CreateaDDLtriggertorollbackanychangestothetablesifthechangesaffectthecolumnsintheview.

C.Createtheview,specifyingtheWITHSCHEMABINDINGoption.

D.Createtheview,specifyingtheWITHCHECKoption.

点击查看答案

第8题

Youneedtodesignthedatabasepermissionsforaccessfromtheterminalstothedatabaseserver.Whichactionoractionsshouldyouperform?（）

A.CreateadatabaserolenamedBankTerminals.

B.GranttheBankTerminalsroletheExecutepermissionfortheWoodgroveBankingdatabase.

C.GrantdatabaseaccesstotheWindowsBankTerminalsgroup，andaddthegrouptotheBankTerminalsrole.

D.GranttheBankTerminalsroletheExecutepermissionfortheBankschema.

E.GranttheWindowsBankTerminalsgrouptheExecutepermissionfortheBankschema.

F.GranttheBankTerminalsroletheExecutepermissionforallstoredproceduresanduser-definedfunctionsintheBankschema.

点击查看答案

第9题

YourcompanyusesaSQLServer2005database.Customerdatafromyourtradingpartnersisimportedintothe

Customerstableeverynight.YouneedtoensurethatthecustomerrecordisupdatedifitalreadyexistsintheCustomerstable.Iftherecorddoesnotexist,thedataneedstobeinsertedintotheCustomerstable.Whatshouldyoudo?（）

A.CreateaFORtrigger.

B.CreateanINSTEADOFtrigger.

C.CreateanAFTERtrigger.

D.CreateaDDLtrigger.

点击查看答案

第10题

Youneedtoensurethatolddataandcurrentdatacanbequeriedaccordingtothebusinessrequirements.Whatshouldyoudo?（）

A.Specifyaviewbasedonthearchivaldatatableandcurrentdatatables.

B.Specifythatthedatamustbequeriedbyusingastoredprocedure.

C.Specifythatboththearchivaldatatableandthecurrentdatatablesmusthaveindexescreatedonthesamecolumns.

D.SpecifythataSQLServerAgentjobmustbeusedtocopycurrentdataintothearchivaldatatableeachnight.

点击查看答案