O'Reilly logo

OCA: Oracle 10g™ Administration I: Study Guide by Matthew Weishan, Joseph C. Johnson, Bob Bryla, Chip Dawes

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required