可学答题网 > 问答 > 1Z0-042题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

You work as a dat


You work as a database administrator for Supportcenter.cn. Users complain that their query is taking a long time to complete. You suspect the database buffer cache size to be the reason, and you define an alert to be generated when the buffer cache hit metric goes below 85%. When you observe the dynamic performance views, you find that the buffer cache hit ratio is 81% but no alerts are being generated.  What could be the reason for this problem?()

  • AThe advisory memory has been turned off.
  • BThe DB_CACHE_ADVICE parameter has been set to OFF in the parameter file.
  • CThe STATISTICS_LEVEL parameter has been set to BASIC in the parameter file.
  • DThe TIMED_STATISTICS parameter has been set to FALSE in the parameter file.
  • EThe STATISTICS_LEVEL parameter has been set to TYPICAL in the parameter file.
参考答案
参考解析:
分类:1Z0-042题库
相关推荐

1、You work as a dat

You work as a database administrator for Certkiller .com. You enabled tracing while creating a&...

2、You work as a dat

You work as a database administrator for Supportcenter.cn. Because of space constraints, you decide...

3、You work as a dat

You work as a database administrator for Certkiller .com. You want to create a new optimiz...

4、You work as a dat

You work as a database administrator for Certkiller .com. You decided to manage client and&ensp...

5、You work as a dat

You work as a database administrator for Supportcenter.cn. Users in the SupportCenter PROD database&...

6、You work as a dat

You work as a database administrator for Supportcenter.cn. Users in the Supportcenter.cn PROD databa...