📚 Practice Mode

Oracle Database Fundamentals

Learn at your own pace with hints and detailed explanations

1 / 11
Multiple Answers

When WORKAREA_SIZE_POLICY is set to AUTO, the work areas are sized to accomplish which two goals? (Choose two)

  1. To tune memory using the existing *_AREA_SIZE parameters.
  2. To allocate memory to work areas in order to optimize throughput only.
  3. To allocate memory to work areas in order to optimize response time only.
  4. To allocate memory to work areas in order to optimize both throughput and response time.
  5. To ensure that the overall size of the PGA will never exceed the value of PGA_AGGREGATE_TARGET.
Change Mode