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

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

相似考题

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

2.You set the following parameters in the parameter file and restarted the database:Which two statements are true regarding these parameters after the database instance is restarted?()A. The MEMORY_MAX_TARGET parameter is automatically set to 500 MBB. The value of the MEMORY_MAX_TARGET parameter remains zero till it is changed manuallyC. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zeroD. The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively

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

4.Which two initialization parameters would you set to enable Automatic Shared Memory Management?()A. set SHARED_POOL_SIZE to zeroB. set STATISTICS_LEVEL to BASICC. set SGA_TARGET to a non-zero valueD. set DB_CACHE_SIZE to a non-zero valueE. set STATISTICS_LEVEL to TYPICAL or ALL

更多“单选题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_AGG”相关问题

  • 第1题：

    To implement Automatic Management (AMM), you set the following parameters: When you try to start the database instance with these parameter settings, you receive the following error message:SQL > startupORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information.Identify the reason the instance failed to start.（）

    A.The PGA_AGGREGATE_TARGET parameter is set to zero.

    B.The STATISTICS_LEVEL parameter is setto basic.

    C.Both the SGA_TARGETandMEMORY_TARGET paramete rsareset.

    D.The SGA_MAX_SIZEandSGA_TARGET parameter value sare note qual.


    参考答案：B

  • 第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_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 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

    正确答案:D,E

  • 第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 require the Oracle server to manage the undo segments and space among various active sessions automatically. You created an undo tablespace， UNDO_TBS1， in your database. Which two additional steps would you perform to achieve this？（）

    • A、Set the UNDO_RETENTION parameter to 900 or more.
    • B、Create an initial undo segment in the undo tablespace.
    • C、Enable the retention guarantee for the undo tablespace.
    • D、Set the UNDO_TABLESPACE parameter to UNDO_TBS1.
    • E、Set the UNDO_MANAGEMENT initialization parameter to AUTO.

    正确答案:D,E

  • 第7题：

    You configured automatic archive logging for the database. On the next startup the database runs for a while， but then hangs. After checking the alert log， you determine that all the online redo logs need archiving.  Which step was skipped when you set up automatic archive log？（）

    • A、LOG_ARCHIVE_DEST was not set in the parameter file.
    • B、LOG_ARCHIVE_START was not set in the parameter file.
    • C、alter database archivelog； was not executed in MOUNT mode.
    • D、LOG_ARCHIVE_MAX processes were not set in the parameter file.

    正确答案:B

  • 第8题：

    单选题
    You configured automatic archive logging for the database. On the next startup the database runs for a while， but then hangs. After checking the alert log， you determine that all the online redo logs need archiving.  Which step was skipped when you set up automatic archive log？（）
    A

    LOG_ARCHIVE_DEST was not set in the parameter file.

    B

    LOG_ARCHIVE_START was not set in the parameter file.

    C

    alter database archivelog； was not executed in MOUNT mode.

    D

    LOG_ARCHIVE_MAX processes were not set in the parameter file.


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

  • 第9题：

    单选题
    You have the following requirements in relation to the detection of block corruption for your database instance：   Check for logical self-consistency of data blocks when modified in memory.  Checksums are calculated before and after the block change.  Checks are performed for the lost writes to the physical standby database.   Which method would help you perform the above checks automatically？（）
    A

     Set the DB_SECUREFILE parameter to PERMITTED

    B

     Set the DB_ULTRA_SAFE parameter to DATA_ONLY

    C

     Set the DB_LOCK_CHECKSUM parameter to TYPICAL

    D

     Set the DB_LOST_WRITE_PROTECT parameter to TYPICAL


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

  • 第10题：

    单选题
    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
    解析： 暂无解析

  • 第11题：

    单选题
    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
    解析： 暂无解析

  • 第12题：

    单选题
    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
    解析： 暂无解析

  • 第13题：

    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,B,C

  • 第14题：

    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

  • 第15题：

    Which two initialization parameters would you set to enable Automatic Shared Memory Management？（）

    • A、 set SHARED_POOL_SIZE to zero
    • B、 set STATISTICS_LEVEL to BASIC
    • C、 set SGA_TARGET to a non-zero value
    • D、 set DB_CACHE_SIZE to a non-zero value
    • E、 set STATISTICS_LEVEL to TYPICAL or ALL

    正确答案:A,C

  • 第16题：

    In your running instance， some of the initialization parameters are set as shown below： SGA_MAX_SIZE = 14GB  DB_CACHE_SIZE = 1GB  SHARED_POOL_SIZE = 3GB  STATISTICS_LEVEL = BASIC  PGA_AGGREGATE_TARGET = 0  You plan to enable Automatic Shared Memory Management but you are not able to set SGA_TARGET to a nonzero value. What could be the reason？（）

    • A、The STATISTICS_LEVEL initialization parameter is set to BASIC
    • B、The PGA_AGGREGATE_TARGET initialization parameter is set to zero.
    • C、The SGA_MAX_SIZE initialization parameter is set to less than 20 GB
    • D、The DB_CACHE_SIZE initialization parameter is set to less than 5 GB
    • E、The SHARED_POOL_SIZE initialization parameter is set to a nonzero value.

    正确答案:A

  • 第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 have the following requirements in relation to the detection of block corruption for your database instance：   Check for logical self-consistency of data blocks when modified in memory.  Checksums are calculated before and after the block change.  Checks are performed for the lost writes to the physical standby database.   Which method would help you perform the above checks automatically？（）

    • A、 Set the DB_SECUREFILE parameter to PERMITTED
    • B、 Set the DB_ULTRA_SAFE parameter to DATA_ONLY
    • C、 Set the DB_LOCK_CHECKSUM parameter to TYPICAL
    • D、 Set the DB_LOST_WRITE_PROTECT parameter to TYPICAL

    正确答案:B

  • 第19题：

    单选题
    You want to enable automatic PGA memory management in your database. Which setting is required toachieve 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


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

  • 第20题：

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

  • 第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题：

    单选题
    To implement Automatic Management (AMM), you set the following parameters: When you try to start the database instance with these parameter settings, you receive the following error message: SQL > startup ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information. Identify the reason the instance failed to start.（）
    A

    The PGA_AGGREGATE_TARGET parameter is set to zero.

    B

    The STATISTICS_LEVEL parameter is setto basic.

    C

    Both the SGA_TARGETandMEMORY_TARGET paramete rsareset.

    D

    The SGA_MAX_SIZEandSGA_TARGET parameter value sare note qual.


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

  • 第23题：

    单选题
    In your running instance， some of the initialization parameters are set as shown below： SGA_MAX_SIZE = 14GB  DB_CACHE_SIZE = 1GB  SHARED_POOL_SIZE = 3GB  STATISTICS_LEVEL = BASIC  PGA_AGGREGATE_TARGET = 0  You plan to enable Automatic Shared Memory Management but you are not able to set SGA_TARGET to a nonzero value. What could be the reason？（）
    A

    The STATISTICS_LEVEL initialization parameter is set to BASIC

    B

    The PGA_AGGREGATE_TARGET initialization parameter is set to zero.

    C

    The SGA_MAX_SIZE initialization parameter is set to less than 20 GB

    D

    The DB_CACHE_SIZE initialization parameter is set to less than 5 GB

    E

    The SHARED_POOL_SIZE initialization parameter is set to a nonzero value.


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

  • 第24题：

    单选题
    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
    解析： 暂无解析

相关内容