The database must be in the ARCHIVELOG mode.
The automatic memory tuning must be enabled.
The change tracking feature must be enabled.
The automatic memory tuning must be disabled.
第1题:
You are upgrading to the Oracle 10g Database and will use the Automatic Shared Memory Management feature of the Oracle 10g Database. Which background process serves as the SGA memory broker that coordinates the sizing of the memory components?()
第2题:
You use the Memory Advisor to tune the memory structures of your database. What is the prerequisite to use the Memory Advisor?()
第3题:
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.
第4题:
For Oracle 11g, Oracle strongly recommends that you configure your database to use which of the following memory-management features?()
第5题:
While running long running queries, you receive the Snapshot too old error. Which advisor can help you to avoid the Snapshot too old error?()
第6题:
Which statements about the MEMORY_TARGET initialization parameter are true?()
第7题:
You are maintaining the SALES database for eSoft Corporation. You have not configured ASMM on the database. You want to know what size of the SGA will provide the best performance. Which advisor would you use to determine the suitable size of the SGA?()
第8题:
A. MEMORY_TARGET can be increased up to the value of MEMORY_MAX_TARGET, if MEMORY_MAX_TARGET is set to a value greater than zero
B. MEMORY_MAX_TARGET defaults to a value of zero if MEMORY_TARGET is not set
C. MEMORY_TARGET represents the total amount of memory that can be allocated to SGA and PGA memory structures.
D. MEMORY_TARGET is static and cannot be modified without shutting down the instance
第9题:
You are enabling the Automatic Shared Memory Management feature in the Oracle Database 10g to ensure that the important memory structures of the System Global Area (SGA) are automatically adjusted depending on the database workload. You are using Enterprise Manager 10g to enable this feature. You are currently on the Administration tab page. Which two links should you click to go to the Memory Advisor page?()
第10题:
You have configured Automatic Shared Memory Management. Which four memory structures would be automatically tuned? ()