ORA-04031: unable to allocate 4000 bytes of shared memory On investigation, you found that SGA_MAX_SIZE was larger than the sum of the sizes of all System Global Area (SGA) components and you do not have the scope to increase it further. Identify a solution to reduce the probability of getting this error in future.
A. Set the PRE_PAGE_SGA parameter to TRUE
B. Set the LOCK_SGA initialization parameter to TRUE
C. Implement Automatic Shared Memory Management
D. Set the SGA_TARGET initialization parameter to zero
Answer:A
ORA-04031: unable to allocate 4000 bytes of shared memory On investigation, you found that SGA_MAX_SIZE was larger than the sum of the sizes of all System Global Area (SGA) components and you do not have the scope to increase it further. Identify a solution to reduce the probability of getting this error in future.
A. Set the PRE_PAGE_SGA parameter to TRUE B. Set the LOCK_SGA initialization parameter to TRUE C. Implement Automatic Shared Memory Management D. Set the SGA_TARGET initialization parameter to zero
Explanation: Cause: More shared memory is needed than was allocated in the shared pool.Action : If the shared pool is out of memory, either use the DBMS_shared_pool package to pin large packages, reduce your use of shared memory, or increase the amount of available shared memory by increasing the value of the INIT.ORA parameters 9. You created a new user on the database by executing the following command: 
