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

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

相似考题

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

2.The persistent configuration settings for RMAN have default for all parameters.Identify four RMAN commands that produce a multi－section backup.()A. BACKUP TABLESPACE SYSTEM SECTION SIZE 100M;B. BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;C. BACKUP ARCHIVELOG ALL SECTION SIZE 25M;D. BACKUP TABLESPACE "TEMP" SECTION SIZE 10M;E. BACKUP TABLESPACE "UNDO" INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M;F. BACKUP SPFILE SECTION SIZE 1M;G. BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;

3.Examine the following parameters for a database instance: MEMORY_MAX_TARGET=0MEMORY_TARGET=0SGA_TARGET=0PGA_AGGREGATE_TARGET=500mWhich three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)?（）A. LOG_BUFFERB. SORT_AREA_SIZEC. JAVA_POOL_SIZED. STREAMS_POOL_SIZEE. DB_16K_CACHE_SZIEF. DB_KEEP_CACHE_SIZE

4.Note the following parameters settings in your database:What would happen?()A. It will fail because DB_8K_CACHE_SIZE parameter cannot be changed dynamicallyB. It will be successful only if the memory is available from the auto tuned componentsC. It will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGETD. It will fail because an increase in the DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE

更多“SORT_AREA SIZE and HASH_AREA_SIZE parameters are ignored in ”相关问题

  • 第1题：

    Which of the following ping parameters will set the size of the outgoing packet?（）

    • A、–c
    • B、i
    • C、R
    • D、–s

    正确答案:D

  • 第2题：

    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

  • 第3题：

    You want an ASM instance to manage the files of your database. To achieve this objective， you specify the following parameters in the parameter file of the database： INSTANCE_TYPE = RDBMS DB_NAME = PROD  LARGE_POOL_SIZE = 8MB DB_BLOCK_SIZE = 4K  LOG_ARCHIVE_DEST = +dgroupA  LOG_ARCHIVE_FORMAT = "$ORACLE_SID_%s_%t.%t"  DB_CREATE_FILE_DEST = +dgroupA  COMPATIBLE = 10.1.0.2.0  CONTROL_FILES = +dgroupA  Which parameter would be ignored while starting up the instance for the database PROD？（）

    • A、 LARGE_POOL_SIZE
    • B、 DB_CREATE_FILE_DEST
    • C、 LOG_ARCHIVE_DEST
    • D、 CONTROL_FILES
    • E、 LOG_ARCHIVE_FORMAT
    • F、 DB_BLOCK_SIZE

    正确答案:E

  • 第4题：

    单选题
    You want an ASM instance to manage the files of your database. To achieve this objective， you specify the following parameters in the parameter file of the database： INSTANCE_TYPE = RDBMS DB_NAME = PROD  LARGE_POOL_SIZE = 8MB DB_BLOCK_SIZE = 4K  LOG_ARCHIVE_DEST = +dgroupA  LOG_ARCHIVE_FORMAT = "$ORACLE_SID_%s_%t.%t"  DB_CREATE_FILE_DEST = +dgroupA  COMPATIBLE = 10.1.0.2.0  CONTROL_FILES = +dgroupA  Which parameter would be ignored while starting up the instance for the database PROD？（）
    A

     LARGE_POOL_SIZE

    B

     DB_CREATE_FILE_DEST

    C

     LOG_ARCHIVE_DEST

    D

     CONTROL_FILES

    E

     LOG_ARCHIVE_FORMAT

    F

     DB_BLOCK_SIZE


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

  • 第5题：

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


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

  • 第6题：

    单选题
    Your database is running on 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


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

  • 第7题：

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


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

  • 第8题：

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

  • 第9题：

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

  • 第10题：

    单选题
    In which situation is the UNDO_RETENTION parameter be ignored， even if it is set to a value（）
    A

    When the data file of the undo tablespace is autoextensible

    B

    When there are more than one undo tablespaces available in the database

    C

    When the undo tablespace is of a fixed size and retention guarantee is not enabled

    D

    When the undo tablespace is autoextensible and retention guarantee is not enabled


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

  • 第11题：

    单选题
    Note the following parameters settings in your database: SGA_MAX_SIZE = 1024M SGA_TARGET = 700M DB_8K_CACHE_SIZE = 124M LOG_BUFFER = 200M You issued the following command to increase the value of DB_8K_CACHE_SIZE: SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M; What would happen?（）
    A

    It will fail because DB_8K_CACHE_SIZE parameter cannot be changed dynamically

    B

    It will be successful only if the memory is available from the auto tuned components

    C

    It will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET

    D

    It will fail because an increase in the DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE


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

  • 第12题：

    多选题
    Examine the following parameters for a database instance: MEMORY_MAX_TARGET=0 MEMORY_TARGET=0 SGA_TARGET=0 PGA_AGGREGATE_TARGET=500m Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)?（）
    A

    LOG_BUFFER

    B

    SORT_AREA_SIZE

    C

    JAVA_POOL_SIZE

    D

    STREAMS_POOL_SIZE

    E

    DB_16K_CACHE_SZIE

    F

    DB_KEEP_CACHE_SIZE


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

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    多选题
    Examine the following parameters for a database instance: MEMORY_MAX_TARGET=0 MEMORY_TARGET=0 SGA_TARGET=0 PGA_AGGREGATE_TARGET=500m Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)?（）
    A

    LOG_BUFFER

    B

    SORT_AREA_SIZE

    C

    JAVA_POOL_SIZE

    D

    STREAMS_POOL_SIZE

    E

    DB_16K_CACHE_SZIE

    F

    DB_KEEP_CACHE_SIZE


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

  • 第16题：

    多选题
    To manually configure the SGA components using Oracle Enterprise Manager Memory Advisor， you can set values for which of the following initialization parameters？（）
    A

    DB_CACHE_SIZE

    B

    SHARED_POOL_SIZE

    C

    LARGE_POOL_SIZE

    D

    JAVA_POOL_SIZE

    E

    SGA_MAX_SIZE

    F

    SORT_AREA_SIZE


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

  • 第17题：

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

  • 第18题：

    多选题
    You set the value of the SGA_TARGET initialization parameter to 1G to enable Oracle to automatically resize most of the memory components according to the current workload in the database. You issue the following statement：   SQL> SELECT name， value， isdefault  2 FROM v$parameter   3 WHERE name LIKE ’%size%’；   The output of this statement displays that the DB_CACHE_SIZE， SHARED_POOL_SIZE，  LARGE_POOL_SIZE， and JAVA_POOL_SIZE initialization parameters contain a zero value.  What does this imply？（）
    A

    The SGA_TARGET initialization parameter cannot be set to a value less than 1G

    B

    The SGA_TARGET initialization parameter cannot be set to a value greater than 1G

    C

    The Memory Advisor of the Oracle Enterprise Manager 10g cannot be used to obtain advice on the important memory components of the SGA

    D

    The values of the DB_CACHE_SIZE， SHARED_POOL_SIZE， LARGE_POOL_SIZE， and JAVA_POOL_SIZE initialization parameters cannot be set manually.

    E

    No minimum limits are imposed on the DB_CACHE_SIZE， SHARED_POOL_SIZE， LARGE_POOL_SIZE， and  JAVA_POOL_SIZE initialization parameters.

    F

    The Automatic Shared Memory Management feature cannot be disabled unless you specify values for the  DB_CACHE_SIZE， SHARED_POOL_SIZE， LARGE_POOL_SIZE， and JAVA_POOL_SIZE initialization parameters in the initialization parameter file.


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

  • 第19题：

    多选题
    The persistent configuration settings for RMAN have default for all parameters.Identify four RMAN commands that produce a multi-section backup.（）
    A

    BACKUP TABLESPACE SYSTEM SECTION SIZE 100M;

    B

    BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;

    C

    BACKUP ARCHIVELOG ALL SECTION SIZE 25M;

    D

    BACKUP TABLESPACE TEMP SECTION SIZE 10M;

    E

    BACKUP TABLESPACE UNDO INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M;

    F

    BACKUP SPFILE SECTION SIZE 1M;

    G

    BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;


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

  • 第20题：

    单选题
    You want an ASM instance to manage the files of your database. To achieve this objective， you specify the following parameters in the parameter file of the database：  INSTANCE_TYPE = RDBMS DB_NAME = PROD  LARGE_POOL_SIZE = 8MB  DB_BLOCK_SIZE = 4K  LOG_ARCHIVE_DEST = +dgroupA  LOG_ARCHIVE_FORMAT = "$ORACLE_SID_%s_%t.%t"  DB_CREATE_FILE_DEST = +dgroupA  COMPATIBLE = 10.1.0.2.0  CONTROL_FILES = +dgroupA  Which parameter would be ignored while starting up the instance for the database PROD？（）
    A

    DB_BLOCK_SIZE

    B

    CONTROL_FILES

    C

    LARGE_POOL_SIZE

    D

    LOG_ARCHIVE_DEST

    E

    LOG_ARCHIVE_FORMAT

    F

    DB_CREATE_FILE_DEST


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

  • 第21题：

    单选题
    In which situation may the UNDO_RETENTION parameter be ignored， even if it is set to a value（）
    A

    when the data file of the undo tablespace is autoextensible

    B

    when there are more than one undo tablespaces available in the database

    C

    when the undo tablespace is of a fixed size and retention guarantee is not enabled

    D

    when the undo tablespace is autoextensible and retention guarantee is not enabled


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

  • 第22题：

    多选题
    Which three initialization parameters are no longer needed when FAST_START_MTTR_TARGET is defined？（）
    A

    TARGET_REDO_BLKS

    B

    FAST_START_IO_TARGET

    C

    LOG_CHECKPOINT_TIMEOUT

    D

    RECOVERY_ESTIMATED_IOS

    E

    LOG_FILE_SIZE_REDO_BLKS

    F

    LOG_CHECKPOINT_INTERVAL


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

  • 第23题：

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


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

  • 第24题：

    单选题
    Which of the following ping parameters will set the size of the outgoing packet?（）
    A

    –c

    B

    i

    C

    R

    D

    –s


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

相关内容