单项选择题
Which statement about Automatic Memory Management with Oracle 11g is true?（）
A. You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or PGA_AGGREGATE_TARGET values that are greater than zero in your parameter file.
B. Oracle can reallocate memory between the SGA and PGA automatically as needed.
C. To use Automatic Memory Management, you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.
D. You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size.
相关考题
-
多项选择题
Which three statements about performance analysis by SQL Performance Analyzer are true? （）
A. It detects changes in SQL execution plans.
B. It produces results that can be used to create the SQL plan baseline.
C. The importance of SQL statements is based on the size of the objects accessed.
D. It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.
E. It shows only the overall impact on workload and not the net SQL impact on workload. -
单项选择题
You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script: SQL>@utlu111i.sql Which statement about the execution of this script is true?（）
A. It must be executed from the Oracle Database 11g environment.
B. It must be executed only after the SYSAUX tablespace has been created.
C. It must be executed from the environment of the database that is being upgraded.
D. It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.
E. It must be executed from both the Oracle Database 11g and Oracle Database 9i environments. -
单项选择题
Examine the following command that is executed for the TRANSPORT table in the SH schema: Which statement describes the significance of this command?（）
A. It collects statistics into the pending area in the data dictionary
B. It creates a virtual hidden column in the CUSTOMERS_OBE table
C. It collects statistics with AUTO_SAMPLE_SIZE for ESTIMATE_PERCENT
D. It creates a histogram to hold skewed information about the data in the columns
