Oracle Database Fundamentals

Time: 00:00:00

Attempted

Not Attempted

Marked For Review

Attempted & Reviewed

Question 1 of 11

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

Select Your Answer:

To tune memory using the existing *_AREA_SIZE parameters.

To allocate memory to work areas in order to optimize throughput only.

To allocate memory to work areas in order to optimize response time only.

To allocate memory to work areas in order to optimize both throughput and response time.

To ensure that the overall size of the PGA will never exceed the value of PGA_AGGREGATE_TARGET.

Mark for Review

Attempted

Not Attempted

Marked for Review

Attempted & Reviewed

Current