• [多选题]You are the administrator of a new multiprocessor SQL Server 2000 computer. You are migrating data from other database management systems to this server. You need to load data from two data files into a new table on the server. The table is empty and has no indexes.You want to complete the data load as quickly as possible. What should you do? (Each correct answer represents part of the solution. Choose all that apply.)
  • 正确答案 :ABE
  • Apply a bulk update lock to the table.

    Use separate client connections to load the files into the table simultaneously.

    Specify the Bulk-Logged Recovery model for the database.

  • 解析:解析:Explanation:

  • [单选题]You are the administrator of a SQL Server 2000 computer. You create several jobs on the server and schedule them to run during the evening.You configure an operator on the server and configure the jobs to send an e-mail to this operator if a job fails for any reason.
  • 正确答案 :C
  • Configure SQLAgentMail to use a valid MAPI profile

  • 解析:解析:Explanation:SQLAgentMailmustbeusedwhenmailstoredproceduresareusedtosendnotificationstooperatorsbye-mailorpager.InordertouseSQLAgentMail,amailprofilemustbeconfiguredforSQLServerAgenttousetoconnecttothemailserverandthemailservermustbeextendedMAPI-compliant.IncorrectAnswers:B:SQLMailprovidesawaytoreceivee-mailmessagesgeneratedbySQLServer2000.Messagescanbetriggeredtoprovideinformationaboutthestatusofajoborawarningcausedbyanalert.SQLMailcanincludearesultsetinareplytoe-mailmessagesthatcontainqueriesandallowsSQLServertosendandreceivee-mailbyestablishingaclientconnectionwithamailserver.However,SQLMailmusthaveamailprofilecreatedinthesameuserdomainaccountorcontextthatisusedtostartaninstanceofSQLServer2000asitlooksforthedefinedmailprofileinthedomainaccountthattriggeredthee-malmessage.C:Netsendisusedtosendsmessagestootherusers,computers,ormessagingnamesacrossanetwork.TheMessengerservicemustberunningtoreceivemessages.Itisnotusedfore-mailorpagingpurposes.D:Thexp_startmailstoredprocedureisusedtostartaSQLMailclientsession.Ifthereisanexistingmailsession,xp_startmaildoesnotstartanewone.IfmailisbeingusedonthesamecomputeronwhichSQLServerisalsorunning,themailclientmustbestartedeitherbeforexp_startmailisexecuted,orbeforeSQLServerisstartedifSQLMailisconfiguredtoautomaticallystartwhenSQLServerstarts.

  • 查看原题 查看所有试题

    推荐科目: 计算机三级 计算机四级 软考中级 Linux认证 华为认证 计算机一级 软考高级 软考初级 通信工程师 计算机操作员初级
    @2019-2025 布丁学网 www.51ksbd.net 蜀ICP备20012290号-1 川公网安备 51012202001362号