OCP: Oracle 10g Administration II Study Guide: Exam 1Z0-043

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