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

[主观题]

YouneedtodesigntherestrictionsontheBank.Customerstable.Whichthreeactionsshouldyouperform？（）

A.Designatriggerthatverifiesthatthefirstnamesandsurnamesarenotemptystrings.

B.Designacheckconstraintthatverifiesthatthefirstnamesandsurnamesarenotemptystrings.

C.DesignacheckconstraintthatusesaCLRuser-definedfunctiontoverifythateitherthephonenumberisanullvalueortheformatofthephonenumberisvalid.

D.DesignatriggerthatusesaCLRuser-definedfunctiontoverifythateitherthephonenumberisanullvalueortheformatofthephonenumberisvalid.

E.Designacheckconstraintthatensuresthatthephonenumbercannotbechangedfromavalidformattoanullvalueortoaninvalidformat.

F.Designatriggerthatensuresthatthephonenumbercannotbechangedfromavalidformattoanullvalue.

查看答案

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

您可能会需要：

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

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

更多“Youneedtodesigntherestrictions…”相关的问题

第1题

YouarecreatingaviewtojointheCustomersandOrderstablesinaSQLServer2005database.Youneedtoensu

rethattheviewcannotbeaffectedbymodificationstounderlyingtableschemas.Youwanttoaccomplishthisgoalbyusingtheleastpossibleamountofoverhead.Whatshouldyoudo?（）

A.CreateCHECKconstraintsonthetables.

B.CreateaDDLtriggertorollbackanychangestothetablesifthechangesaffectthecolumnsintheview.

C.Createtheview,specifyingtheWITHSCHEMABINDINGoption.

D.Createtheview,specifyingtheWITHCHECKoption.

点击查看答案

第2题

Youneedtodesignthedatabasepermissionsforaccessfromtheterminalstothedatabaseserver.Whichactionoractionsshouldyouperform?（）

A.CreateadatabaserolenamedBankTerminals.

B.GranttheBankTerminalsroletheExecutepermissionfortheWoodgroveBankingdatabase.

C.GrantdatabaseaccesstotheWindowsBankTerminalsgroup，andaddthegrouptotheBankTerminalsrole.

D.GranttheBankTerminalsroletheExecutepermissionfortheBankschema.

E.GranttheWindowsBankTerminalsgrouptheExecutepermissionfortheBankschema.

F.GranttheBankTerminalsroletheExecutepermissionforallstoredproceduresanduser-definedfunctionsintheBankschema.

点击查看答案

第3题

YourcompanyusesaSQLServer2005database.Customerdatafromyourtradingpartnersisimportedintothe

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

A.CreateaFORtrigger.

B.CreateanINSTEADOFtrigger.

C.CreateanAFTERtrigger.

D.CreateaDDLtrigger.

点击查看答案

第4题

Youneedtoensurethatolddataandcurrentdatacanbequeriedaccordingtothebusinessrequirements.Whatshouldyoudo?（）

A.Specifyaviewbasedonthearchivaldatatableandcurrentdatatables.

B.Specifythatthedatamustbequeriedbyusingastoredprocedure.

C.Specifythatboththearchivaldatatableandthecurrentdatatablesmusthaveindexescreatedonthesamecolumns.

D.SpecifythataSQLServerAgentjobmustbeusedtocopycurrentdataintothearchivaldatatableeachnight.

点击查看答案

第5题

Yourcompanyusesamission-criticaldatabasenamedDB1,whichislocatedonaservernamedSQL1.Youwantt

omirrorDB1onasecondservernamedSQL2.Beforeyoucanestablishdatabasemirroring,youneedtoprepareDB1andtheserversformirroring.Whichthreeactionsshouldyouperform?（）

A.SettherecoverymodelofDB1onSQL1tobulk-loggedrecovery.

B.SettherecoverymodelofDB1onSQL1tofullrecovery.

C.BackupDB1onSQL1.RestorethebackuponSQL2;specifytheNORECOVERYoption.

D.BackupDB1onSQL1.RestorethebackuponSQL2;specifytheSTANDBYoption.

