Oracle Exam 1Z0-067 Topic 5 Question 33 Discussion

Actual exam question for Oracle's 1Z0-067 exam

Question #: 33
Topic #: 5

Examine these parameter settings:

SGA_TARGET = 700M

SGA_MAX_SIZE = 1024M

DB_8K_CACHE_SIZE = 124M

LOG_BUFFER = 200M

You attempt this:

SQL> ALTER SYSTEM SER DB_8K_CACHE_SIZE=140M

Which statement is true based on the information available?

AIt will fail because DB_8K_CACHE_SIZE cannot be changed dynamically.

BIt succeeds only if memory is available from the autotuned components of the SGA.

CIt will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET.

DIt will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE.

Show Suggested Answer

Suggested Answer: B

by Jolene at May 08, 2022, 03:56 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!