READ Free Dumps For Oracle- 1z0-023
| Question ID 8902 | Which two are components of the SGA? (Choose two)
|
| Option A | The library cache.
|
| Option B | The rollback cache.
|
| Option C | The parameter cache.
|
| Option D | The commit SCN pool.
|
| Option E | The data dictionary cache.
|
| Correct Answer | AE |
Explanation Explanation/Reference: Explanation: Answers A and E are correct. The library cache and the data dictionary cache (row cache) are components of the SGA. Incorrect Answers: B: There is no rollback cache component in the SGA. C: There is no parameter cache in the SGA. D: There is no commit SCN pool in the SGA. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 257-258 Chapter 6: Basics of the Oracle Database Architeture
| Question ID 8903 | Which component is NOT part of the shared pool?
|
| Option A | The library cache.
|
| Option B | The shared SQL area.
|
| Option C | The program global area.
|
| Option D | The data dictionary cache.
|
| Correct Answer | C |
Explanation Explanation/Reference: Explanation: Answer C is correct. The PGA (Program Global Area) is separate memory structure from the shared pool. The PGA helps user processes execute by storing information like bind variables values, sort areas, and other aspects of cursor handling. Incorrect Answers: A: The library cache is part of the shared pool. It is used for storing parsed SQL statement text and the statement's executing plan for reuse. C: The shared SQL area is also part of the shared pool. D: The data dictionary cache (row cache) is part of the shared pool. It is used for storing recently accessed information (table and column definitions, usernames, passwords, and privileges) from the Oracle data dictionary. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 257-258 Chapter 6: Basics of the Oracle Database Architeture