ExamQuestions.com

Register
Login
Oracle Database 12c Advanced Administration Exam Questions

Oracle

Oracle Database 12c Advanced Administration

125 / 155

Question 125:

You set the following parameters in the parameter file and restart the database instance: NEMORY_MAX_TARGET=0 - MEMORY__TARGET=500M - PGA_AGGREGATE_TARGET=90M - SGA_TARGET=270M - Which two statements are true? 

Answer options:

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