Apart from the buffer that hold data retrieved from the databases and the buffer that hold instance recovery information, the following are specific pools in a SGA, except... A. All these options B. Java C. shared D. varied E. stream
Question
Apart from the buffer that hold data retrieved from the databases and the buffer that hold instance recovery information, the following are specific pools in a SGA, except... A. All these options B. Java C. shared D. varied E. stream
Solution
The answer is D. varied. In a System Global Area (SGA), there are no specific pools referred to as "varied". The other options, Java, shared, and stream, are all specific pools in a SGA.
Similar Questions
Which of the following memory structures are part of the SGA? A. The PL/SQL pool B. The log buffer C. The shared pool D. The database buffer cache E. The program global area
Which of the following is NOT a component of the System Global Area (SGA)?A) Database buffer cacheB) Redo log bufferC) Program Global Area (PGA)D) Shared pool
Which memory structure in an Oracle instance is exclusive to each server process and contains control information for that process?A) Database buffer cacheB) Program Global Area (PGA)C) Large PoolD) System Global Area (SGA)
read of data block from physical data files into the database buffer in the SGA is handled by the ________ process. A. server B. batch C. user D. background
What are the two types of Streams proposed by Java 8?*1 pointA Random and synchronizedB Parallel and randomC Sequential and randomD Sequential and parallel
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.