CMS专题

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

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

第2题:

Using Oracle Enterprise Manager to set SGA pool values manually, for which of the following pools does Oracle EM offer advice to set the value appropriately?() 

  • 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

第3题:

Which three statements are true about persistent configuration?() (Choose three.)

A. A user cannot set privileges on the persistent lightweight jobs

B. Persistent lightweight jobs generate a large amount of metadata

C. It is possible to create fully self-contained persistent lightweight jobs

D. The use of a template is mandatory to create persistent lightweight jobs

E. Persistent lightweight jobs are useful when users need to create a large number of jobs in a short time


参考答案:A, D, E

第4题:

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

第5题:

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

第6题:

Which statement is true about a worm attack?()

  • A、Human interaction is required to facilitate the spread.
  • B、The worm executes arbitrary code and installs copies of itself in the memory of the infected computer.
  • C、Extremely large volumes of requests are sent over a network or over the Internet.
  • D、Data or commands are injected into an existing stream of data. That stream is passed between a client and server application.

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

Which three statements are true about Oracle Data Pump export and import operations?()

A. You can detach from a data pump export job and reattach later.

B. Data pump uses parallel execution server processes to implement parallel import.

C. Data pump import requires the import file to be in a directory owned by the oracle owner.

D. The master table is the last object to be exported by the data pump.

E. You can detach from a data pump import job and reattach later.


参考答案:A, B, D

第9题:

Which two statements are true about Oracle ActiveCache ?()

  • A、 it supports very large data-sets such as the result-sets from large search queries to be held in memory
  • B、 it provides a set of management tools that enables automation of configuration
  • C、 it provides enhanced visibility across the entire application infrastructure
  • D、 it significantly increases the performance of Web-based applications with no code change

正确答案:A,D

第10题:

Which three statements are true about Oracle Data Pump export and import operations?()

  • A、You can detach from a data pump export job and reattach later.
  • B、Data pump uses parallel execution server processes to implement parallel import.
  • C、Data pump import requires the import file to be in a directory owned by the oracle owner.
  • D、The master table is the last object to be exported by the data pump.
  • E、You can detach from a data pump import job and reattach later.

正确答案:A,B,D

更多相关问题