nerdexam
Exams1Z0-052Questions#74
Oracle

1Z0-052 · Question #74

1Z0-052 Question #74: Real Exam Question with Answer & Explanation

Sign in or unlock 1Z0-052 to reveal the answer and full explanation for question #74. The question stem and answer options stay visible for context.

Question

You have executed this command to change the size of the database buffer cache: SQL> ALTER SYSTEM SET DB_CACHE_SIZE=2516582; System altered. To verify the change in size, you executed this command: SQL> SHOW PARAMETER DB_CACHE_SIZE NAME TYPE VALUE -------------- ------------ ------------ db_cache_size big integer 4194304 Why is the value set to 4194304 and not to 2516582?

Options

  • ABecause 4194304 is the granule size
  • BBecause 4194304 is the standard block size
  • CBecause 4194304 is the largest nonstandard block size defined in the database
  • DBecause 4194304 is the total size of data already available in the database buffer cache

Unlock 1Z0-052 to see the answer

You've previewed enough free 1Z0-052 questions. Unlock 1Z0-052 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-052 Practice
You have executed this command to change the size of the database... | 1Z0-052 Q#74 Answer | NerdExam