多选题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？（）AThe WORK_AREASIZE_POLICY initialization parameter cann

题目
多选题
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？（）
A

The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.

B

The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.

C

Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA  memory management.

D

The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA  memory management mode.

相似考题

1.Examine the parameter setting in your database:Which statement is correct about the database?()A. Automatic memory management is disabled because PGA_AGGREGATE_TARGET and SGA_TARGET are not setB. The instance is started but the database will not be opened until PGA_AGGREGATE_TARGET and SGA_TARGET are setC. The database is opened but users cannot perform transactions until PGA_AGGREGATE_TARGET and SGA_TARGET are setD. Automatic memory management is enabled and, as per policy, 60% of the memory for System Global Area (SGA) and 40% of the memory for Program Global Area (PGA) will be distributed at startup

2.You specify a nonzero value for the MEMORY_TARGET initialization parameter, but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance.Which statement about the result is true?（）A. The database instance starts, and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZEB. The database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGAC. The database instance starts, but Automatic Memory Management is disabledD. The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter

3.You configure your database Instance to support shared server connections.Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection?()A. User session dataB. Stack spaceC. Private SQL areaD. Location of the runtime area for DML and DDL StatementsE. Location of a part of the runtime area for SELECT statements

4.You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?()A. Set MEMORY_TARGET to zeroB. Set the STATISTICS_LEVEL parameter to BASICC. Set the WORKAREA_SIZE_POLICY parameter to MANUALD. Set the PGA_AGGREGATE_TARGET parameter to nonzero value

