Oracle
1Z0-074 · Question #77
The ORCL CDB has a PDB, ORCL_PDB. Examine these parameters in ORCL: Examine these parameters in ORCL_PDB: You switch to ORCL_PDB and plan to execute these commands: What will be the outcome?
The correct answer is D. Altering the DB_CACHE_SIZE results in an error because SGA_TARGET should be altered to 600M. Explanation/Reference:
Managing Pluggable Databases
Question
The ORCL CDB has a PDB, ORCL_PDB. Examine these parameters in ORCL:
Examine these parameters in ORCL_PDB:
You switch to ORCL_PDB and plan to execute these commands:
What will be the outcome?
Exhibit
Options
- ASGA_TARGET is set to 600M.
- BSGA_TARGET is set to 600M and DB_CACHE_SIZE to 200M in ORCL_PDB.
- CSGA_TARGET and SGA_MAX_SIZE are set to 600M and DB_CACHE_SIZE to 200M in ORCL_PDB.
- DAltering the DB_CACHE_SIZE results in an error because SGA_TARGET should be altered to 600M
- EAltering the DB_CACHE_SIZE results in an error because it cannot be altered in a PDB.
How the community answered
(26 responses)- B12% (3)
- C4% (1)
- D81% (21)
- E4% (1)
Explanation
Explanation/Reference:
Topics
#SGA_TARGET#DB_CACHE_SIZE#PDB memory parameters#initialization parameters
Community Discussion
No community discussion yet for this question.