5.8. Review Questions

  1. All the following are reasons to configure the server using Shared Server except:

    1. Overall memory utilization is reduced.

    2. The system is predominantly used for decision support with large result sets returned.

    3. The system is predominantly used for small transactions with many users.

    4. The number of idle connections on the server is reduced.

  2. Which of the following is true about Shared Server?

    1. Dedicated connections cannot be made when Shared Server is configured.

    2. It is recommended that index rebuilds be performed when connected via Shared Server.

    3. The database can be started when connected via Shared Server.

    4. The database cannot be stopped when connected via Shared Server.

  3. The administrator wants to allow a user to connect via a dedicated connection into a database configured in Shared Server mode. Which of the following lines accomplishes this?

    1. (SERVER=DEDICATED)

    2. (CONNECT=DEDICATED)

    3. (INSTANCE=DEDICATED)

    4. (MULTITRHEADED=FALSE)

    5. None of the above

  4. In which of the following files would you find the Shared Server configuration parameters?

    1. listener.ora

    2. mts.ora

    3. init.ora

    4. tnsnames.ora

    5. sqlnet.ora

  5. Which of the following is a component of Shared Server?

    1. Shared user processes

    2. Checkpoint processes

    3. Dispatcher processes

    4. Dedicated server processes

  6. You want to put the database in Shared Server mode. Which of the following files will you modify?

    1. tnsnames.ora

    2. cman.ora

    3. names.ora

    4. init.ora

  7. What choice in the Oracle Net Manager allows for the configuration of Shared Server?

    1. Local

    2. Service Naming

    3. Listeners

    4. Profile

    5. None of the above

  8. You want two TCP/IP dispatchers and one IPC dispatcher to start when the instance is started. Which of the following lines will accomplish this?

    1. dispatchers=(protocol=tcp)(dispatchers=2)(protocol=IPC) (dispatchers=1)dispatchers=(protocol=tcp)(dispatchers=2) (protocol=IPC)(dispatchers=1)

    2. dispatchers="(protocol=tcp)(dispatchers=2)(protocol=IPC)(dispatchers=1)"

    3. dispatchers_start=(protocol=tcp)(dispatchers=2)(protocol=IPC) (dispatchers=1)

    4. dispatchers_start=(pro=tcp)(dis=2)(pro=IPC)(dis=1)

  9. What is the name of the piece of shared memory that client connections are bound to during communications via Shared Server?

    1. Program Global Area

    2. System Global Area

    3. Virtual Circuit

    4. Database Buffer Cache

    5. None of the above

  10. What is the first step that the dispatcher performs after it receives a request from the user?

    1. Pass the request to a shared server.

    2. Place the request in a request queue in the PGA.

    3. Place the request in a request queue in the SGA.

    4. Process the request.

  11. Dispatchers have all the following characteristics except:

    1. Dispatchers can be shared by many connections.

    2. More dispatchers can be added dynamically with the ALTER SYSTEM command.

    3. A dispatcher can listen for multiple protocols.

    4. Each dispatcher has its own response queue.

  12. When configured in Shared Server mode, which of the following is contained in the PGA?

    1. Cursor state

    2. Sort information

    3. User session data

    4. Stack space

    5. None of the above

  13. Which of the following is false about shared servers?

    1. Shared servers can process requests from many users.

    2. Shared servers receive their requests directly from dispatchers.

    3. Shared servers place completed requests on a dispatcher response queue.

    4. The SHARED_SERVERS parameter configures the number of shared servers to start at instance startup.

  14. Which of the following is not a step in the processing of a Shared Server request?

    1. Shared servers pass information back to the client process.

    2. Dispatchers place information in a request queue.

    3. Users pass requests to a dispatcher.

    4. The dispatcher picks up completed requests from its response queue.

    5. None of the above.

  15. When you are configuring Shared Server, which initialization parameter would you likely need to modify?

    1. DB_CACHE_SIZE

    2. DB_BLOCK_BUFFERS

    3. LARGE_POOL_SIZE

    4. BUFFER_SIZE

    5. None of the above

  16. Which of the following is false about request queues?

    1. They reside in the SGA.

    2. They are shared by all the dispatchers.

    3. Each dispatcher has its own request queue.

    4. The shared server processes remove requests from the request queue.

  17. You want to gather information about users connected via Shared Server connections. Which of the following is the view that contains this information?

    1. V$USERS

    2. V$QUEUE

    3. V$SESS_STATS

    4. V$CIRCUIT

    5. None of the above

  18. What is the process that notifies the listener after a database connection is established?

    1. SMON

    2. DBWR

    3. PMON

    4. LGWR

  19. You want to gather performance and tuning-related information for the shared server processes. You should start by querying which of the following views?

    1. V$USERS

    2. V$CIRCUIT

    3. V$SHARED_SERVER_MONITOR

    4. V$SESS_STATS

  20. Which command can you execute to get details about the number of sessions connected via Shared Server?

    1. lsnrctl sessions

    2. lsnrctl conn

    3. lsnrctl status

    4. lsnrctl services

    5. None of the above

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset