Oracle
1Z0-043 · Question #15
You have set some of the initialization parameters as: DB_BLOCK_SIZE = 8KB SGA_MAX_SIZE = 2GB SGA_TARGET = 0 SHARED_POOL_SIZE = 120MB DB_CACHE_SIZE = 896MB STREAM_POOL_SIZE = 0 LARGE_POOL_SIZE = 110…
The correct answer is A. You cannot set a value for the DB_8K_CACHE_SIZE parameter. C. If the value for SGA_TARGET is changed to 1 GB and SHARED_POOL_SIZE is set to 120 MB. See the full explanation below for the reasoning.
Question
You have set some of the initialization parameters as:
DB_BLOCK_SIZE = 8KB SGA_MAX_SIZE = 2GB SGA_TARGET = 0 SHARED_POOL_SIZE = 120MB DB_CACHE_SIZE = 896MB STREAM_POOL_SIZE = 0 LARGE_POOL_SIZE = 110 MB Which two statements are correct? (Choose two.)
Options
- AYou cannot set a value for the DB_8K_CACHE_SIZE parameter.
- BIf you increase the size of the large pool to 120 MB, then the memory allocated to the shared pool
- CIf the value for SGA_TARGET is changed to 1 GB and SHARED_POOL_SIZE is set to 120 MB,
- DIf an application attempts to allocate more than 120 MB from the shared pool and free space is
How the community answered
(44 responses)- A82% (36)
- B5% (2)
- D14% (6)
Community Discussion
No community discussion yet for this question.