多选题Using Oracle Enterprise Manager to set SGA pool values manually， for which of the following pools does Oracle EM offer advice to set the value appropriately？（）ADB_CACHE_SIZEBSHARED_POOL_SIZECLARGE_POOL_SIZEDJAVA_POOL_SIZEESGA_MAX_SIZEFSORT_AREA_SIZE

题目
多选题
Using Oracle Enterprise Manager to set SGA pool values manually， for which of the following pools does Oracle EM offer advice to set the value appropriately？（）
A

DB_CACHE_SIZE

B

SHARED_POOL_SIZE

C

LARGE_POOL_SIZE

D

JAVA_POOL_SIZE

E

SGA_MAX_SIZE

F

SORT_AREA_SIZE

相似考题

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

2.Using Oracle Enterprise Manager to set SGA pool values manually， for which of the following pools does Oracle EM offer advice to set the value appropriately？（） A、 DB_CACHE_SIZEB、 SHARED_POOL_SIZEC、 LARGE_POOL_SIZED、 JAVA_POOL_SIZEE、 SGA_MAX_SIZEF、 SORT_AREA_SIZE

3.When an UNDO segment is created manually by you, its availability status is set to which of the following automatically by Oracle?（）A、Online B、Pending online C、Offline D、Stale

4. You enabled the flashback logging feature， but you have not specified the location of the flash recovery area.  Which location would be used as the default location for the flash recovery area？（）A、the location used for control filesB、the location used for redo log filesC、the location set by using $ORACLE_BASED、the location set by using $ORACLE_HOMEE、the location set by using CORE_DUMP_DESTF、the location set by using BACKGROUND_DUMP_DEST

