You set the following parameters in the parameter file and restart the database instance: Which two statements are true? (Choose two.)
A.
The MEMORY_MAX_TARGET parameter is automatically set to 500 MB.
B.
The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero.
C.
The value of the MEMORY_MAX_TARGET parameter remains zero for the database instance.
D.
The lower limits of the PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB respectively.
E.
The instance does not start up because Automatic Memory Management (AMM) is enabled but PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to nonzero values.
https://docs.oracle.com/database/121/ADMQS/GUID-E6784230-0A0C-443D-8537-36FFA08A7E75.htm#ADMQS12039
In a text initialization parameter file, if you omit the line for MEMORY_MAX_TARGET and include a value for MEMORY_TARGET, the database automatically sets MEMORY_MAX_TARGET to the value of MEMORY_TARGET. If you omit the line for MEMORY_TARGET and include a value for MEMORY_MAX_TARGET, the MEMORY_TARGET parameter defaults to zero. After startup, you can then dynamically change MEMORY_TARGET to a nonzero value, provided that it does not exceed the value of MEMORY_MAX_TARGET.
With MEMORY_TARGET set, the SGA_TARGET setting becomes the minimum size of the SGA and the PGA_AGGREGATE_TARGET setting becomes the minimum size of the instance PGA.
I agree with the answer: A and D:
A: if you omit the line for MEMORY_MAX_TARGET and include a value for MEMORY_TARGET, then the database automatically sets MEMORY_MAX_TARGET to the value of MEMORY_TARGET. https://docs.oracle.com/database/121/ADMIN/memory.htm#ADMIN11200
Basically, MEMORY TARGET AND MEMORY MAX TARGET is identical
upvoted 3 times
...
This section is not available anymore. Please use the main Exam Page.1z0-062 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Ray520
3 years, 1 month agobrg850
3 years, 6 months agoTuxBingo
4 years, 10 months agoNorthKorean
5 years, 1 month ago