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 ...

Get OCA: Oracle 10g™ Administration I: Study Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial