违法和不良信息举报 联系客服
免费注册 登录

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 poolB、streams poolC、keep buffer cacheD、recycle buffer

题目

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
如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

在SQL语句执行前的解析阶段,要判断其中涉及的表名和列名是否合法,判断所依据的信息存放在()

A.PGA

B.SHARED POOL

C.DATABASE BUFFER CACHE

D.REDO LOG BUFFER CACHE

E.LARGE POOL


参考答案：B

第2题：

In your database， the RESULT_CACHE_MODE parameter has been set to MANUAL in the initialization parameter file. You issued the following command：   SQL>SELECT /*+ RESULT_CACHE */ sale_category， sum（sale_amt） FROM sales  GROUP BY sale_category；   Where would the result of this query be stored（）？  

  • A、 database buffer cache
  • B、 shared pool
  • C、 PGA
  • D、 large pool

正确答案:B

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

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

在SQL语句执行前的解析阶段，要判断其中涉及的表名和列名是否合法，判断所依据的信息存放在（）

  • A、PGA
  • B、SHARED POOL
  • C、DATABASE BUFFER CACHE
  • D、REDO LOG BUFFER CACHE
  • E、LARGE POOL

正确答案:B

第6题：

Which is the memory area that is created when a dedicated server process is started， and contains data and control information for that server process？（）

  • A、SGA
  • B、PGA
  • C、Shared Pool
  • D、Streams Pool

正确答案:B

第7题：

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

第8题：

An application accesses a small lookup table frequently. You notice that the required data blocks are getting aged out of the default buffer cache.How would you guarantee that the blocks for the table never age out?（）

A. Configure the KEEP buffer pool and alter the table with the corresponding storage clause.

B. Increase the database buffer cache size.

C. Configure the RECYCLE buffer pool and alter the table with the corresponding storage clause.

D. Configure Automata Shared Memory Management.

E. Configure Automatic Memory Management


参考答案：A

第9题：

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

第10题：

The Log Writer （LGWR） process reads information from the （）and writes it to the online logs.

  • A、large pool
  • B、shared pool
  • C、data buffer cache
  • D、redo log buffer
  • E、data dictionary cache

正确答案:D

更多相关问题
相关内容