当前位置:1z0-043题库

问题:

[多选]

You are configuring the PROD database to use an internal tuning algorithm to monitor the performance of the workload. To achieve this configuration, you specify the following parameter settings in the SPFILE:       
SGA_TARGET = 512M       
SHARED_POOL_SIZE = 256M  
Which two statements are true when modifying the SHARED_POOL_SIZE initialization parameter in the SPFILE? ()

A .  Modifying the SHARED_POOL_SIZE initialization parameter cannot be accomplished if the SGA_TARGET initialization parameter is set to a non-zero value.
B .  Modifying the value of the SHARED_POOL_SIZE initialization parameter to zero is not allowed if the SGA_TARGET initialization parameter is set to a nonzero value.
C .  Increasing the value of the SHARED_POOL_SIZE initialization parameter does not increase the shared pool component size. It sets the lower limit for the size of this component.
D .  Decreasing the value of the SHARED_POOL_SIZE initialization parameter does not reduce the size of the shared pool component immediately. It sets the lower limit for the size of this component.
E .  Increasing the value of the SHARED_POOL_SIZE initialization parameter immediately increases the shared pool  component to the desired size by reallocating the additional memory from the auto-tuned memory components.
F .  Decreasing the value of the SHARED_POOL_SIZE initialization parameter immediately shrinks the shared pool component to the desired size while reallocating the released memory to the memory components that are not auto-tuned.

修剪时期和次数: In a SELECT statement that includes a WHERE clause, where is the GROUP BY clause placed in the SELECT statement? () Immediately after the SELECT clause。 Before the WHERE clause。 Before the FROM clause。 After the ORDER BY clause。 After the WHERE clause。 Which of the following allows multiple applications to share a single operating system resource?()  Logical Partition。 Workload Partition。 Dynamic Logical Partition。 Shared Processor Logical Partitio。 变压器空载电流小的原因是()。 变压器铁心的电阻很大。 变压器的励磁阻抗很大。 一次绕组的漏抗很大。 一次绕组匝数多,电阻很大。 简述污泥膨胀的定义及其最主要的解决方法。

You are configuring the PROD database to use an internal tuning algorithm to monitor the performance of the workload. To achieve this configuration, you specify the following parameter settings in the SPFILE:       
SGA_TARGET = 512M       
SHARED_POOL_SIZE = 256M  
Which two statements are true when modifying the SHARED_POOL_SIZE initialization parameter in the SPFILE? ()

参考答案:

  参考解析

本题暂无解析

在线 客服