更多“多选题Using Oracle Enterprise Manager to set SGA pool values manually， for which of the following pools does Oracle EM offer advice to set the value appropriately？（）ADB_CACHE_SIZEBSHARED_POOL_SIZECLARGE_POOL_SIZEDJAVA_POOL_SIZEESGA_MAX_SIZEFSORT_AREA_SIZE”相关问题

  • 第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 are adding redo logs to the Oracle database. Creating a new redo log adds information to which of the following Oracle resources? （）

    • A、Shared pool 
    • B、Control file 
    • C、SGA 
    • D、PGA

    正确答案:B

  • 第3题：

    Which of the following statements is true regarding the initialization parameter DIAGNOSTIC_DEST？（）   The default value is the value of the environment variable $ORACLE_HOME； if $ORACLE_HOME isn’t set  

    • A、 then the default is set to $ORACLE_BASE  The default value is the value of the environment variable $ORACLE_BASE； if $ORACLE_BASE isn’t set，
    • B、 then it is set to $ORACLE_HOME
    • C、 DIAGNOSTIC_DEST is always equal to $ORACLE_HOME
    • D、 DIAGNOSTIC_DEST is always equal to $ORACLE_BASE

    正确答案:B

  • 第4题：

    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

    正确答案:A,B,C,D

  • 第5题：

    When manually configuring the SGA，which of the following parameter changes requires an instance restart to take effect？（）   "First Test， First Pass" - www.lead2pass.com 97 Oracle 1Z0-053 Exam

    • A、 DB_CACHE_SIZE
    • B、 SHARED_POOL_SIZE
    • C、 LARGE_POOL_SIZE
    • D、 JAVA_POOL_SIZE
    • E、 SGA_MAX_SIZE
    • F、 SORT_AREA_SIZE

    正确答案:E

  • 第6题：

    You are configuring the PROD database to use an internal tuning algorithm to monitor the performance of the workload. To achieve this configuration， you specify the following parameter settings in the SPFILE://        SGA_TARGET = 512M        SHARED_POOL_SIZE = 256M   Which two statements are true when modifying the SHARED_POOL_SIZE initialization parameter in the SPFILE？ （）

    • A、 Modifying the SHARED_POOL_SIZE initialization parameter cannot be accomplished if the SGA_TARGET initialization parameter is set to a non-zero value.
    • B、 Modifying the value of the SHARED_POOL_SIZE initialization parameter to zero is not allowed if the SGA_TARGET initialization parameter is set to a nonzero value.
    • C、 Increasing the value of the SHARED_POOL_SIZE initialization parameter does not increase the shared pool component size. It sets the lower limit for the size of this component.
    • D、 Decreasing the value of the SHARED_POOL_SIZE initialization parameter does not reduce the size of the shared pool component immediately. It sets the lower limit for the size of this component.
    • E、 Increasing the value of the SHARED_POOL_SIZE initialization parameter immediately increases the shared pool  component to the desired size by reallocating the additional memory from the auto-tuned memory components.
    • F、 Decreasing the value of the SHARED_POOL_SIZE initialization parameter immediately shrinks the shared pool component to the desired size while reallocating the released memory to the memory components that are not auto-tuned.

    正确答案:D,E

  • 第7题：

    多选题
    Which tasks can be accomplished using the Enterprise Manager Support Workbench in Oracle Database 11g？（）
    A

    Generate reports on data failure such as data file failures.

    B

    You can track the Service Request （SR） and implement repairs.

    C

    You can package and upload diagnostic data to Oracle Support.

    D

    You can manually run health checks to gather diagnostic data for a problem.


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

  • 第8题：

    单选题
    You are using Oracle Enterprise Manager to estimate the size of a table to be created. You have typed data regarding the column names， data types， sizes of the columns， and the projected number of rows in the table. Which additional information does the Oracle Enterprise Manager return？（）
    A

     space allocated in the tablespace

    B

     space required for the bitmap index on a column of the table

    C

     space remaining in the tablespace after creating the table

    D

     estimated value of the PCTFREE storage parameter


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

  • 第9题：

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

  • 第10题：

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

  • 第11题：

    多选题
    When you try to start the Database Control by using the emctl start dbconsole command the following error is displayed： TZ set to America/New_york OC4J Configuration issue.  /u01/app/oracle/product/10.1.0/db_1/oc4j/j2ee/OC4J_DBConsole_orcl.us.oracle.com not found.  Which two environment variables do you need to set appropriately to avoid such errors，and start the Database Control successfully？（）
    A

    NLS_LANG

    B

    ORACLE_SID

    C

    ORACLE_HOME

    D

    ORACLE_BASE

    E

    LD_LIBRARY_PATH


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

  • 第12题：

    单选题
    You scheduled a backup by using the Schedule Backup option in Oracle Enterprise Manager. Which statement about the script created by Oracle Enterprise Manager is true？ （）
    A

    It is a SQL script.

    B

    It is a PL/SQL file.

    C

    It is an operating system （OS） file.

    D

    It is a Recovery Manager （RMAN） script


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

  • 第13题：

    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

  • 第14题：

    You scheduled a backup by using the Schedule Backup option in Oracle Enterprise Manager. Which statement about the script created by Oracle Enterprise Manager is true？ （）

    • A、It is a SQL script.
    • B、It is a PL/SQL file.
    • C、It is an operating system （OS） file.
    • D、It is a Recovery Manager （RMAN） script

    正确答案:D

  • 第15题：

    You enabled the flashback logging feature， but you have not specified the location of the flash recovery area. Which location would be used as the default location for the flash recovery area？（）

    • A、 The location used for control files.
    • B、 The location used for redo log files.
    • C、 The location set by using $ORACLE_BASE
    • D、 The location set by using $ORACLE_HOME
    • E、 The location set by using CORE_DUMP_DEST
    • F、 The location set by using BACKGROUND_DUMP_DEST

    正确答案:C

  • 第16题：

    You are using the backup scheduler in Enterprise Manager （EM） to schedule a backup of your database. Which type of script does the backup scheduler generate？ （）

    • A、SQL script
    • B、PL/SQL script
    • C、Operating System （OS） script
    • D、Enterprise Manager （EM） script
    • E、Recovery Manager （RMAN） script

    正确答案:E

  • 第17题：

    You are using Oracle Enterprise Manager to estimate the size of a table to be created. You have typed data regarding the column names， data types， sizes of the columns， and the projected number of rows in the table. Which additional information does the Oracle Enterprise Manager return？（）

    • A、 space allocated in the tablespace
    • B、 space required for the bitmap index on a column of the table
    • C、 space remaining in the tablespace after creating the table
    • D、 estimated value of the PCTFREE storage parameter

    正确答案:A

  • 第18题：

    When you try to start the Database Control by using the emctl start dbconsole command the following error is displayed： TZ set to America/New_york OC4J Configuration issue.  /u01/app/oracle/product/10.1.0/db_1/oc4j/j2ee/OC4J_DBConsole_orcl.us.oracle.com not found.  Which two environment variables do you need to set appropriately to avoid such errors，and start the Database Control successfully？（）

    • A、NLS_LANG
    • B、ORACLE_SID
    • C、ORACLE_HOME
    • D、ORACLE_BASE
    • E、LD_LIBRARY_PATH

    正确答案:B,C

  • 第19题：

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


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

  • 第20题：

    单选题
    You enabled the flashback logging feature， but you have not specified the location of the flash recovery area. Which location would be used as the default location for the flash recovery area？（）
    A

     The location used for control files.

    B

     The location used for redo log files.

    C

     The location set by using $ORACLE_BASE

    D

     The location set by using $ORACLE_HOME

    E

     The location set by using CORE_DUMP_DEST

    F

     The location set by using BACKGROUND_DUMP_DEST


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

  • 第21题：

    多选题
    You are configuring the PROD database to use an internal tuning algorithm to monitor the performance of the workload. To achieve this configuration， you specify the following parameter settings in the SPFILE://        SGA_TARGET = 512M        SHARED_POOL_SIZE = 256M   Which two statements are true when modifying the SHARED_POOL_SIZE initialization parameter in the SPFILE？ （）
    A

    Modifying the SHARED_POOL_SIZE initialization parameter cannot be accomplished if the SGA_TARGET initialization parameter is set to a non-zero value.

    B

    Modifying the value of the SHARED_POOL_SIZE initialization parameter to zero is not allowed if the SGA_TARGET initialization parameter is set to a nonzero value.

    C

    Increasing the value of the SHARED_POOL_SIZE initialization parameter does not increase the shared pool component size. It sets the lower limit for the size of this component.

    D

    Decreasing the value of the SHARED_POOL_SIZE initialization parameter does not reduce the size of the shared pool component immediately. It sets the lower limit for the size of this component.

    E

    Increasing the value of the SHARED_POOL_SIZE initialization parameter immediately increases the shared pool  component to the desired size by reallocating the additional memory from the auto-tuned memory components.

    F

    Decreasing the value of the SHARED_POOL_SIZE initialization parameter immediately shrinks the shared pool component to the desired size while reallocating the released memory to the memory components that are not auto-tuned.


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

  • 第22题：

    单选题
    Which of the following statements is true regarding the initialization parameter DIAGNOSTIC_DEST？（）   The default value is the value of the environment variable $ORACLE_HOME； if $ORACLE_HOME isn’t set
    A

     then the default is set to $ORACLE_BASE  The default value is the value of the environment variable $ORACLE_BASE； if $ORACLE_BASE isn’t set，

    B

     then it is set to $ORACLE_HOME

    C

     DIAGNOSTIC_DEST is always equal to $ORACLE_HOME

    D

     DIAGNOSTIC_DEST is always equal to $ORACLE_BASE


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

  • 第23题：

    多选题
    You decided to increase the value for the SHARED_SERVERS parameter by using the following command：  SQL> ALTER SYSTEM SET SHARED_|SERVERS=3 SCOPE=？；  Which three values can be specified for the SCOPE clause？（）
    A

    ALL

    B

    PFILE

    C

    BOTH

    D

    NONE

    E

    SPFILE

    F

    MEMORY

    G

    INSTANCE

    H

    DATABASE


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

相关内容