E.BackupDB1onSQL1.RestorethebackuponSQL2;specifytheRECOVERYoption.

F.Createendpointsonallparticipatingservers.

G.SettheAutoShrinkpropertyofDB1onSQL1tofalse.

点击查看答案

第6题

AfullbackupofyourdatabasenamedDB1i

screatedautomaticallyatmidnighteveryday.DifferentialbackupsofDB1occurtwiceeachdayat10:00andat16:00.Adatabasesnapshotiscreatedeverydayatnoon.AdeveloperreportsthatheaccidentallydroppedthePricelisttableinDB1at12:30.ThelastupdatetoPricelistoccurredoneweekago.YouneedtorecoverthePricelisttable.Youwanttoachievethisgoalbyusingtheminimumamountofadministrativeeffort.Youmustalsominimizetheamountofdatathatislost.Whatshouldyoudo?（）

点击查看答案

第7题

YouneedtodesigntheServiceBrokerqueuesthatwillbeusedtosubmitrequestsforlong-runningreports.Yoursolutionmustminimizecomplexityofusingthequeuesbyapplications.Whatshouldyoudo?（）

A.Specifyonequeueforeachclientapplicationthatcansubmitreportrequests.

B.Specifyonequeueforeachofthetworeport-generationservices.

C.Specifyonequeueforalllong-runningreportrequests.

D.Specifyeightqueues：Oneforeachservice，andoneforeachclientapplication.

点击查看答案

第8题

YourcompanyhastwoSQLServer2005computersnamedSQL1andSQL2.TransactionlogshippingoccursfromSQ

L1toSQL2byusingdefaultSQLServerAgentschedulesettings.YouneedtoreconfiguretransactionlogshippingtoprovideminimumlatencyonSQL2.Whatshouldyoudo?（）

A.OnSQL1,reschedulethetransactionlogbackupjobsothatitoccurseveryminute.OnSQL2,maintaindefaultschedulesettingsforboththelogshippingcopyandtherestorejobs.

B.OnSQL1,changethescheduletypeforthetransactionlogbackuptoStartautomaticallywhenSQLServerAgentstarts.OnSQL2,changethescheduletypesforboththelogshippingcopyandtherestorejobstoStartautomaticallywhenSQLServerAgentstarts.

C.OnSQL1,maintaindefaultschedulesettingsforthetransactionlogbackupjob.OnSQL2,changethescheduletypesforboththelogshippingcopyandtherestorejobstoStartautomaticallywhenSQLServerAgentstarts.

D.OnSQL1,reschedulethetransactionlogbackupjobsothatitoccurseveryminute.OnSQL2,rescheduleboththelogshippingcopyandtherestorejobssothattheyoccureveryminute.

点击查看答案

第9题

Youneedtoensurethatdatabaseschemachangesinbranchofficesresultinthepropernotifications.Whatshouldyoudo?（）

A.InstallNotificationServicesonallbranchofficeservers，andconfigureNotificationServicestousealocalnotificationsdatabase.

B.SpecifythatallSQLServerlogfilesmustbearchivedandsentbye-mailtothemainoffice.

C.ImplementDMLtriggersthatuseDatabaseMailtosendane-mailmessageabouttheDMLactivity.

D.ImplementDDLtriggersthatuseDatabaseMailtosendane-mailmessageabouttheDDLactivity.

点击查看答案

第10题

YouneedtoensurethattheCust_CalcDatacolumnisimplementedappropriately.Whatshouldyoudo?（）

A.SpecifythattheCust_CalcDatacolumnmustbeimplementedasacomputedcolumnofthetable.

B.SpecifythattheCust_CalcDatacolumnmustbeindexedusinganon-clusteredindex.

C.SpecifythattheCust_CalcDatacolumnmustbeimplementedasacolumnthatusesauser-defineddatatype.

D.SpecifythattheCust_CalcDatacolumnmustbeupdatedbyaSQLServerAgentjobthatrunsnightly.

点击查看答案