1Z0-040 Oracle Database 10g: New Features for Administrators Training Course

Oracle ™

1Z0-040 Oracle Database 10g: New Features for Administrators

Note 1: 1Z0-040 Exhibit and all related diagrams are not shown in demo questions.
Note 2: 1Z0-040 Answers are not shown in demo questions.
Exhibits and Answers are only provided in the Full Version.

Demo Question 7.

You set SGA parameters in your database as: DB_CACHE_SIZE=24MB JAVA_POOL_SIZE=48MB SHARED_POOL_SIZE=96MB You plan to upgrade to Oracle Database 10g. You need to provide an additional 20 MB memory space to accommodate internal overhead allocations for metadata. Which SGA parameter(s) would you modify?

A. change JAVA_POOL SIZE to 68MB
B. change DB_CACHE_SIZE to 44MB
C. change SHARED_POOL_SIZE to 116MB
D. change JAVA_POOL_SIZE to 58MB and DB_CACHE_SIZE to 34MB
E. change SHARED_POOL_SIZE to 106MB and DB_CACHE_SIZE to 34MB

Display Answer

Purchase Full Version:

1Z0-040 Printable PDF Prep Guide $49.95 BUY NOW!

1Z0-040 Test Simulation Engine $69.95 BUY NOW!

1Z0-040 PDF & Test Simulation Engine $99.95 BUY NOW!

Answer: C The SHARED_POOL_SIZE initialization parameter is a dynamic parameter that lets you specify or adjust the size of the shared pool component of the SG A. Oracle Database selects an appropriate default value. Starting with Oracle Database 10 g Release 1, the size of internal SGA overhead is included in the user-specified value of SHARED_POOL_SIZE. In other words, if you are not using the automatic shared memory management feature, then the amount of shared pool memory that is allocated at startup is exactly equal to the value of SHARED_POOL_SIZE initialization parameter. In manual SGA mode, this parameter must be set so that it includes the internal SGA overhead in addition to the desired value of shared pool size. REF. : Oracle(r) 10g Administrator Guide, 2-31

Explanation: