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

Question

Options

• AWith Automatic Shared Memory Management, the database instance can increase the Large
• BWith Automatic Memory Management, the database instance can increase the System Global
• CAutomatically tuned and resized System Global Area components will always revert to their initial
• DAutomatic Memory Management must be used together with locking the System Global Area into
• EWith Automatic Shared Memory Management, the database instance can increase the Program
• FOn Line Transaction Processing systems often use less Program Global Area than Decision

• A
  76% (42)
• C
  13% (7)
• D
  7% (4)
• E
  4% (2)

Explanation

In AMM the instance exchanges memory between the SGA and the instance PGA as needed (B In ASMM the instance automatically distributes this memory among the various SGA components (JUST SGA) (A is correct, E incorrect) After a restart the instance return to the SGA values before the shutdown (not the initial values) https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing- memory.html#GUID-8F54391B-D42A-4FDA-9D12-E1F81FD113EA F is also correct: For OLTP systems, the PGA memory typically makes up a small fraction of the available memory, leaving most of the remaining memory for the SGA. For DSS systems running large, memory-intensive queries, PGA memory can typically use up to 70% of the available memory. https://docs.oracle.com/database/121/TGDBA/tune_pga.htm#TGDBA472

No community discussion yet for this question.