AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


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

Send email to admin@getfreedumps for new dumps request!!!