Oracle Database Administration II — Question 43

Which three are true about managing memory components in an Oracle database instance? (Choose three.)

Answer options

• A. With Automatic Shared Memory Management, the database instance can increase the Large Pool size by reducing the Shared Pool size.
• B. With Automatic Memory Management, the database instance can increase the System Global Area size by reducing the Program Global Area size.
• C. Automatically tuned and resized System Global Area components will always revert to their initial sizes after an instance restart.
• D. Automatic Memory Management must be used together with locking the System Global Area into physical memory.
• E. With Automatic Shared Memory Management, the database instance can increase the Program Global Area size by reducing the System Global Area size.
• F. On Line Transaction Processing systems often use less Program Global Area than Decision Support Systems.

Correct answer: A, B, F

Explanation

Answer A is correct because Automatic Shared Memory Management allows for dynamic adjustments between memory components. Answer B is also correct since Automatic Memory Management lets the database adjust the sizes of the System Global Area and Program Global Area as needed. Answer F is true as well, as OLTP systems generally require less memory for the Program Global Area compared to Decision Support Systems. However, C is incorrect because automatically tuned components do not revert to their initial sizes after a restart; D is incorrect because locking the System Global Area in physical memory is not a requirement for Automatic Memory Management; and E is incorrect as it misrepresents how memory components are managed in this context.