当前位置:1Z0-042题库

问题:

[单选]

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?()

A . The advisory memory has been turned off.
B . The DB_CACHE_ADVICE parameter has been set to OFF in the parameter file.
C . The STATISTICS_LEVEL parameter has been set to BASIC in the parameter file.
D . The TIMED_STATISTICS parameter has been set to FALSE in the parameter file.
E . The STATISTICS_LEVEL parameter has been set to TYPICAL in the parameter file.

A small IT department is deploying Power 720 servers exploiting virtualization technologies.  Each Power 720 will have two partitions, one with 6 cores and one with 2 cores, and both partitions having 32GB of memory each. Live Partition Mobility is being considered at some point in the future. What is the minimum AIX Edition required to support the customer?() AIX Basic Edition。 AIX Express Edition。 AIX Standard Edition。 AIX Enterprise Editio。 研究幼儿园管理的常用方法,主要有以下几种() 调查法。 文献法。 实验法。 案例法。 Manually, you set the consumer group of all of the newly created users to MYDB_GRP. You want the users to be able to change their consumer groups as per the application requirement. What was the first step that was needed in the process to achieve this objective?()  The user must have been granted the DBA role.。 The user must have been granted the switch privilege as a part of a role.。 The user must have been granted the Resource Manager administrator privilege.。 The user must have been granted the switch privilege by using the DBMS_RESOURCE_MANAGER_PRIVS package.。 对()系统每年停电不超过三次。 A customer is experiencing a performance bottleneck.  The server is performing sequential I/O requests with large block sizes of 64KB.  Improving which of the following storage subsystem characteristics has the biggest impact on this bottleneck?() Seek Time。 Drive RPM。 Data Transfer Rate。 Rotational Latency。

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?()

参考答案:

  参考解析

本题暂无解析

在线 客服