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？（）A、 A maximu

题目

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？（）

A、 A maximum of 3 GB can be allocated to shared pool
B、 The value for SGA_TARGET can be increased up to a maximum of 15 GB
C、 A total of 14 GB memory will be allocated to the automatically tuned memory components.
D、 Increasing the value for SGA_TARGET will automatically increase the memory allocated for STREAMS_POOL_SIZE
E、 Increasing the value for SGA_TARGET to 12 GB will automatically increase the memory allocated to autotuned parameters
F、 Reducing the value for SGA_TARGET to 9 GB will automatically decrease the memory allocated to shared pool from 3 GB to 2 GB

更多“You enabled Automatic”相关问题

第1题

our company has 1，000 client computers that run Windows 7 Enterprise. You need to ensure that users cannot bypass or disable Internet Explorer logging. What should you do？（）A、 Set the Turn off InPrivate Filtering state to Enabled， and set the Disable the General Page state to Enabled.B、 Set the Turn off InPrivate Browsing state to Enabled， and set the Disable the General Page state to Enabled.C、 Set the Disable the Advanced Page state to Enabled， and set the Turn off InPrivate Browsing state to Enabled.D、 Set the Disable the General Page state to Enabled， and set the Disable the Advanced Page state to Enabled.

点击查看答案
第2题

You use the Memory Advisor to tune the memory structures of your database. What is the prerequisite to use the Memory Advisor？（）A、 The database must be in the ARCHIVELOG mode.B、 The automatic memory tuning must be enabled.C、 The change tracking feature must be enabled.D、 The automatic memory tuning must be disabled.

点击查看答案
第3题

Which are the two prerequisites before setting up Flashback Data Archive? （）(Choose two.)A、Flash recovery area must be definedB、Undo retention guarantee must be enabled.C、Database must be running in archivelog mode.D、Automatic undo management must be enabled.E、The tablespace in which the Flashback Data Archive is created must have automatic segment space Management (ASSM).

点击查看答案
第4题

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

点击查看答案
第5题

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

点击查看答案
第6题

Which of the following would you use to enable automatic media recovery for a database？（）A、SET AUTORECOVERY ONB、SET RECOVERY ONC、SET AUTO OND、You cannot enable automatic media recovery.

点击查看答案
第7题

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

点击查看答案

You enabled Automatic

题目

更多“You enabled Automatic”相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容