多选题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?（）AUser session dataBStack spaceCPrivate SQL areaDLocation of the runtime area

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

相似考题

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

2.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 parameterB、modify the PGA_AGGREGATE_TARGET initialization parameterC、modify the WORK_AREASIZE_POLICY initialization parameterD、increase the value of the SGA_TARGET initialization parameterE、increase the value of the SGA_MAX_SIZE initialization parameterF、increase the value of the SORT_AREA_SIZE initialization parameter

3. 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 SGAB、To limit the amount of memory to be used for the dispatcher queue of a session in SGAC、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

4. Your database instance is currently configured to support 1，500 connections. The Web applicationthat uses the database allows a large number of users to work with the database simultaneously. Someusers of the Web application do not interact with the server all the time.  You want to increase the scalability by configuring the database instance to handle more connections. Asa DBA，  which configuration would you set to support more than 1，500 connections at a time（）A、You would configure more listeners for the database.B、You would configure the database in shared server mode to use the connection pooling feature.C、You would increase the value of the PGA_AGGREGATE_TARGET initialization parameter that assigns more session memory to users.D、You would decrease the value of the PRIVATE_SGA resource limit in the profiles used by the users to accommodate more session information.

参考答案和解析
正确答案： B,D
解析： 暂无解析
更多“多选题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?（）AUser session dataBStack spaceCPrivate SQL areaDLocation of the runtime area”相关问题

  • 第1题：

    Identify the memory component from which memory may be allocated for: （） 1: Session memory for the shared server  2: Buffers for I/O slaves  3: Oracle Database Recovery Manager (RMAN) backup and restore operations 

    • A、Large Pool
    • B、Redo Log Buffer
    • C、Database Buffer Cache
    • D、Program Global Area （PGA）

    正确答案:A

  • 第2题：

    Automatic Shared Memory Management is disabled for your database instance. You realize that thereare cases of SQL statements performing poorly because of repeated parsing activity， resulting indegradation of performance.  What would be your next step to improve performance？ （）

    • A、Run the SQL Access Advisor.
    • B、Run the Memory Advisor for the sga.
    • C、Run the Memory Advisor for the pga.
    • D、Run the Memory Advisor for the shared pool.
    • E、Run the Memory Advisor for the buffer cache.

    正确答案:D

  • 第3题：

    Automatic Shared Memory Management is disabled for your database instance. You realize that there arecases of SQL statements performing poorly because of repeated parsing activity， resulting in degradation ofperformance.  What would be your next step to improve performance（）

    • A、Run the SQL Access Advisor
    • B、Run the Memory Advisor for the sga.
    • C、Run the Memory Advisor for the pga.
    • D、Run the Memory Advisor for the shared pool.
    • E、Run the Memory Advisor for the buffer cache

    正确答案:E

  • 第4题：

    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

  • 第5题：

    Your database is using shared server configuration. Which optional memory structure would you configure to store the User Global Area （UGA） information and improve the shared pool performance？（）

    • A、large pool
    • B、streams pool
    • C、keep buffer cache
    • D、recycle buffer cache

    正确答案:A

  • 第6题：

    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

  • 第7题：

    You configure a new SQL Server 2005 computer to use TCP/IP with all default settings. Your corporate policy requires that each server use a firewall. You find that you can connect to the SQL Server instance from the local computer. However, client computers cannot connect to the SQL Server instance. You need to identify the most likely cause of the connection issues. What should you do first?（）

    • A、Ensure that port 1433 is open in your firewall. 
    • B、Ensure that port 443 is open in your firewall. 
    • C、Ensure that client computers connect by using Shared Memory protocol. 
    • D、Ensure that the server is not paused.

    正确答案:A

  • 第8题：

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


    正确答案： 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题：

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

  • 第11题：

    单选题
    Your database instance is currently configured to support 1，500 connections. The Web applicationthat uses the database allows a large number of users to work with the database simultaneously. Someusers of the Web application do not interact with the server all the time.  You want to increase the scalability by configuring the database instance to handle more connections. Asa DBA，  which configuration would you set to support more than 1，500 connections at a time（）
    A

    You would configure more listeners for the database.

    B

    You would configure the database in shared server mode to use the connection pooling feature.

    C

    You would increase the value of the PGA_AGGREGATE_TARGET initialization parameter that assigns more session memory to users.

    D

    You would decrease the value of the PRIVATE_SGA resource limit in the profiles used by the users to accommodate more session information.


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

  • 第12题：

    多选题
    Which three are true about the large pool for an Oracle database instance that supports shared serverconnections?（）
    A

    Allocates memory for RMAN backup and restore operations

    B

    Allocates memory for shared and private SQL areas

    C

    Contains a cursor area for storing runtime information about cursors

    D

    Contains stack space

    E

    Contains a hash area performing hash joins of tables


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

  • 第13题：

    Automatic Shared Memory Management is disabled for your database instance. You realize that there arecases of SQL statements performing poorly because of repeated parsing activity， resulting in degradation ofperformance.  What would be your next step to improve performance（）

    • A、Run the SQL Access Advisor.
    • B、Run the Memory Advisor for the sga
    • C、Run the Memory Advisor for the pga.
    • D、Run the Memory Advisor for the shared pool.
    • E、Run the Memory Advisor for the buffer cache

    正确答案:D

  • 第14题：

    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

  • 第15题：

    For Oracle 11g， Oracle strongly recommends that you configure your database to use which of the following memory-management features？（）  

    • A、 Automatic PGA Memory Management
    • B、 Automatic SGA Memory Management
    • C、 Automatic Shared Memory Management
    • D、 Automatic Memory Management
    • E、 Manual SGA Memory Management
    • F、 None of the above

    正确答案:D

  • 第16题：

    Identify the memory component from which memory may be allocated for：（） 1. Session memory for the shared server 2. Buffers for I/O slaves 3. Oracle Database Recovery Manager （RMAN） backup and restore operations

    • A、Large Pool
    • B、Redo Log Buffer
    • C、Database Buffer Cache
    • D、Program Global Area （PGA）

    正确答案:A

  • 第17题：

    Which two statements are true about Shared SQL Area and Private SQL Area（）

    • A、Shared SQL Area will be allocated in the shared pool.
    • B、Shared SQL Area will be allocated when a session starts.
    • C、Shared SQL Area will be allocated in the large pool always.
    • D、Private SQL Area will be allocated in the Program Global Area （PGA） always.
    • E、Shared SQL Area and Private SQL Area will be allocated in the PGA or large pool.
    • F、The number of Private SQL Area allocations is dependent on the OPEN_CURSORS parameter.

    正确答案:A,F

  • 第18题：

    Which two statements are true about Shared SQL Area and Private SQL Areas（）

    • A、Shared SQL Area will be allocated in the shared pool.
    • B、Shared SQL Area will be allocated when a session starts.
    • C、Shared SQL Area will be allocated in the large pool always.
    • D、The whole of Private SQL Area will be allocated in the Program Global Area （PGA） always.
    • E、Shared SQL Area and Private SQL Area will be allocated in the PGA or large pool.
    • F、The number of Private SQL Area allocations is dependent on the OPEN_CURSORS parameter.

    正确答案:A,F

  • 第19题：

    You have a server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2). Server1hosts an ordering application that connects to a database cluster.A number of client computers are shared between employees. You need to implement a licensing solution that meets the following requirements:·Server1 must allow unlimited concurrent connections.·Client access license requirements must be minimized.Which two actions should you perform? （）(Each correct answer presents part of the solution. Choose two.)

    • A、Configure a license group for each shared computer.
    • B、Configure a local security group for each shared computer.
    • C、Configure Server1 to support Per Server licensing mode.
    • D、Configure Server1 to support either Per Device or Per User licensing mode.

    正确答案:A,D

  • 第20题：

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

  • 第21题：

    单选题
    Identify the memory component from which memory may be allocated for: （） 1: Session memory for the shared server  2: Buffers for I/O slaves  3: Oracle Database Recovery Manager (RMAN) backup and restore operations
    A

    Large Pool

    B

    Redo Log Buffer

    C

    Database Buffer Cache

    D

    Program Global Area （PGA）


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

  • 第22题：

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


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

  • 第23题：

    单选题
    For Oracle 11g， Oracle strongly recommends that you configure your database to use which of the following memory-management features？（）
    A

     Automatic PGA Memory Management

    B

     Automatic SGA Memory Management

    C

     Automatic Shared Memory Management

    D

     Automatic Memory Management

    E

     Manual SGA Memory Management

    F

     None of the above


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

相关内容