网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
多选题
You have configured Automatic Shared Memory Management. Which four memory structures would be automatically tuned? ()
A
log buffer
B
Java pool
C
Large pool
D
Fixed SGA
E
Shared pool
F
Streams pool
G
Keep buffer cache
H
Database buffer cache
参考答案
参考解析
解析:
暂无解析
更多 “多选题You have configured Automatic Shared Memory Management. Which four memory structures would be automatically tuned? ()Alog bufferBJava poolCLarge poolDFixed SGAEShared poolFStreams poolGKeep buffer cacheHDatabase buffer cache” 相关考题
考题
A senior DBA asked you to execute the following command to improve performance:SQL ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle);You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows.What could be a reason for this recommendation?()A. The keep pool is not configured.B. Automatic Workarea Management is not configured.C. Automatic Shared Memory Management is not enabled.D. The data blocks in the SUBSCRIBE_LOG table are rarely accessed.E. All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view
考题
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?() A、 MMANB、 PMONC、 MMOND、 MMNL
考题
You configured the large pool for Oracle backup and restore operations. As a result, which component would require less memory?()A、 streams poolB、 shared poolC、 log bufferD、 keep buffer cacheE、 recycle buffer cache
考题
Which background process does Automatic Shared Memory Management use to coordinate the sizing of memory components?()A、PMONB、SMONC、MMNLD、MMANE、MMON
考题
Your database is configured in shared server mode. However, your senior DBA asks you to modifythe value of the PRIVATE_SGA limit in the profile of the users. What could be the reason for this()A、to limit the User Global Area (UGA) memory allocated to a session from the SGAB、to limit the amount of memory to be used for the dispatcher queue of a session in SGAC、to limit the amount of memory to be used for the request pool in System Global Area (SGA)D、to control the amount of memory allocated in SGA for the local variables for each shared server process
考题
SORT_AREA SIZE and HASH_AREA_SIZE parameters are ignored in some of the user sessions. What could be the reason?()A、The User Global Area (UGA) is not configured.B、The sessions were started using the login name SYS.C、The sessions are running in the Automatic Shared Memory Management mode.D、The sessions are running in the automatic Program Global Area (PGA) memory management mode.
考题
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?() A、 Advisor CentralB、 Global AttributesC、 Resource MonitorsD、 Memory ParametersE、 Database Usage StatisticsF、 All Initialization ParametersG、 Automatic Workload Repository
考题
A senior DBA asked you to execute the following command to improve performance: SQL ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle); You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows. What could be a reason for this recommendation?()A、The keep pool is not configured.B、Automatic Workarea Management is not configured.C、Automatic Shared Memory Management is not enabled.D、The data blocks in the SUBSCRIBE_LOG table are rarely accessed.E、All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view
考题
For Oracle 11g, Oracle strongly recommends that you configure your database to use which of the following memory-management features?() A、 Automatic PGA Memory ManagementB、 Automatic SGA Memory ManagementC、 Automatic Shared Memory ManagementD、 Automatic Memory ManagementE、 Manual SGA Memory ManagementF、 None of the above
考题
You have configured Automatic Shared Memory Management. Which four memory structures would be automatically tuned? ()A、 log bufferB、 Java poolC、 Large poolD、 Fixed SGAE、 Shared poolF、 Streams poolG、 Keep buffer cacheH、 Database buffer cache
考题
Which of the following Oracle features is enabled by setting a nonzero value for the MEMORY_TARGET initialization parameter?() A、 Automatic PGA Memory ManagementB、 Automatic SGA Memory ManagementC、 Automatic Shared Memory ManagementD、 Automatic Memory ManagementE、 Manual SGA Memory ManagementF、 None of the above
考题
In Oracle 11g,by default which one of the following conditions implicitly enables Automatic PGA Memory Management?() A、 Setting a nonzero value for SGA_TARGETB、 Configuring Automatic Shared Memory ManagementC、 Configuring Automatic Memory ManagementD、 Setting a nonzero value for SGA_MAX_SIZE and PGA_AGGREGATE_TARGETE、 None of the above
考题
By setting the value of MEMORY_TARGET to zero and setting the value of SGA_TARGET to a nonzero value, you will enable which of the following memory-management options?() A、 Automatic PGA Memory ManagementB、 Automatic SGA Memory ManagementC、 Automatic Shared Memory ManagementD、 Automatic Memory ManagementE、 Manual SGA Memory ManagementF、 None of the above
考题
单选题Which background process does Automatic Shared Memory Management use to coordinate the sizing of memory components?()A
PMONB
SMONC
MMNLD
MMANE
MMON
考题
单选题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.
考题
单选题In Oracle 11g,by default which one of the following conditions implicitly enables Automatic PGA Memory Management?()A
Setting a nonzero value for SGA_TARGETB
Configuring Automatic Shared Memory ManagementC
Configuring Automatic Memory ManagementD
Setting a nonzero value for SGA_MAX_SIZE and PGA_AGGREGATE_TARGETE
None of the above
考题
多选题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?()AAdvisor CentralBGlobal AttributesCResource MonitorsDMemory ParametersEDatabase Usage StatisticsFAll Initialization ParametersGAutomatic Workload Repository
考题
单选题By setting the value of MEMORY_TARGET to zero and setting the value of SGA_TARGET to a nonzero value, you will enable which of the following memory-management options?()A
Automatic PGA Memory ManagementB
Automatic SGA Memory ManagementC
Automatic Shared Memory ManagementD
Automatic Memory ManagementE
Manual SGA Memory ManagementF
None of the above
考题
单选题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?()A
MMANB
PMONC
MMOND
MMNL
考题
多选题Which two initialization parameters would you set to enable Automatic Shared Memory Management?()Aset SHARED_POOL_SIZE to zeroBset STATISTICS_LEVEL to BASICCset SGA_TARGET to a non-zero valueDset DB_CACHE_SIZE to a non-zero valueEset STATISTICS_LEVEL to TYPICAL or ALL
考题
单选题You work as a database administrator for Supportcenter.cn. Your database is configured for automatic undo management. UNDO_RETENTION is set to 3 hours. You want to flash back a table that was created last year. How far back can the flashback query go?()A
3 hoursB
6 monthsC
until last yearD
until last commitE
until the point when the undotablespacewas refreshedF
until the database is shut down and the memory erased
考题
单选题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()A
Run the SQL Access AdvisorB
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
考题
单选题You have a long-running process you want to assign to a specific UNDO segment brought online for that express purpose. You are not using automatic UNDO management. What statement can be used for this task? ()A
ALTER DATABASE B
SET TRANSACTION C
ALTER ROLLBACK SEGMENT D
ALTER TABLE
考题
单选题For Oracle 11g, Oracle strongly recommends that you configure your database to use which of the following memory-management features?()A
Automatic PGA Memory ManagementB
Automatic SGA Memory ManagementC
Automatic Shared Memory ManagementD
Automatic Memory ManagementE
Manual SGA Memory ManagementF
None of the above
考题
多选题You enabled Automatic Shared Memory Management. The initialization parameters are set as shown below: SGA_TARGET= 10GB SGA_MAX_SIZE = 14GB STREAMS_POOL_SIZE = 1GB SHARED_POOL_SIZE = 3GB Which two statements are correct in this scenario? ()AA maximum of 3 GB can be allocated to shared poolBThe value for SGA_TARGET can be increased up to a maximum of 15 GBCA total of 14 GB memory will be allocated to the automatically tuned memory components.DIncreasing the value for SGA_TARGET will automatically increase the memory allocated for STREAMS_POOL_SIZEEIncreasing the value for SGA_TARGET to 12 GB will automatically increase the memory allocated to autotuned parametersFReducing the value for SGA_TARGET to 9 GB will automatically decrease the memory allocated to shared pool from 3 GB to 2 GB
考题
单选题SORT_AREA SIZE and HASH_AREA_SIZE parameters are ignored in some of the user sessions. What could be the reason?()A
The User Global Area (UGA) is not configured.B
The sessions were started using the login name SYS.C
The sessions are running in the Automatic Shared Memory Management mode.D
The sessions are running in the automatic Program Global Area (PGA) memory management mode.
考题
单选题Which of the following Oracle features is enabled by setting a nonzero value for the MEMORY_TARGET initialization parameter?()A
Automatic PGA Memory ManagementB
Automatic SGA Memory ManagementC
Automatic Shared Memory ManagementD
Automatic Memory ManagementE
Manual SGA Memory ManagementF
None of the above
热门标签
最新试卷