参考答案和解析
正确答案： B,A
解析： 暂无解析
更多“多选题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？（）AThe WORK_AREASIZE_POLICY initialization parameter cann”相关问题

  • 第1题：

    You specify a nonzero value for the MEMORY_TARGET initialization parameter，but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance.  Which statement about the result is true？（）

    • A、 The database instance starts，and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZE
    • B、 The database instance starts，and Oracle automatically tunes memory and allocates 60 percent to the  SGA and 40 percent to the PGA
    • C、 The database instance starts，but Automatic Memory Management is disabled
    • D、 The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter

    正确答案:B

  • 第2题：

    You specify a nonzero value for the MEMORY_TARGET initialization parameter, but do not set thePGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance.Which statement about the result is true?（）

    • A、The database instance starts, and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZE
    • B、The database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGA
    • C、The database instance starts, but Automatic Memory Management is disabled
    • D、The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter

    正确答案:B

  • 第3题：

    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

  • 第4题：

    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

  • 第5题：

    You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?（）

    • A、Set MEMORY_TARGET to zero
    • B、Set the STATISTICS_LEVEL parameter to BASIC
    • C、Set the WORKAREA_SIZE_POLICY parameter to MANUAL
    • D、Set the PGA_AGGREGATE_TARGET parameter to nonzero value

    正确答案:D

  • 第6题：

    You have included the following parameter setting in your server parameter file：       PGA_AGGREGATE_TARGET = 800M        SORT_AREA_SIZE = 100M        HASH_AREA_SIZE = 100M        BITMAP_MERGE_AREA_SIZE = 100M        CREATE_BITMAP_AREA_SIZE = 100M   Which statement is true？（）  

    • A、 All the *_AREA_SIZE parameters are ignored.
    • B、 The Automatic PGA Memory Management feature cannot be disabled.
    • C、 The total Program Global Area （PGA） memory cannot be manually increased above 800M.
    • D、 The total memory for the PGA can automatically exceed 800M using the Automatic PGA Memory Management feature.

    正确答案:A

  • 第7题：

    单选题
    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（　）
    A

    The minimum memory size for the database buffer cache is set to 100 mb.

    B

    The maximum memory size that can be obtained by the database buffer cache during ASMM is set to 100mb

    C

    The minimum memory size allocated for a server process in the database buffer cache in dedicated modeis set to 100 mb.

    D

    The maximum memory size from the database buffer cache that can be released for dynamic distributionduring ASMM is set to 100 mb


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

  • 第8题：

    单选题
    You specify a nonzero value for the MEMORY_TARGET initialization parameter, but do not set thePGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance.Which statement about the result is true?（）
    A

    The database instance starts, and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZE

    B

    The database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGA

    C

    The database instance starts, but Automatic Memory Management is disabled

    D

    The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter


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

  • 第9题：

    多选题
    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？ （）
    A

    The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.

    B

    The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.

    C

    Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA memory management.

    D

    The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA memory management mode.


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

  • 第10题：

    多选题
    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,G
    解析： 暂无解析

  • 第11题：

    单选题
    You specify a nonzero value for the MEMORY_TARGET initialization parameter, but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance. Which statement about the result is true?（）
    A

    The database instance starts, and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZE

    B

    The database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGA

    C

    The database instance starts, but Automatic Memory Management is disabled

    D

    The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter


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

  • 第12题：

    单选题
    You recently created a database and configured the SPFILE with the following parameter settings to ensure that Oracle automatically adjusts the memory for the Program Global Area （PGA）：   SORT_AREA_SIZE = 150M   HASH_AREA_SIZE = 150M   BITMAP_MERGE_AREA_SIZE = 150M   CREATE_BITMAP_AREA_SIZE = 150M   WORKAREA_SIZE_POLICY = AUTO   You have not included the PGA_AGGREGATE_TARGET initialization parameter in the SPFILE and the System Global Area （SGA） is currently sized at 4G.   What is the total PGA memory allocated across all database server processes？（）
    A

     10M

    B

     400M

    C

     600M

    D

     800M


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

  • 第13题：

    Your database is running in the automatic Program Global Area （PGA） memory management and Shared Memory Management mode. You want to increase the memory available for the SQL work areas. What would you do？（）

    • A、modify the HASH_AREA_SIZE initialization parameter
    • B、modify the PGA_AGGREGATE_TARGET initialization parameter
    • C、modify the WORK_AREASIZE_POLICY initialization parameter
    • D、increase the value of the SGA_TARGET initialization parameter
    • E、increase the value of the SGA_MAX_SIZE initialization parameter
    • F、increase the value of the SORT_AREA_SIZE initialization parameter

    正确答案:B

  • 第14题：

    Your database is running in NOARCHIVELOG mode. You want to put the database in ARCHIVELOG mode. Which two statements regarding archive log destinations are true？（）

    • A、The destination must be global only.
    • B、A maximum of five destinations can be assigned.
    • C、A maximum of ten different destinations can be assigned.
    • D、All the destinations are determined by the server automatically.
    • E、The destination may be local or remote for a Standby Database.
    • F、The destination can be changed by setting the LOG_ARCHIVE_FORMAT initialization parameter.

    正确答案:C,E

  • 第15题：

    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.

    正确答案:D

  • 第16题：

    You recently created a database and configured the SPFILE with the following parameter settings to ensure that Oracle automatically adjusts the memory for the Program Global Area （PGA）：   SORT_AREA_SIZE = 150M   HASH_AREA_SIZE = 150M   BITMAP_MERGE_AREA_SIZE = 150M   CREATE_BITMAP_AREA_SIZE = 150M   WORKAREA_SIZE_POLICY = AUTO   You have not included the PGA_AGGREGATE_TARGET initialization parameter in the SPFILE and the System Global Area （SGA） is currently sized at 4G.   What is the total PGA memory allocated across all database server processes？（）  

    • A、 10M
    • B、 400M
    • C、 600M
    • D、 800M

    正确答案:D

  • 第17题：

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

    • A、The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.
    • B、The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.
    • C、Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA  memory management.
    • D、The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA  memory management mode.

    正确答案:B,D

  • 第18题：

    多选题
    You configure your database Instance to support shared server connections.Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection?（）
    A

    User session data

    B

    Stack space

    C

    Private SQL area

    D

    Location of the runtime area for DML and DDL Statements

    E

    Location of a part of the runtime area for SELECT statements


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

  • 第19题：

    单选题
    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（）
    A

    The command succeeds only if Automatic Memory Management is not enabled.

    B

    The command succeeds， but you need to restart the database for changes to take effect.

    C

    The command returns an error because the size of the redo log buffer cannot be changed dynamically.

    D

    The parameter value is changed and it comes into effect as soon as space becomes available in the System Global Area （SGA）.


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

  • 第20题：

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


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

  • 第21题：

    多选题
    Your database is running in NOARCHIVELOG mode. You want to put the database in ARCHIVELOG mode. Which two statements regarding archive log destinations are true？（）
    A

    The destination must be global only.

    B

    A maximum of five destinations can be assigned.

    C

    A maximum of ten different destinations can be assigned.

    D

    All the destinations are determined by the server automatically.

    E

    The destination may be local or remote for a Standby Database.

    F

    The destination can be changed by setting the LOG_ARCHIVE_FORMAT initialization parameter.


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

  • 第22题：

    单选题
    Your database is running in the automatic Program Global Area （PGA） memory management and Shared Memory Management mode. You want to increase the memory available for the SQL work areas. What would you do？（）
    A

    modify the HASH_AREA_SIZE initialization parameter

    B

    modify the PGA_AGGREGATE_TARGET initialization parameter

    C

    modify the WORK_AREASIZE_POLICY initialization parameter

    D

    increase the value of the SGA_TARGET initialization parameter

    E

    increase the value of the SGA_MAX_SIZE initialization parameter

    F

    increase the value of the SORT_AREA_SIZE initialization parameter


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

  • 第23题：

    单选题
    You want to enable automatic PGA memory management in your database. Which setting is required to achieve this？（）
    A

     Set MEMORY_TARGET to zero

    B

     Set the STATISTICS_LEVEL parameter to BASIC

    C

     Set the WORKAREA_SIZE_POLICY parameter to MANUAL

    D

     Set the PGA_AGGREGATE_TARGET parameter to nonzero value


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

  • 第24题：

    多选题
    You work as a database administrator for Certkiller .com. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this？（）
    A

    Set the UNDO_RETENTION parameter to AUTO.

    B

    Create an initial undo segment in undotablespace.

    C

    Set the UNDO_RETENTION parameter to 900 or more

    D

    Set the initialization parameter UNDO_MANAGEMENT to AUTO

    E

    Set the UNDO_MANAGEMENT parameter to the name of an undotablespace


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

相关内容