The minimum memory size for the database buffer cache is set to 100 mb.
The maximum memory size that can be obtained by the database buffer cache during ASMM is set to 100mb
The minimum memory size allocated for a server process in the database buffer cache in dedicated modeis set to 100 mb.
The maximum memory size from the database buffer cache that can be released for dynamic distributionduring ASMM is set to 100 mb
第1题:
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?()
第2题:
Your database instance is started using the server parameter file (SPFILE). You executed acommand to change the value of the LOG_BUFFER initialization parameter: ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH; What would be the outcome of this command()
第3题:
Automatic Shared Memory Management is disabled for your database instance. You realize that there arecases of SQL statements performing poorly because of repeated parsing activity, resulting in degradation ofperformance. What would be your next step to improve performance()
第4题:
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? ()
第5题:
For Oracle 11g, Oracle strongly recommends that you configure your database to use which of the following memory-management features?()
第6题:
The command succeeds only if Automatic Memory Management is not enabled.
The command succeeds, but you need to restart the database for changes to take effect.
The command returns an error because the size of the redo log buffer cannot be changed dynamically.
The parameter value is changed and it comes into effect as soon as space becomes available in the System Global Area (SGA).
第7题:
LOG_BUFFER
SORT_AREA_SIZE
JAVA_POOL_SIZE
STREAMS_POOL_SIZE
DB_16K_CACHE_SZIE
DB_KEEP_CACHE_SIZE
第8题:
SQL Tuning Advisor
Undo Advisor
ADDM
Memory Advisor
第9题:
modify the HASH_AREA_SIZE initialization parameter
modify the PGA_AGGREGATE_TARGET initialization parameter
modify the WORK_AREASIZE_POLICY initialization parameter
increase the value of the SGA_TARGET initialization parameter
increase the value of the SGA_MAX_SIZE initialization parameter
increase the value of the SORT_AREA_SIZE initialization parameter
第10题:
LOG_BUFFER
DB_CACHE_SIZE
JAVA_POOL_SIZE
LARGE_POOL_SIZE
SHARED_POOL_SIZE
STREAMS_POOL_SIZE
第11题:
The minimum memory size for the database buffer cache is set to 100 mb.
The maximum memory size that can be obtained by the database buffer cache during ASMM is set to100 mb
The minimum memory size allocated for a server process in the database buffer cache in dedicatedmode is set to 100 mb.
The maximum memory size from the database buffer cache that can be released for dynamicdistribution during ASMM is set to 100 mb
第12题:
The database instance starts,and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZE
The database instance starts,and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGA
The database instance starts,but Automatic Memory Management is disabled
The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter
第13题:
Examine the following parameters for a database instance: MEMORY_MAX_TARGET=0 MEMORY_TARGET=0 SGA_TARGET=0 PGA_AGGREGATE_TARGET=500m Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)?()
第14题:
The Automatic Shared Memory Management feature is enabled for the PROD database. Currently, a lot of insert activity is taking place in the database, and the memory structures are allocated according to the database workload. As the workload reduces, you decide to perform batch jobs in the database. Which of the following initialization parameters are NOT automatically resized according to the new workload and continue to remain unchanged?()
第15题:
Automatic Shared Memory Management (ASMM) has been enabled for your database instance. The initialization parameters for the components that are managed by ASMM are not set. After observing the effectsof ASMM, you executed the following command: SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M; Which statement is true in this scenario( )
第16题:
You are working in a dedicated server environment. Your database is running in the automatic Program Global Area (PGA) memory management mode. Which two statements are correct in this scenario?()
第17题:
The minimum memory size for the database buffer cache is set to 100 mb.
The maximum memory size that can be obtained by the database buffer cache during ASMM is set to 100mb
The minimum memory size allocated for a server process in the database buffer cache in dedicated modeis set to 100 mb.
The maximum memory size from the database buffer cache that can be released for dynamic distributionduring ASMM is set to 100 mb
第18题:
The SGA_TARGET initialization parameter cannot be set to a value less than 1G
The SGA_TARGET initialization parameter cannot be set to a value greater than 1G
The Memory Advisor of the Oracle Enterprise Manager 10g cannot be used to obtain advice on the important memory components of the SGA
The values of the DB_CACHE_SIZE, SHARED_POOL_SIZE, LARGE_POOL_SIZE, and JAVA_POOL_SIZE initialization parameters cannot be set manually.
No minimum limits are imposed on the DB_CACHE_SIZE, SHARED_POOL_SIZE, LARGE_POOL_SIZE, and JAVA_POOL_SIZE initialization parameters.
The Automatic Shared Memory Management feature cannot be disabled unless you specify values for the DB_CACHE_SIZE, SHARED_POOL_SIZE, LARGE_POOL_SIZE, and JAVA_POOL_SIZE initialization parameters in the initialization parameter file.
第19题:
The databases configured to use the ASM instance are mounted
The disk groups are mounted as per the ASM_DISKGROUPS initialization parameter
ASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not started
ASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters
第20题:
Run the SQL Access Advisor.
Run the Memory Advisor for the sga.
Run the Memory Advisor for the pga.
Run the Memory Advisor for the shared pool.
Run the Memory Advisor for the buffer cache.
第21题:
LOG_BUFFER
SORT_AREA_SIZE
JAVA_POOL_SIZE
STREAMS_POOL_SIZE
DB_16K_CACHE_SZIE
DB_KEEP_CACHE_SIZE
第22题:
Run the SQL Access Advisor
Run the Memory Advisor for the sga.
Run the Memory Advisor for the pga.
Run the Memory Advisor for the shared pool.
Run the Memory Advisor for the buffer cache
第23题:
Automatic PGA Memory Management
Automatic SGA Memory Management
Automatic Shared Memory Management
Automatic Memory Management
Manual SGA Memory Management
None of the above
第24题:
modify the HASH_AREA_SIZE initialization parameter
modify the PGA_AGGREGATE_TARGET initialization parameter
modify the WORK_AREASIZE_POLICY initialization parameter
increase the value of the SGA_TARGET initialization parameter
increase the value of the SGA_MAX_SIZE initialization parameter
increase the value of the SORT_AREA_SIZE initialization parameter