单选题You use the Memory Advisor to tune the memory structures of your database. What is the prerequisite to use the Memory Advisor？（）AThe database must be in the ARCHIVELOG mode.BThe automatic memory tuning must be enabled.CThe change tracking feature must 

题目
单选题
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.

相似考题

1.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.

2. 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

3.Which statements about the MEMORY_TARGET initialization parameter are true？（） 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 zeroB、 MEMORY_MAX_TARGET defaults to a value of zero if MEMORY_TARGET is not setC、 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

4.Which statements about the MEMORY_TARGET initialization parameter are true?() (Choose all that apply.)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 zeroB. MEMORY_MAX_TARGET defaults to a value of zero if MEMORY_TARGET is not setC. 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

更多“You use the Memory Advisor to tune the memory structures of ”相关问题

  • 第1题：

    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.

    正确答案:D

  • 第2题：

    While running long running queries， you receive the Snapshot too old error. Which advisor can help you to avoid the Snapshot too old error？（）

    • A、 Memory Advisor
    • B、 Segment Advisor
    • C、 Undo Advisor
    • D、 SQL Tuning Advisor

    正确答案:C

  • 第3题：

    For Oracle 11g， Oracle strongly recommends that you configure your database to use which of the following memory-management features？（）  

    • A、 Automatic PGA Memory Management
    • B、 Automatic SGA Memory Management
    • C、 Automatic Shared Memory Management
    • D、 Automatic Memory Management
    • E、 Manual SGA Memory Management
    • F、 None of the above

    正确答案:D

  • 第4题：

    You create a table in your database that contains 50，000 rows approximately. The queries performed on the table are complex and performed on the table frequently. Which advisor helps you achieve the best performance of database for queries by recommending the appropriate indexes？（）  

    • A、SQL Access Advisor
    • B、 Memory Advisor
    • C、SQL Tuning Advisor
    • D、 Segment Advisor

    正确答案:A

  • 第5题：

    单选题
    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.


    正确答案： D
    解析： 暂无解析

  • 第6题：

    单选题
    View the Exhibit and examine the highlighted alert. You have received an alert with the Category specified as Snapshot Too Old. Which page would you open from the Advisor Central page to determine the system recommendations to avoid such alerts in future?（）
    A

    ADDM 

    B

    Memory Advisor 

    C

    Segment Advisor 

    D

    Undo Management 

    E

    SQL Tuning Advisor 

    F

    SQL Access Advisor


    正确答案： B
    解析： 暂无解析

  • 第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？（）
    A

     SQL Tuning Advisor

    B

     Undo Advisor

    C

     ADDM

    D

     Memory Advisor


    正确答案： C
    解析： 暂无解析

  • 第8题：

    多选题
    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 Central

    B

    Global Attributes

    C

    Resource Monitors

    D

    Memory Parameters

    E

    Database Usage Statistics

    F

    All Initialization Parameters

    G

    Automatic Workload Repository


    正确答案： C,E
    解析： 暂无解析

  • 第9题：

    单选题
    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

     MMAN

    B

     PMON

    C

     MMON

    D

     MMNL


    正确答案： C
    解析： 暂无解析

  • 第10题：

    单选题
    You create a table in your database that contains 50，000 rows approximately. The queries performed on the table are complex and performed on the table frequently. Which advisor helps you achieve the best performance of database for queries by recommending the appropriate indexes？（）
    A

    SQL Access Advisor

    B

     Memory Advisor

    C

    SQL Tuning Advisor

    D

     Segment Advisor


    正确答案： D
    解析： 暂无解析

  • 第11题：

    单选题
    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 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


    正确答案： C
    解析： 暂无解析

  • 第12题：

    单选题
    For Oracle 11g， Oracle strongly recommends that you configure your database to use which of the following memory-management features？（）
    A

     Automatic PGA Memory Management

    B

     Automatic SGA Memory Management

    C

     Automatic Shared Memory Management

    D

     Automatic Memory Management

    E

     Manual SGA Memory Management

    F

     None of the above


    正确答案： F
    解析： 暂无解析

  • 第13题：

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

    • A、 SQL Tuning Advisor
    • B、 Undo Advisor
    • C、 ADDM
    • D、 Memory Advisor

    正确答案:D

  • 第14题：

    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 Central
    • B、 Global Attributes
    • C、 Resource Monitors
    • D、 Memory Parameters
    • E、 Database Usage Statistics
    • F、 All Initialization Parameters
    • G、 Automatic Workload Repository

    正确答案:A,C

  • 第15题：

    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

    正确答案:B,C,E,H

  • 第16题：

    You work as a senior administrator at ABC.com. The ABC.com network consists of a single domain named ABC.com. All servers on the ABC.com network have Windows Server 2012 R2 installed.You are running a training exercise for junior administrators. You are currently discussing the use of Non-Uniform Memory Architecture （NUMA）.Which of the following is TRUE with regards to Non-Uniform Memory Architecture （NUMA）？（）

    • A、It is a computer architecture used in multiprocessor systems.
    • B、It is a computer architecture used in single processor systems.
    • C、It allows a processor to access local memory faster than it can access remote memory.
    • D、It allows a processor to access remote memory faster than it can access local memory.

    正确答案:A,C

  • 第17题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

  • 第18题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

  • 第19题：

    多选题
    Which statements about the MEMORY_TARGET initialization parameter are true？（）
    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


    正确答案： A,D
    解析： 暂无解析

  • 第20题：

    单选题
    While running long running queries， you receive the Snapshot too old error. Which advisor can help you to avoid the Snapshot too old error？（）
    A

     Memory Advisor

    B

     Segment Advisor

    C

     Undo Advisor

    D

     SQL Tuning Advisor


    正确答案： A
    解析： 暂无解析

  • 第21题：

    单选题
    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.


    正确答案： B
    解析： 暂无解析

  • 第22题：

    多选题
    You work as a senior administrator at ABC.com. The ABC.com network consists of a single domain named ABC.com. All servers on the ABC.com network have Windows Server 2012 R2 installed.You are running a training exercise for junior administrators. You are currently discussing the use of Non-Uniform Memory Architecture （NUMA）.Which of the following is TRUE with regards to Non-Uniform Memory Architecture （NUMA）？（）
    A

    It is a computer architecture used in multiprocessor systems.

    B

    It is a computer architecture used in single processor systems.

    C

    It allows a processor to access local memory faster than it can access remote memory.

    D

    It allows a processor to access remote memory faster than it can access local memory.


    正确答案： B,A
    解析： 暂无解析

  • 第23题：

    单选题
    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 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


    正确答案： C
    解析： 暂无解析

  • 第24题：

    多选题
    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


    正确答案： F,B
    解析： 暂无解析

相关内容