Oracle Instance由哪两个部分组成？（）A、Shared pool和Server processB、Shared pool和Background processC、SGA和user processD、PGA和user processE、SGA和Background process

题目

Oracle Instance由哪两个部分组成？（）

  • A、Shared pool和Server process
  • B、Shared pool和Background process
  • C、SGA和user process
  • D、PGA和user process
  • E、SGA和Background process
相似考题

1.UsingOracleEnterpriseManagertosetSGApoolvaluesmanually,forwhichofthefollowingpoolsdoesOracleEMofferadvicetosetthevalueappropriately?()A.DB_CACHE_SIZEB.SHARED_POOL_SIZEC.LARGE_POOL_SIZED.JAVA_POOL_SIZEE.SGA_MAX_SIZEF.SORT_AREA_SIZE

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

3.Oracle Instance由哪两个部分组成?()A. Shared pool和Server processB. Shared pool和Background processC. SGA和user processD. PGA和user processE. SGA和Background process

4.WhenmanuallyconfiguringtheSGA,whichofthefollowingparameterchangesrequiresaninstancerestarttotakeeffect?()"FirstTest,FirstPass"－www.lead2pass.com97Oracle1Z0－053ExamA.DB_CACHE_SIZEB.SHARED_POOL_SIZEC.LARGE_POOL_SIZED.JAVA_POOL_SIZEE.SGA_MAX_SIZEF.SORT_AREA_SIZE

更多“Oracle Instance由哪两个部分组成？（）A、Shared pool和Server processB、Shared pool和Background processC、SGA和user processD、PGA和user processE、SGA和Background process”相关问题

  • 第1题：

    Oracle Server由哪两个部分组成?()

    A. INSTANCE和DATABASE

    B. SGA和PGA

    C. SGA和DATABASE

    D. Server process和Background process

    E. SGA和Background process


    参考答案：A

  • 第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、 MMAN
    • B、 PMON
    • C、 MMON
    • D、 MMNL

    正确答案:A

  • 第3题：

    Which Oracle background process frees SGA resources that were allocated to a user process that failed？（）

    • A、PMON
    • B、SMON
    • C、CKPT
    • D、LGWR
    • E、ARCn

    正确答案:A

  • 第4题：

    Your database is configured in shared server mode. However， your senior DBA asks you to modify the value ofthe PRIVATE_SGA limit in the profile of the users.  What could be the reason for this（）

    • A、To limit the User Global Area （UGA） memory allocated to a session from the SGA
    • B、To limit the amount of memory to be used for the dispatcher queue of a session in SGA
    • C、To limit the amount of memory to be used for the request pool in System Global Area （SGA）
    • D、To control the amount of memory allocated in SGA for the local variables for each shared server process

    正确答案:A

  • 第5题：

    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

  • 第6题：

    You find that the database performance degrades while you backup the PROD database using Recovery Manager （RMAN）. The PROD database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason. Which action would you consider to overcome the performance degradation？（）

    • A、Configure Java Pool to cache the java objects.
    • B、Configure Streams Pool to enable parallel processing.
    • C、Increase Shared Pool size to cache more PL/SQL objects.
    • D、Increase Database Buffer Cache size to increase cache hits.
    • E、Configure Large Pool to be used by RMAN and shared server.
    • F、Increase the total System Global Area （SGA） size to increase memory hits.

    正确答案:E

  • 第7题：

    Under the Oracle Shared Server architecture， client-user processes ultimately connect to a（）

    • A、service
    • B、listener
    • C、dispatcher
    • D、shared server process

    正确答案:C

  • 第8题：

    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

  • 第9题：

    单选题
    Your database is configured in shared server mode. However， your senior DBA asks you to modifythe value of the PRIVATE_SGA limit in the profile of the users.  What could be the reason for this（）
    A

    to limit the User Global Area （UGA） memory allocated to a session from the SGA

    B

    to limit the amount of memory to be used for the dispatcher queue of a session in SGA

    C

    to limit the amount of memory to be used for the request pool in System Global Area （SGA）

    D

    to control the amount of memory allocated in SGA for the local variables for each shared server process


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

  • 第10题：

    单选题
    Which Oracle background process frees SGA resources that were allocated to a user process that failed？（）
    A

    PMON

    B

    SMON

    C

    CKPT

    D

    LGWR

    E

    ARCn


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

  • 第11题：

    单选题
    Oracle Instance由哪两个部分组成？（）
    A

    Shared pool和Server process

    B

    Shared pool和Background process

    C

    SGA和user process

    D

    PGA和user process

    E

    SGA和Background process


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

  • 第12题：

    单选题
    Oracle Server由哪两个部分组成？（）
    A

    INSTANCE和DATABASE

    B

    SGA和PGA

    C

    SGA和DATABASE

    D

    Server process和Background process

    E

    SGA和Background process


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

  • 第13题：

    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

    正确答案:A,B

  • 第14题：

    在ORACLE10G中，（）参数的调整需要重启数据库才能生效。

    • A、SGA_MAX_SIZE
    • B、SGA_TARGET
    • C、SHARED_POOL_SIZE
    • D、DB_CAHCHE_SIZE

    正确答案:A

  • 第15题：

    You enabled Automatic Shared Memory Management. The initialization parameters are set as shown below：  SGA_TARGET = 10GB SGA_MAX_SIZE = 14GB  STREAMS_POOL_SIZE = 1GB  SHARED_POOL_SIZE = 3GB  Which two statements are correct in this scenario？ （）

    • A、 A total of 14 GB memory will be allocated to the automatically tuned memory components
    • B、 Reducing the value for SGA_TARGET to 9 GB will automatically decrease the memory allocated to shared pool from 3 GB to 2 GB
    • C、 The value for SGA_TARGET can be increased up to a maximum of 14 GB
    • D、 A maximum of 3 GB can be allocated to shared pool
    • E、 Increasing the value for SGA_TARGET to 12 GB will automatically increase the memory allocated to autotuned parameters
    • F、 Increasing the value for SGA_TARGET will automatically increase the memory allocated for  STREAMS_POOL_SIZE

    正确答案:C,E

  • 第16题：

    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

  • 第17题：

    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

  • 第18题：

    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

  • 第19题：

    SQL语句的编译和执行是在SGA的哪一部分中进行的（）

    • A、Database Buffer Cache
    • B、Redo Log Buffer
    • C、Shared Pool
    • D、Large Pool
    • E、Java Pool

    正确答案:A

  • 第20题：

    You work as a database administrator for Certkiller .com. You find that the database performance degrades while you backup the Certkiller database using Recovery Manager （RMAN）. The Certkiller database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason.  Which action would you consider to overcome the performance degradation？（）

    • A、Configure Java Pool to cache the java objects.
    • B、Configure Streams Pool to enable parallel processing.
    • C、Increase Shared Pool size to cache more PL/SQL objects.
    • D、Increase Database Buffer Cache size to increase cache hits.
    • E、Configure Large Pool to be used by RMAN and shared server.
    • F、Increase the total System Global Area （SGA） size to increase memory hits.

    正确答案:E

  • 第21题：

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

  • 第22题：

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

  • 第23题：

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

相关内容