可学答题网 > 问答 > MCITP(70-447)题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

You are a professional


You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions, monitoring the database server, and design deployment. In the company, you major job is the deployment, maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. You utilize the SP:Recompile event class to run SQL Server Profiler. You find that a great amount of recompiles occurring. The possible causes of the large number of recompiles should be identified.  From the flowing four options, which one is the most possible cause of the problem?()

  • AThe sp_executesql batches are not being recovered from the procedure cache.
  • BA database administrator executed UPDATE STATISTICS statements on all tables, and the most common stored procedures reference all the tables.
  • COne new stored procedure is created by a database administrator.
  • DAd hoc batches are not being recovered from the procedure cache.
参考答案
参考解析:
分类:MCITP(70-447)题库
相关推荐

1、You are a professional

You are a professional level SQL Sever 2008 Database Administrator in an international corporation&e...

2、You are a professional

You are a professional level SQL Server 2005 database administrator in an international corporation&...

3、You are a professional

You are a professional level SQL Server 2005 database administrator in an international corporation&...

4、You are a professional

You are a professional level SQL Server 2005 database administrator in an international corporation&...

5、You are a professional

You are a professional level SQL Server 2005 database administrator in an international corporation&...

6、You are a professional

You are a professional level SQL Server 2005 database administrator in an international corporation&...