多选题Which three are true about the large pool for an Oracle database instance that supports shared serverconnections?()AAllocates memory for RMAN backup and restore operationsBAllocates memory for shared and private SQL areasCContains a cursor area for sto

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

如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

You noticed that large memory allocations for the Oracle backup and restore operations are causing a performance overhead on the shared pool. Which memory structure would you configure to avoid this performance overhead?()

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

正确答案:B

第2题:

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

第3题:

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


参考答案:A, C

第4题:

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

第5题:

The Automatic Shared Memory Management feature is enabled for the PROD database. Currently, a lot of insert activity is taking place in the database, and the memory structures are allocated according to the database workload. As the workload reduces, you decide to perform batch jobs in the database. Which of the following initialization parameters are NOT automatically resized according to the new workload and continue to remain unchanged?()

  • A、 LOG_BUFFER
  • B、 DB_CACHE_SIZE
  • C、 JAVA_POOL_SIZE
  • D、 LARGE_POOL_SIZE
  • E、 SHARED_POOL_SIZE
  • F、 STREAMS_POOL_SIZE

正确答案:A,F

第6题:

You configured the large pool for Oracle backup and restore operations. As a result, which component would require less memory?()

  • A、 streams pool
  • B、 shared pool
  • C、 log buffer
  • D、 keep buffer cache
  • E、 recycle buffer cache

正确答案:B

第7题:

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

第8题:

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

第9题:

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

第10题:

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

更多相关问题