当前位置:1Z0-042题库

问题:

[单选]

You find that the database performance degrades while you backup the PROD database using Recovery Manager (RMAN). The PROD database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason.
Which action would you consider to overcome the performance degradation?()

A . Configure Java Pool to cache the java objects.
B . Configure Streams Pool to enable parallel processing.
C . Increase Shared Pool size to cache more PL/SQL objects.
D . Increase Database Buffer Cache size to increase cache hits.
E . Configure Large Pool to be used by RMAN and shared server.
F . Increase the total System Global Area (SGA) size to increase memory hits.

In your Automatic Storage Management (ASM) instance, one of the nonempty disk groups,DGROUP1, is no longer required and you want this disk group to be removed. You execute the following command to achieve this objective:  DROP DISKGROUP dgroup1 EXCLUDING CONTENTS;  What would be the result of this command?()  This command would result in an error because the disk group is not empty.。 The command would drop the disk group, ignoring the EXCLUDING CONTENTS option.。 The command would result in the disk group being marked as INVALID because it cannot be dropped.。 The command would result in the contents being moved to the parent disk group and dropping of the disk group.。 The command would distribute the contents of the specified disk group among all other disk groups and then drop the specified disk group.。 Which of the following is used to gather Disk Magic information on a Windows host that will be used for determining the optimum configuration of an IBM System Storage DS8800?() iostat。 PerfMon。 DS CLI。 Tivoli Storage Productivity Center for Data。 属于非政府机构的网站是() Why would you execute the report obsolete command?()    To list all backups that were no longer available for restore operations。  To list all backups that had aged beyond the RMAN retention criteria。  To list all backup set pieces listed in control-file or recovery-catalog metadata that are not on the backup media。  To list all datafiles that are no longer part of the database and thus do not need to be backed up。  To list all archived redo logs that are no longer needed for any database recovery。 危险性较大的分部分项工程是指建筑工程在施工过程中,可能发生或导致()的分部分项工程。 作业人员群死群伤。 重大经济损失。 重大质量问题。 一般不良社会影响。 重大不良社会影响。

You find that the database performance degrades while you backup the PROD database using Recovery Manager (RMAN). The PROD database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason.
Which action would you consider to overcome the performance degradation?()

参考答案:

  参考解析

本题暂无解析

在线 客服