nerdexam
Oracle

1Z0-074 · Question #77

1Z0-074 Question #77: Real Exam Question with Answer & Explanation

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.

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?

Exhibits

1Z0-074 question #77 exhibit 1
1Z0-074 question #77 exhibit 2

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.

Full 1Z0-074 Practice