5.9. Answers to Review Questions

  1. B. Shared Server is a scalability option of Oracle. It provides a way to increase the number of supported user processes while reducing the overall memory usage. This configuration is well suited to high-volume, small-transaction-oriented systems with many users connected. Because users share processes, the number of overall idle processes is also reduced. It is not well suited for large data retrieval type applications such as decision support.

  2. D. Users can request dedicated connections in a Shared Server configuration. Index rebuilds and data-intensive activities should be performed using dedicated server. The database cannot be started when connecting via Shared Server. So the correct answer is D.

  3. A. A user ...

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