Network Config   «Prev  Next»

Monitoring Shared Server - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. Which of the following is used to enable Database Resident Connection Pooling (DRCP)?
Please select the best answer.
  A. ALTER SYSTEM SET DISPATCHERS=(POOL=ON)
  B. ALTER SYSTEM SET SHARED_SERVER_SESSIONS = 100
  C. DBMS_CONNECTION_POOL.START_POOL()
  D. ALTER SYSTEM SET MAX_SHARED_SERVERS = 20

2. Which UNIX command will display the operating system processes associated with Shared Server dispatchers?
Please select the best answer.
  A. ps
  B. df
  C. ls

3. Which of the following are valid considerations regarding the number of Shared Server dispatchers to create?
Please select all the correct answers.
  A. The performance you want from your database
  B. The number of db_block_buffers or the equivalent DB_CACHE_SIZE setting in the parameter file
  C. The number of connections required per network protocol
  D. A limit the host operating system places on connections per process

4. Which of the following are true about using Shared Server?
Please select all the correct answers.
  A. You must increase the value of db_block_buffers to handle additional data blocks.
  B. You must increase shared_pool_size to accommodate space for user session data.
  C. Shared Server is best for databases with many concurrent, mostly idle connections.
  D. Shared Server is a better choice for all Oracle databases, and should always be defined.

5. Approximately how much shared pool memory does Oracle allocate for each Shared Server session when a large pool is also configured?
Please select the best answer.
  A. 1 KB
  B. 10 KB
  C. 100 KB
  D. 1 MB