多选题Which two statements are true about Shared SQL Area and Private SQL Areas（）AShared SQL Area will be allocated in the shared pool.BShared SQL Area will be allocated when a session starts.CShared SQL Area will be allocated in the large pool always.DThe w

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

相似考题

1.The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Which statement is true while performing a tape backup in an RMAN session?()A. The tape I/O performed is asynchronousB. The tape buffer is allocated from the System Global Area (SGA)C. The tape buffer is allocated from the Program Global Area (PGA)D. Oracle I/O uses an interrupt mechanism to determine when each I/O completes

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.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 operationsB. Allocates memory for shared and private SQL areasC. Contains a cursor area for storing runtime information about cursorsD. Contains stack spaceE. Contains a hash area performing hash joins of tables

4.Which two statements are true regarding the SQL Repair Advisor?()A. The SQL Repair Advisor can be invoked to tune the performance of the regressed SQL statements.B. The SQL Repair Advisor can be invoked even when the incident is not active for a SQL statement crash.C. The SQL Repair Advisor is invoked by the Health Monitor when it encounters the problematic SQL statement.D. The DBA can invoke the SQL Repair Advisor when he or she receives an alert generated when a SQL statement crashes and an incident is created in the ADR.

更多“多选题Which two statements are true about Shared SQL Area and Private SQL Areas（）AShared SQL Area will be allocated in the shared pool.BShared SQL Area will be allocated when a session starts.CShared SQL Area will be allocated in the large pool always.DThe w”相关问题

  • 第1题：

    The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Which statement is true while performing a tape backup in an RMAN session？（）  

    • A、 The tape I/O performed is asynchronous
    • B、 The tape buffer is allocated from the System Global Area （SGA）
    • C、 The tape buffer is allocated from the Program Global Area （PGA）
    • D、 Oracle I/O uses an interrupt mechanism to determine when each I/O completes

    正确答案:C

  • 第2题：

    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

  • 第3题：

    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

  • 第4题：

    The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Which statement istrue while performing a tape backup in an RMAN session?（）

    • A、The tape I/O performed is asynchronous
    • B、The tape buffer is allocated from the System Global Area (SGA)
    • C、The tape buffer is allocated from the Program Global Area (PGA)
    • D、Oracle I/O uses an interrupt mechanism to determine when each I/O completes

    正确答案:C

  • 第5题：

    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

  • 第6题：

    Which component of the SGA stores parsed SQL statements is used for process sharing?（）

    • A、Buffer cache 
    • B、Redo log buffer 
    • C、Private SQL area 
    • D、Library cache 
    • E、Row cache 

    正确答案:C

  • 第7题：

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


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

  • 第8题：

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

  • 第9题：

    单选题
    The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Which statement istrue while performing a tape backup in an RMAN session?（）
    A

    The tape I/O performed is asynchronous

    B

    The tape buffer is allocated from the System Global Area (SGA)

    C

    The tape buffer is allocated from the Program Global Area (PGA)

    D

    Oracle I/O uses an interrupt mechanism to determine when each I/O completes


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

  • 第10题：

    单选题
    Which component of the SGA stores parsed SQL statements is used for process sharing?（）
    A

    Buffer cache 

    B

    Redo log buffer 

    C

    Private SQL area 

    D

    Library cache 

    E

    Row cache 


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

  • 第11题：

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


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

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

    Which two statements are true regarding the SQL Repair Advisor？（） 

    • A、 The SQL Repair Advisor can be invoked to tune the performance of the regressed SQL statements.
    • B、 The SQL Repair Advisor can be invoked even when the incident is not active for a SQL statement crash.
    • C、 The SQL Repair Advisor is invoked by the Health Monitor when it encounters the problematic SQL statement.
    • D、 The DBA can invoke the SQL Repair Advisor when he or she receives an alert generated when a SQL statement crashes and an incident is created in the ADR.

    正确答案:B,D

  • 第14题：

    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

    正确答案:A,B,C

  • 第15题：

    You are analyzing how Oracle processes user statements. SQL and PL/SQL parse information is stored in which of the following database memory areas? （）

    • A、Library cache 
    • B、Row cache
    • C、Dictionary cache 
    • D、Large area 
    • E、Buffer cache

    正确答案:B

  • 第16题：

    Which component does the SQL Tuning Advisor NOT analyze for the SQL statements？（）  

    • A、ADDM
    • B、AWR
    • C、Cursor Cache
    • D、SQL Tuning Sets
    • E、Flash Recovery Area

    正确答案:E

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

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

  • 第20题：

    单选题
    Which component does the SQL Tuning Advisor NOT analyze for the SQL statements？（）
    A

    ADDM

    B

    AWR

    C

    Cursor Cache

    D

    SQL Tuning Sets

    E

    Flash Recovery Area


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

  • 第21题：

    单选题
    You are analyzing how Oracle processes user statements. SQL and PL/SQL parse information is stored in which of the following database memory areas? （）
    A

    Library cache 

    B

    Row cache

    C

    Dictionary cache 

    D

    Large area 

    E

    Buffer cache


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

  • 第22题：

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


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

  • 第23题：

    多选题
    Which two statements are true regarding the SQL Repair Advisor？（）
    A

    The SQL Repair Advisor can be invoked to tune the performance of the regressed SQL statements.

    B

    The SQL Repair Advisor can be invoked even when the incident is not active for a SQL statement crash.

    C

    The SQL Repair Advisor is invoked by the Health Monitor when it encounters the problematic SQL statement.

    D

    The DBA can invoke the SQL Repair Advisor when he or she receives an alert generated when a SQL statement crashes and an incident is created in the ADR.


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

相关内容