多做题,通过考试没问题!

微软认证考试

睦霖题库>其他计算机考试>微软认证考试

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There are user-defined stored procedures. Now you have to make sure two things, first, the names of all user-defined stored procedures must contain the prefix usp_ on all instances; second, stored procedures that do not contain this prefix cannot be created by you.  So what should you do to ensure this two?()  

  • A、You should create a policy that targets the name of the stored procedure that is evaluated on change. 
  • B、You should create a policy that targets the name of the stored procedure that is evaluated on demand.
  • C、You should create a condition that targets the name of stored procedure that is evaluated on demand. 
  • D、You should create a condition that targets the name of the stored procedure that isevaluated on change. 
正确答案:A
答案解析:
进入题库查看解析

微信扫一扫手机做题