当前位置:1Z0-052题库

问题:

[单选]

View the Exhibit to examine the output produced by the following query at three different times sincethe database instance started and has experienced workloads of different capacities: 
SQL> SELECT substr(component, 0, 10) COMP, current_size CS,user_specified_size USFROM v$memory_dynamic_componentsWHERE current_size!=0; 
What do you infer from this()

A . The database instance is running with manual PGA management.
B . The database instance is running with manual shared memory management.
C . The database instance has the MEMORY_TARGET value set to a nonzero value.
D . All sessions are connected to the database instance in dedicated mode, and no RMAN or parallelquery operations have been performed.

You find this query being used in your Oracle 12c database: Which method a used by the optimizer to limit the rows being returned?() A filter is added to the table query dynamically using ROWNUM to limit the rows to 20 percent of the total rows。 All the rows are returned to the client or middle tier but only the first 20 percent are returned to the screen or the application.。 A view is created during execution and a filter on the view limits the rows to 20 percent of the total rows.。 A TOP-N query is created to limit the rows to 20 percent of the total row。 You enabled the flashback logging feature, but you have not specified the location of the flash recovery area. Which location would be used as the default location for the flash recovery area?()  The location used for control files.。  The location used for redo log files.。  The location set by using $ORACLE_BASE。  The location set by using $ORACLE_HOME。  The location set by using CORE_DUMP_DEST。  The location set by using BACKGROUND_DUMP_DEST。 纯比例调节用于工艺系统()调节。 液位。 压力。 流量。 粘性土的等效摩擦角是() 根据有效应力原理来计算的。 将滑动面上的法向应力折算为内摩擦角。 根据静力平衡原理来计算的。 根据抗剪强度相等原理来计算的。 人际智能具体地说是指一个人与他人良好相处、有效调节关系、协同工作、发挥人际效能的能力。()

View the Exhibit to examine the output produced by the following query at three different times sincethe database instance started and has experienced workloads of different capacities: 
SQL> SELECT substr(component, 0, 10) COMP, current_size CS,user_specified_size USFROM v$memory_dynamic_componentsWHERE current_size!=0; 
What do you infer from this()

参考答案:

  参考解析

本题暂无解析

在线 客服