1z0-052

All posts relating to Oracle certification (OCA, OCP, OCM).

Moderator: Tim...

1z0-052

Postby Mohammad Amin » Sat May 11, 2013 6:35 am

in OCA 11g exam , I find the following question
Automatic Shared Memory Management is disabled for your database instance. You realize that
there are cases of SQL statements performing poorly because of repeated parsing activity,
resulting in degradation of performance. What would be your next step to improve performance?
A. Run the SQL Access Advisor
B. Run the Memory Advisor for the SGA.
C. Run the Memory Advisor for the PGA.
D. Run the Memory Advisor for the shared pool.
E. Run the Memory Advisor for the buffer cache.

what is the right answer, please
Thanks
Mohammad Amin
Member
 
Posts: 2
Joined: Sat May 11, 2013 6:23 am

Re: 1z0-052

Postby Tim... » Sat May 11, 2013 7:36 am

Hi.

The correct answer is D. Why?

A) The SQL Access Advisor will help you decide what indexes and maybe materialized views will help with the performance of the statement, but it doesn't affect the amount of parsing that is done. Access structures have no impact on the amount of parsing the database does.

B) There is no SGA memory advisor.

C) The PGA is used for in memory sorts, cursors and package variables etc. It does not affect the number of parses.

D) The shared pool holds shared SQL. If it is sized too small, SQL will be aged out very quickly to make room of other SQL statements. This means there is a high possibility, when running the same SQL statement multiple times, the SQL statement might of aged out of the shared pool and need to be re-parsed. That's why this is the correct answer.

E) The buffer cache holds data blocks. Having more memory assigned to it does not affect parsing of SQL.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17952
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: 1z0-052

Postby Mohammad Amin » Sat May 11, 2013 10:01 am

Many Thanks, I asked you , because I saw in pdf dumps the answer is E and in others the answer is D
Thanks again
Mohammad Amin
Member
 
Posts: 2
Joined: Sat May 11, 2013 6:23 am

Re: 1z0-052

Postby Tim... » Sat May 11, 2013 10:38 am

OK. :)

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17952
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: 1z0-052

Postby matthew_morris » Thu May 23, 2013 12:28 am

There are two problems with Mohammad's post.

1. Brain dumps are not valid material to use for preparing for a certification exam. Studying with material that claims to be actual test questions and answers is cheating.
2. By posting that question here, you are effectively (presumably) posting an actual Oracle test question, which is forbidden by the candidate agreement.

You can find a great deal of legitimate study material for the 1Z0-052 exam here:

http://www.oraclecertificationprep.com/ ... AM:1Z0-052
Matthew Morris
DBA/Developer/Author
OCP DBA 7.3, 8, 9i, 10g, 11g, 12c
OCP Advanced PL/SQL Developer
My website: http://www.oraclecertificationprep.com
My blog: http://ocprep.blogspot.com/
User avatar
matthew_morris
Member
 
Posts: 12
Joined: Thu May 23, 2013 12:15 am
Location: Orlando, FL

Re: 1z0-052

Postby Tim... » Thu May 23, 2013 7:00 am

Hi.

Can't believe I didn't pick up the reference to the brain dumps. My stock answer to anything relating to them is shown here:

viewtopic.php?f=3&t=9793

I figured it was a question from a book or something. I should pay more attention. :)

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17952
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle Certification

Who is online

Users browsing this forum: No registered users and 1 guest