Oracle
1Z0-497 · Question #107
Which three statements are true about System Global Area (SGA)?
The correct answer is C. SGA is allocated automatically when a database is started. D. SGA is used to speed up queries by caching data blocks, program data, information about F. SGA is read and written by server and background processes. See the full explanation below for the reasoning.
Question
Which three statements are true about System Global Area (SGA)?
Options
- ASGA contains shared memory structures for all Oracle processes running on a single server.
- BEach server process has its own SGA.
- CSGA is allocated automatically when a database is started.
- DSGA is used to speed up queries by caching data blocks, program data, information about
- ESGA is allocated automatically when a database is mounted.
- FSGA is read and written by server and background processes.
How the community answered
(36 responses)- A6% (2)
- B8% (3)
- C83% (30)
- E3% (1)
Community Discussion
No community discussion yet for this question.