Oracle
1Z0-054 · Question #98
1Z0-054 Question #98: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-054 to reveal the answer and full explanation for question #98. The question stem and answer options stay visible for context.
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
Unlock 1Z0-054 to see the answer
You've previewed enough free 1Z0-054 questions. Unlock 1Z0-054 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.