D there is no commit scn pool in the sga oracle 8 dba

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Exam Guide, Jason S. Couchman, p. 257-258 Chapter 6: Basics of the Oracle Database Architeture QUESTION 142: Which component is NOT part of the shared pool? A. The library cache. B. The shared SQL area. C. The program global area. D. The data dictionary cache. Actualtests.com - The Power of Knowing 1Z0-023 Answer: C 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 Cha...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online