Oracle Database Administration II — Question 103

Which three are true about SGA memory management in a multitenant database? (Choose three.)

Answer options

• A. Setting DB_CACHE_SIZE for a PDB guarantees a minimum amount of Database Buffer Cache memory for that PDB.
• B. The SHARED_POOL_SIZE setting for a PDB can be up to 80% of the SHARED_POOL_SIZE setting of the root container.
• C. Setting SHARED_POOL_SIZE for a PDB guarantees a minimum amount of Shared Pool memory for that PDB.
• D. The SGA_TARGET setting for a PDB cannot exceed 50% of the SGA_TARGET value of the root container.
• E. Setting SGA_TARGET for a PDB guarantees a minimum amount of SGA memory for that PDB.
• F. SGA_MIN_SIZE cannot be set for a PDB.

Correct answer: A, C, E

Explanation

The correct answers A, C, and E indicate that setting these parameters guarantees a minimum amount of their respective memory types for the PDB. Options B and D provide limits on how much memory can be allocated but do not guarantee minimums, while F is incorrect since SGA_MIN_SIZE cannot be configured for PDBs, making it irrelevant in this context.