当前位置:1Z0-052题库

问题:

[单选]

Automatic Shared Memory Management is disabled for your database instance. You realize that thereare cases of SQL statements performing poorly because of repeated parsing activity, resulting indegradation of performance. 
What would be your next step to improve performance? ()

A . Run the SQL Access Advisor.
B . Run the Memory Advisor for the sga.
C . Run the Memory Advisor for the pga.
D . Run the Memory Advisor for the shared pool.
E . Run the Memory Advisor for the buffer cache.

Which three SELECT statements displays 2000 in the format “$2,000.00”?() SELECT TO CNAR(2000, ‘$#,###.##’) FROM dual;。 SELECT TO CNAR(2000, ‘$0,000.00’) FROM dual;。 SELECT TO CNAR(2000, ‘$9,999.00’) FROM dual;。 SELECT TO CNAR(2000, ‘$9,999.99’) FROM dual;。 SELECT TO CNAR(2000, ‘$2,000.00’) FROM dual;。 SELECT TO CNAR(2000, ‘$N,NNN.NN’) FROM dual。 2级关断是属于()引起的关断 生产之工艺系统。 火灾。 主电源失电。 Which two statements are true when row archival management is enabled?() The ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter.。 The ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active.。 The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.。 The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.。 The ORA_ARCHIVE_STATE column is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer considered active.。 You are managing an Oracle Database 11g ASM instance having three disks in a disk group with ASM compatibility attribute set to 11.1.0 and redundancy set to high. One of the disks in the disk group becomes unavailable because of power failure.  Which statements will be true in this scenario?()  The disk is immediately dropped from the disk group.。  The ASM tracks the extents that are modified during the outa。  The ASM migrates the extents from the unavailable disk to the remaining disks.。  The disk automatically goes offline.。 依据空气因子分类抗风树种:

Automatic Shared Memory Management is disabled for your database instance. You realize that thereare cases of SQL statements performing poorly because of repeated parsing activity, resulting indegradation of performance. 
What would be your next step to improve performance? ()

参考答案:

  参考解析

本题暂无解析

在线 客服