You noticed that large memory allocations for the Oracle bac

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

参考答案和解析
正确答案: A
解析: 暂无解析
如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第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题:

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

第3题:

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

第4题:

You are enabling the Automatic Shared Memory Management feature in the Oracle Database 10g to ensure that the important memory structures of the System Global Area (SGA) are automatically adjusted depending on the database workload. You are using Enterprise Manager 10g to enable this feature. You are currently on the Administration tab page.  Which two links should you click to go to the Memory Advisor page?()

  • A、 Advisor Central
  • B、 Global Attributes
  • C、 Resource Monitors
  • D、 Memory Parameters
  • E、 Database Usage Statistics
  • F、 All Initialization Parameters
  • G、 Automatic Workload Repository

正确答案:A,C

第5题:

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

第6题:

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

第7题:

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

第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题:

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

第10题:

You work as a database administrator for Supportcenter.cn. In a production environment, users complain about the slow response time when accessing the database. You have not optimized the memory usage of the Oracle instance and you suspect the problem to be with the memory. To which type of object would you refer to determine the cause of the slow response?()

  • A、The trace file
  • B、The fixed views
  • C、The data dictionary views
  • D、The operating system log fields
  • E、The dynamic performance views.

正确答案:E

更多相关问题