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

[主观题]

YouarecreatingaSQLServer2005databaseforamortgagecompany.ThedatabasewillsupportanewWeb-base

dapplicationthatwillhandleupto1,000simultaneoususers.Thisapplicationmustquicklydisplaytheresultsofcalculation-intensiveoperations,suchascalculatingmortgagepaymentsandamortizationschedules.Youneedtoensurethatthedatabaseprocessescalculationsasquicklyandefficientlyaspossible.Whatshouldyoudo？（）

A.ImplementparameterizedTransact-SQLqueriesintheapplication.

B.ImplementTransact-SQLstoredproceduresinthedatabase.

C.ImplementCLRstoredproceduresinthedatabase.

D.ImplementdistributedWebservices.

查看答案

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

您可能会需要：

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

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

更多“YouarecreatingaSQLServer2005da…”相关的问题

第1题

YouneedtoensurethatthestoredprocedurethatinsertsnewloanrequestscanaccessdataintablesthatarestoredinanotherdatabaseonthesameSQLServerinstance.Whichtwoactionsshouldyouperform?（）

A.EnsurethatthestoredprocedureandthetablesareownedbyusersthatareassociatedwiththesameSQLServerlogin.

B.Ensurethatthestoredprocedureandthetablesareownedbythesamedatabaseuser.

C.Ensurethatthestoredprocedureandthetablesusethesamedatabaseschema.

D.Configurethemultiuserdatabaseoptiononbothdatabases.

E.Configurethecross-databaseownershipchainingoptiononbothdatabases.

点击查看答案

第2题

YourcompanyusesaSQLServer2005database.Thisdatabasecontainsatriggernamedtrg_InsertOrders,wh

ichfireswhenorderdataisinsertedintotheOrderstable.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‘

点击查看答案

第3题

Youaredesigningtheloanapplicationprocessforthecustomerterminals.YouneedtodesignaTransact-S

QLstoredprocedurethatfulfillsthebusinessandtechnicalrequirements.WhichtypeofTransact-SQLstoredprocedureshouldyouuse?（）

A.onethatusesaninternalSQLServerWebserviceendpoint

B.onethatrunsaSQLServerIntegrationServices（SSIS）package

C.onethatusesServiceBroker

D.onethatrunsauser-definedfunction

点击查看答案

第4题

YouworkwithaSQLServer2005databasethatprovidesbankinginformationforcustomers.Youwantcustome

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

A.PublishthedatainthedatabaseasanXMLWebservicebyusingtheFORXMLAUTOclause.

B.Createatabletostorethebankinginformationforeachcustomer.CreateatriggerthatfireswhendataisinsertedintothetablethatjoinswiththedatacomingfromtheWebservice.

C.CreateaTransact-SQLstoredprocedurethatusesatemporarytabletostorethebankinginformationforeachcustomer.UpdatethetablewiththevaluesfromtheWebservice.

D.HaveadeveloperinyourcompanycreateanassemblythatcallstheremoteWebservice.CreateaCLRfunctionbyusingtheassembly.CalltheCLRfunctionandcombinetheresultswithbankinginformationinthedatabase.

点击查看答案

第5题

Youneedtodesigntheretrievalofadvertisingstatisticswithoutcompromisingsecurity.Whatshouldyoudo?（）

A.DesignaNotificationServicessolutionthatsendstheadvertisingstatisticstospecifiedsubscribersbye-mail.

B.DesignaSQLServerWebservicethatrunsastoredproceduretoreturnthestatisticsonacallfromtheadvertisersapplication.

C.DesignaDatabaseMailsolutionthatsendstheadvertisingstatisticstoe-mailaddressesthatarespecifiedinatable.

D.Designastoredproceduretoreturnthestatisticsonacallfromtheadvertisersapplication.

E.Designauser-definedfunctiontoreturnthestatisticsonacallfromtheadvertisersapplication.

点击查看答案

第6题

Youneedtodesignthestorageoftheloanresponsemessage.Whichactionsoractionsshouldyouperform?（）

A.Usethexmldatatypetostorethemessage.

B.Useauser-defineddatatypetostorethemessage.

C.Usethenvarchar（max）datatypetostorethemessage.

D.Useacheckconstrainttovalidatethatthecorrecttagsareused.

E.UseanXMLschemadefinition（XSD）tovalidatethatthecorrecttagsareused.

F.Useaforeignkeyconstrainttovalidatethatthecorrecttagsareused.

点击查看答案

第7题

YourcompanyusesSQLServer2005.Youareimpleme

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

Whichtwoactionsshouldyouperform?（）

点击查看答案

第8题

YouneedtodesigntherestrictionsontheBank.Customerstable.Whichthreeactionsshouldyouperform?（）

A.Designatriggerthatverifiesthatthefirstnamesandsurnamesarenotemptystrings.

B.Designacheckconstraintthatverifiesthatthefirstnamesandsurnamesarenotemptystrings.

C.DesignacheckconstraintthatusesaCLRuser-definedfunctiontoverifythateitherthephonenumberisanullvalueortheformatofthephonenumberisvalid.

D.DesignatriggerthatusesaCLRuser-definedfunctiontoverifythateitherthephonenumberisanullvalueortheformatofthephonenumberisvalid.

E.Designacheckconstraintthatensuresthatthephonenumbercannotbechangedfromavalidformattoanullvalueortoaninvalidformat.

F.Designatriggerthatensuresthatthephonenumbercannotbechangedfromavalidformattoanullvalue.

点击查看答案

第9题

YouarecreatingaviewtojointheCustomersandOrderstablesinaSQLServer2005database.Youneedtoensu

rethattheviewcannotbeaffectedbymodificationstounderlyingtableschemas.Youwanttoaccomplishthisgoalbyusingtheleastpossibleamountofoverhead.Whatshouldyoudo?（）

A.CreateCHECKconstraintsonthetables.

B.CreateaDDLtriggertorollbackanychangestothetablesifthechangesaffectthecolumnsintheview.

C.Createtheview,specifyingtheWITHSCHEMABINDINGoption.

D.Createtheview,specifyingtheWITHCHECKoption.

点击查看答案

第10题

Youneedtodesignthedatabasepermissionsforaccessfromtheterminalstothedatabaseserver.Whichactionoractionsshouldyouperform?（）

A.CreateadatabaserolenamedBankTerminals.

B.GranttheBankTerminalsroletheExecutepermissionfortheWoodgroveBankingdatabase.

C.GrantdatabaseaccesstotheWindowsBankTerminalsgroup，andaddthegrouptotheBankTerminalsrole.

D.GranttheBankTerminalsroletheExecutepermissionfortheBankschema.

E.GranttheWindowsBankTerminalsgrouptheExecutepermissionfortheBankschema.

F.GranttheBankTerminalsroletheExecutepermissionforallstoredproceduresanduser-definedfunctionsintheBankschema.

点击查看答案