14.8. Answers to Review Questions

  1. E. The default unit type for the MAX_DUMP_FILE_SIZE parameter is blocks.

  2. C, D, E. The SGA_TARGET parameter specifies total memory available for sizing the SGA. This includes both automatically sized and manually sized components. The Java pool is an automatically sized component, so its size is unknown, but it will never shrink below the size specified in the JAVA_POOL_SIZE parameter. The streams pool is a manually sized component, so it receives a static allocation of 500MB.

  3. C. ASMM is dependent on Oracle statistics and requires a STATISTICS_LEVEL of either TYPICAL or ALL. If the STATISTICS_LEVEL parameter is set to BASIC, ASMM will not function.

  4. A. Only option A is correct. Wildcards are not allowed in the

Get OCP: Oracle 10g Administration II Study Guide: Exam 1Z0-043 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