下列哪些论述说明了司法与执法的区别？ ()

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.

A.Specifyaviewbasedonthearchivaldatatableandcurrentdatatables.

B.Specifythatthedatamustbequeriedbyusingastoredprocedure.

C.Specifythatboththearchivaldatatableandthecurrentdatatablesmusthaveindexescreatedonthesamecolumns.

D.SpecifythataSQLServerAgentjobmustbeusedtocopycurrentdataintothearchivaldatatableeachnight.

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

A.CreateaFORtrigger.

B.CreateanINSTEADOFtrigger.

C.CreateanAFTERtrigger.

D.CreateaDDLtrigger.

A.CreateadatabaserolenamedBankTerminals.

B.GranttheBankTerminalsroletheExecutepermissionfortheWoodgroveBankingdatabase.

C.GrantdatabaseaccesstotheWindowsBankTerminalsgroup，andaddthegrouptotheBankTerminalsrole.

D.GranttheBankTerminalsroletheExecutepermissionfortheBankschema.

E.GranttheWindowsBankTerminalsgrouptheExecutepermissionfortheBankschema.

F.GranttheBankTerminalsroletheExecutepermissionforallstoredproceduresanduser-definedfunctionsintheBankschema.

rethattheviewcannotbeaffectedbymodificationstounderlyingtableschemas.Youwanttoaccomplishthisgoalbyusingtheleastpossibleamountofoverhead.Whatshouldyoudo?（）

A.CreateCHECKconstraintsonthetables.

B.CreateaDDLtriggertorollbackanychangestothetablesifthechangesaffectthecolumnsintheview.

C.Createtheview,specifyingtheWITHSCHEMABINDINGoption.

D.Createtheview,specifyingtheWITHCHECKoption.

A.Designatriggerthatverifiesthatthefirstnamesandsurnamesarenotemptystrings.

B.Designacheckconstraintthatverifiesthatthefirstnamesandsurnamesarenotemptystrings.

C.DesignacheckconstraintthatusesaCLRuser-definedfunctiontoverifythateitherthephonenumberisanullvalueortheformatofthephonenumberisvalid.

D.DesignatriggerthatusesaCLRuser-definedfunctiontoverifythateitherthephonenumberisanullvalueortheformatofthephonenumberisvalid.

E.Designacheckconstraintthatensuresthatthephonenumbercannotbechangedfromavalidformattoanullvalueortoaninvalidformat.

F.Designatriggerthatensuresthatthephonenumbercannotbechangedfromavalidformattoanullvalue.

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

Whichtwoactionsshouldyouperform?（）

A.Usethexmldatatypetostorethemessage.

B.Useauser-defineddatatypetostorethemessage.

C.Usethenvarchar（max）datatypetostorethemessage.

D.Useacheckconstrainttovalidatethatthecorrecttagsareused.

E.UseanXMLschemadefinition（XSD）tovalidatethatthecorrecttagsareused.

F.Useaforeignkeyconstrainttovalidatethatthecorrecttagsareused.

A.DesignaNotificationServicessolutionthatsendstheadvertisingstatisticstospecifiedsubscribersbye-mail.

B.DesignaSQLServerWebservicethatrunsastoredproceduretoreturnthestatisticsonacallfromtheadvertisersapplication.

C.DesignaDatabaseMailsolutionthatsendstheadvertisingstatisticstoe-mailaddressesthatarespecifiedinatable.

D.Designastoredproceduretoreturnthestatisticsonacallfromtheadvertisersapplication.

E.Designauser-definedfunctiontoreturnthestatisticsonacallfromtheadvertisersapplication.

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

A.PublishthedatainthedatabaseasanXMLWebservicebyusingtheFORXMLAUTOclause.

B.Createatabletostorethebankinginformationforeachcustomer.CreateatriggerthatfireswhendataisinsertedintothetablethatjoinswiththedatacomingfromtheWebservice.

C.CreateaTransact-SQLstoredprocedurethatusesatemporarytabletostorethebankinginformationforeachcustomer.UpdatethetablewiththevaluesfromtheWebservice.

D.HaveadeveloperinyourcompanycreateanassemblythatcallstheremoteWebservice.CreateaCLRfunctionbyusingtheassembly.CalltheCLRfunctionandcombinetheresultswithbankinginformationinthedatabase.