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?
Sign in or unlock 1Z0-074 to reveal the answer and full explanation for question #77. The question stem and answer options stay visible for context.
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.
Unlock 1Z0-074 to see the answer
You've previewed enough free 1Z0-074 questions. Unlock 1Z0-074 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#SGA_TARGET#DB_CACHE_SIZE#PDB memory parameters#initialization parameters