14.7. Review Questions
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?
No effect. MAX_DUMP_FILE_SIZE affects only background process trace files.
Trace files will be limited to 1000 bytes.
Trace files will be limited to 1000 kilobytes.
Trace files will be limited to 1000 megabytes.
Trace files will be limited to 1000 blocks.
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.)
The automatically sized components will have 6.5GB allocated among ...