Multiple choice

Which of the following is a false statement about the control of the SGA's use of Memory?

  1. The SGA can grow in response to a database administrator statement.

  2. The SGA can shrink in response to a database administrator statement, to an Oracle prescribed minimum.

  3. The buffer cache and the SGA pools can grow and shrink at runtime.

  4. The Dynamic SGA provides external controls for increasing and decreasing Oracle's use of physical memory.

  5. The Dynamic control provides controls for the execution of procedures in the database.
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

It does not provide such control.

Keep practicing — related questions