14.7. Review Questions

  1. Your database instance has the following initialization parameter set:

    MAX_DUMP_FILE_SIZE = 1000

    What effect will this setting have on user session trace files?

    1. No effect. MAX_DUMP_FILE_SIZE affects only background process trace files.

    2. Trace files will be limited to 1000 bytes.

    3. Trace files will be limited to 1000 kilobytes.

    4. Trace files will be limited to 1000 megabytes.

    5. Trace files will be limited to 1000 blocks.

  2. The following initialization parameters reside in your initialization file:

    SGA_TARGET=8G
    STREAMS_POOL_SIZE=500M
    JAVA_POOL_SIZE=1G
    SHARED_POOL_SIZE=3G

    Which of the following statements will be true when your instance is started? (Choose all that apply.)

    1. The automatically sized components will have 6.5GB allocated among ...

Get OCP: Oracle 10g Administration II Study Guide: Exam 1Z0-043 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.