Oracle
1Z0-054 · Question #98
You are hired by ABC Pvt Ltd., and assigned the task of managing one of its development databases. The company has recently upgraded this database to Oracle Database 11g from Oracle Database 10g…
The correct answer is A. The implementation of AMM fails because the MEMORY_MAX_TARGET parameter is not set. See the full explanation below for the reasoning.
Question
You are hired by ABC Pvt Ltd., and assigned the task of managing one of its development databases. The company has recently upgraded this database to Oracle Database 11g from Oracle Database 10g. You noticed that SGA is undersized as shown in Exhibit 1. To investigate further, you checked the related parameters as shown in Exhibit 2. You executed the following command to solve the problem:
ALTER SYSTEM SET MEMORY_TARGET=800M; What would happen?
Exhibits
Options
- AThe implementation of AMM fails because the MEMORY_MAX_TARGET parameter is not set.
- BIt implements AMM by setting MEMORY_TARGET and MEMORY_MAX_TARGET parameters to
- CIt implements Automatic Memory Management (AMM) by setting MEMORY_TARGET to 768M
- DThe implementation of AMM fails because the MEMORY_TARGET parameter cannot be set to a
How the community answered
(24 responses)- A79% (19)
- B4% (1)
- C4% (1)
- D13% (3)
Community Discussion
No community discussion yet for this question.