A.PublishthedatainthedatabaseasanXMLWebservicebyusingtheFORXMLAUTOclause.
B.Createatabletostorethebankinginformationforeachcustomer.CreateatriggerthatfireswhendataisinsertedintothetablethatjoinswiththedatacomingfromtheWebservice.
C.CreateaTransact-SQLstoredprocedurethatusesatemporarytabletostorethebankinginformationforeachcustomer.UpdatethetablewiththevaluesfromtheWebservice.
D.HaveadeveloperinyourcompanycreateanassemblythatcallstheremoteWebservice.CreateaCLRfunctionbyusingtheassembly.CalltheCLRfunctionandcombinetheresultswithbankinginformationinthedatabase.
第1题
A.DesignaNotificationServicessolutionthatsendstheadvertisingstatisticstospecifiedsubscribersbye-mail.
B.DesignaSQLServerWebservicethatrunsastoredproceduretoreturnthestatisticsonacallfromtheadvertisersapplication.
C.DesignaDatabaseMailsolutionthatsendstheadvertisingstatisticstoe-mailaddressesthatarespecifiedinatable.
D.Designastoredproceduretoreturnthestatisticsonacallfromtheadvertisersapplication.
E.Designauser-definedfunctiontoreturnthestatisticsonacallfromtheadvertisersapplication.
第2题
A.Usethexmldatatypetostorethemessage.
B.Useauser-defineddatatypetostorethemessage.
C.Usethenvarchar(max)datatypetostorethemessage.
D.Useacheckconstrainttovalidatethatthecorrecttagsareused.
E.UseanXMLschemadefinition(XSD)tovalidatethatthecorrecttagsareused.
F.Useaforeignkeyconstrainttovalidatethatthecorrecttagsareused.
第3题
ntingaseriesofviewsthatareusedinadhocqueries.Theviewsareusedtoenforceyourcompanyssecuritypolicyofabstractingdata.Someoftheseviewsperformslowly.Youcreateindexesonthoseviewstoincreaseperformance,whilestillmaintainingthecompanyssecuritypolicy.Oneoftheviewsreturnsthecurrentdateasoneofthecolumns.TheviewreturnsthecurrentdatebyusingtheGETDATE()function.Thisviewdoesnotallowyoutocreateanindex.Youneedtocreateanindexontheview.
Whichtwoactionsshouldyouperform?()
第4题
A.Designatriggerthatverifiesthatthefirstnamesandsurnamesarenotemptystrings.
B.Designacheckconstraintthatverifiesthatthefirstnamesandsurnamesarenotemptystrings.
C.DesignacheckconstraintthatusesaCLRuser-definedfunctiontoverifythateitherthephonenumberisanullvalueortheformatofthephonenumberisvalid.
D.DesignatriggerthatusesaCLRuser-definedfunctiontoverifythateitherthephonenumberisanullvalueortheformatofthephonenumberisvalid.
E.Designacheckconstraintthatensuresthatthephonenumbercannotbechangedfromavalidformattoanullvalueortoaninvalidformat.
F.Designatriggerthatensuresthatthephonenumbercannotbechangedfromavalidformattoanullvalue.
第5题
rethattheviewcannotbeaffectedbymodificationstounderlyingtableschemas.Youwanttoaccomplishthisgoalbyusingtheleastpossibleamountofoverhead.Whatshouldyoudo?()
A.CreateCHECKconstraintsonthetables.
B.CreateaDDLtriggertorollbackanychangestothetablesifthechangesaffectthecolumnsintheview.
C.Createtheview,specifyingtheWITHSCHEMABINDINGoption.
D.Createtheview,specifyingtheWITHCHECKoption.
第6题
A.CreateadatabaserolenamedBankTerminals.
B.GranttheBankTerminalsroletheExecutepermissionfortheWoodgroveBankingdatabase.
C.GrantdatabaseaccesstotheWindowsBankTerminalsgroup,andaddthegrouptotheBankTerminalsrole.
D.GranttheBankTerminalsroletheExecutepermissionfortheBankschema.
E.GranttheWindowsBankTerminalsgrouptheExecutepermissionfortheBankschema.
F.GranttheBankTerminalsroletheExecutepermissionforallstoredproceduresanduser-definedfunctionsintheBankschema.
第7题
Customerstableeverynight.YouneedtoensurethatthecustomerrecordisupdatedifitalreadyexistsintheCustomerstable.Iftherecorddoesnotexist,thedataneedstobeinsertedintotheCustomerstable.Whatshouldyoudo?()
A.CreateaFORtrigger.
B.CreateanINSTEADOFtrigger.
C.CreateanAFTERtrigger.
D.CreateaDDLtrigger.
第8题
A.Specifyaviewbasedonthearchivaldatatableandcurrentdatatables.
B.Specifythatthedatamustbequeriedbyusingastoredprocedure.
C.Specifythatboththearchivaldatatableandthecurrentdatatablesmusthaveindexescreatedonthesamecolumns.
D.SpecifythataSQLServerAgentjobmustbeusedtocopycurrentdataintothearchivaldatatableeachnight.
第9题
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.
第10题
screatedautomaticallyatmidnighteveryday.DifferentialbackupsofDB1occurtwiceeachdayat10:00andat16:00.Adatabasesnapshotiscreatedeverydayatnoon.AdeveloperreportsthatheaccidentallydroppedthePricelisttableinDB1at12:30.ThelastupdatetoPricelistoccurredoneweekago.YouneedtorecoverthePricelisttable.Youwanttoachievethisgoalbyusingtheminimumamountofadministrativeeffort.Youmustalsominimizetheamountofdatathatislost.Whatshouldyoudo?()
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!