Re: OCP question from Boson practice tests
Hi, This is from a metalink note 1039341.6. It is about 'DEFAULT STORAGE'. I do not know if the OCP question was regarding that. *** Use the following guidelines to specify DEFAULT STORAGE: Set INITIAL=NEXT.Since a process always writes data equal to SORT_AREA_SIZE to a temporary segment, a good value for the extentsize is (n*s + b) where: n is a positive integer s is the value of SORT_AREA_SIZE initialization parameter b is the value of DB_BLOCK_SIZE initialization parameter Using this value optimizes temporary segment usage by allowingsufficient space for a header block and multiple sort run data to bestored in each extent. Is this not correct? Forget OCP. I was just want clarify this issue. Good luck for the exams Prem. Further to that if I give my sort area size as a very odd number which is not a multiple of OS block size then what happens. Thank You[EMAIL PROTECTED] wrote: Prem ,OCP has nothing to do with knowledge and nothing to do with the real world.So if you want to give OCP, forget what you know and humbly, play by itsrules.Right now if your are serious about giving OCP exams then pleaseenable "suspension of disbelief" , don't ask why and just mug up thefollowing 3 (any one of them may come up in the ocp exam , though nottogether) :1.To optimize the performance of a sort in a temprary tablespace , set theUNIFORM SIZE to be a multiple of the parameter sort_area_size2.To optimize the performance of a sort in a temprary tablespace , set theUNIFORM SIZE to be a multiple of sort_area_size * db_block_size3.To optimize the performance of a sort in a temprary tablespace , set theUNIFORM SIZE to be n * sort_area_size + db_block_size.OCP has nothing to do with knowledge and nothing to do with the real world.So if you want to give OCP, forget what you know and play by its rules.Best of luck . Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
Re: Re[1]: OCP question from Boson practice tests
- Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 08, 2004 1:59 AM My question, Richard, is can a person pass the exam just by studying what is correct? Or is it necessary to work harder to acquire some veneer of false knowledge specifically in order to pass the exam? Hi Cary Yes you can. That's why you're allowed to get 1/3 of the questions wrong and still pass the exam !! In defence of the questions, it's actually not that easy to write a multiple choice question that is both challenging AND non-ambiguous. The more complex an issue, the less likely you're going to successfully bind up a comprehensive and accurate answer in a single statement. That's why so many of the questions are so trivial, that's why the exams are so trivial and that's why the multiple choice method is so awful in determining an OCP. Attempts of questions to go beyond syntax, parameter settings, etc. often cause confusion and debate because the answer to the more complex issue isn't as simplistic as the question writers hoped it to be. Interestingly, during beta testing, questions get selected based on how many people actually get the same (hopefully) correct answer. If most people agree with an answer, then the question is less likely to be ambiguous. So by intentional design, the OCP exams are actually aimed and geared towards the lowest common denominator. So in short Cary, you have a fair to average chance of passing the exams :) Cheers Richard -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Foote INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re[1]: OCP question from Boson practice tests
Hi Prem Comments in line. Hi Richard , Many a thanx for both of your replies . All my worry is : do such questions appear in the real exams also ? Although there are certainly some dodgy questions and correspondingly suz answers, I think you'll find the majority of the OCP exam will have 'relatively' clear answers. Certainly enough to make a failure be a deservable event :) My biggest wish would be for there to be 3 additional selections to most questions: F) what does it matter so who cares G) you would check the syntax, correct parameter name, etc. in the manuals H) it depends because the above 3 answers are generally (often collectively) the *correct* answer to the questions. And your reply has increased my self-confidence. particularly the line : RFTrust what you *see*, not what you *read*. /RF RFYou actually proven this yourself and yet you still have doubts? /RF yes Richard : ( hope i will not repeat this as time goes and my experience grows. i.e., i will be more confident with my answers . Experience only comes with time. And in time, your confidence will grow. Trust me, you'll get there. okay , coming back to the sizing of temp tablespace question . if suppose , such a question appears in the exam too ( my bad luck ) , what will be your two best answers ? Honestly, with this question, I would keep a mental picture of the thing, pick any 2 answers (users and sort_area_size would be my pick but as I said, they're simply not correct), move on to the next question and report back to Oracle what the hell they meant by the bloody thing. Cheers (and good luck) Richard -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Foote INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[1]: OCP question from Boson practice tests
Richard Foote scribbled on the wall in glitter crayon: So in short Cary, you have a fair to average chance of passing the exams :) that's Ok for Cary, what about us mere mortals?;-) -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] We must be willing to get rid of the life we've planned, so as to have the life that is waiting for us. The old skin has to be shed before the new one can come Joseph Campbell -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OCP question from Boson practice tests
Hi List, this is the question . You are calculating the proper size for a temporary tablespace . Which of the following are two most important factors to consider ? A. users B. sort_area_size C. type of tablespace management D. db_block_size my choice is A B . but boson's choice is B D . the explanation given by boson is : when sizing a temporary tablespace , the formula is db_block_size * sort_area_size . is it so ? do we need not take no. of users into account ? kindly explain me . Regards, Prem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OCP question from Boson practice tests
Hi again Prem, OK, I've changed my opinion of dear Boson. At first I simply thought they had no idea, now I suspect it's all a big joke designed to make DBAs have a bit of a giggle on warm summer nights ... Sizing the temp tablespace by the formula you've given is really quite witty. Perhaps a little on the silly side but I love Monty Python so I liked it. The correct answer is actually none of the four listed (so I'm really struggling to find two of the buggers). A. Users: Not really. I could show you a DW database with only a handful of users that requires a much larger temp tablespace than an OLTP database with 1000s of users. It not the number of users but what the users *do* that's important. B. Sort Area Size. Not really. Although it can influence whether a sort is performed on temp or not, it's the size of the *sort*, not the size of the S_A_S that's important. And not just the size of one sort, but the size of the *max concurrent* sort activity. I guess a badly set S_A_S could result in needing a larger temp tablespace but I doubt that's the point of the question. And then there's hash joins, etc, ooops, the question has kinda forgotten about non sort activity in temp C. tablespace management. Not really although I guess those bitmaps do take up some space ... D. db_block_size. What the #@* ??. Thinking about all this a bit more, if Boson's practice questions puts people off doing OCPs, it might not be such a bad thing after all ... Cheers ;) Richard - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 8:44 PM Hi List, this is the question . You are calculating the proper size for a temporary tablespace . Which of the following are two most important factors to consider ? A. users B. sort_area_size C. type of tablespace management D. db_block_size my choice is A B . but boson's choice is B D . the explanation given by boson is : when sizing a temporary tablespace , the formula is db_block_size * sort_area_size . is it so ? do we need not take no. of users into account ? kindly explain me . Regards, Prem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Foote INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re[1]: OCP question from Boson practice tests
Hi Richard , Many a thanx for both of your replies . All my worry is : do such questions appear in the real exams also ? And your reply has increased my self-confidence. particularly the line : RFTrust what you *see*, not what you *read*. /RF RFYou actually proven this yourself and yet you still have doubts? /RF yes Richard : ( hope i will not repeat this as time goes and my experience grows. i.e., i will be more confident with my answers . okay , coming back to the sizing of temp tablespace question . if suppose , such a question appears in the exam too ( my bad luck ) , what will be your two best answers ? Thanks and Regards, Prem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OCP question from Boson practice tests
Well, you've certainly gotten a few decent replies. I've never used Boson so I can't comment on their exams, I prefer going to Oracle Press. Anyway, sizing temp is a combination of things many of which are black magic at best. Number of users is an interesting variable to add, but not of an extreme value since it's actually the number of CONNECTED users that will really affect the value arrived at. Sort_Area_size, Maybe. If it's large enough it may well negate the need for temp in a number of cases, but don't bet on it. Type of Tablespace management? OK, who's smoking what. That's a giveaway toss out. DB_Block_Size, again a giveaway, it has no real bearing since the temp tablespace will have the same size, unless you use 9i features, but even then a MB is a MB. The real answer is know what your database is suppose to be doing. If your setting up an OLTP database you may well get away with a very small temp space. On the other hand a data warehouse or decision support system is, by design, going to consume mountains of temp. Also do not forget things like index rebuilds that you will need to do, they do sorts and consequently consume temp in the process. Then there's always that wild user who lets loose the Cartesian product from haties that will blow all of your calculations off the map. Therefore the answer in this case is E: None of the above. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, January 07, 2004 5:44 AM To: Multiple recipients of list ORACLE-L Hi List, this is the question . You are calculating the proper size for a temporary tablespace . Which of the following are two most important factors to consider ? A. users B. sort_area_size C. type of tablespace management D. db_block_size my choice is A B . but boson's choice is B D . the explanation given by boson is : when sizing a temporary tablespace , the formula is db_block_size * sort_area_size . is it so ? do we need not take no. of users into account ? kindly explain me . Regards, Prem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re[2]: OCP question from Boson practice tests
Wednesday, January 7, 2004, 9:39:25 AM, Prem Khanna J ([EMAIL PROTECTED]) wrote: PKJ Many a thanx for both of your replies . PKJ All my worry is : do such questions appear in the real exams also ? I think you've hit on something key here, and that is that practice exams may not be reflective of the real thing. One of my secrets for taking the OCP exams is that you can sometimes play off one question against another. Sometimes the answer to one question is part of another question. Consider, just by way of example: 1. Which view gives you the number of blocks in a segment? a. DBA_SEGMENTS b. DBA_SEG_SIZE c. DBA_SEGMENT_SIZE d. V$SEGMENTS Ok, say that you don't know. Just wait for awhile, and plan to come back that question later, because later you might run into the following: 47. How any rows will one table have in DBA_SEGMENTS? .. The answers to question 47 don't matter here. What's important here is that the answer to question 47 gives away the answer to question 1. Now these are just example questions that I made up off the top of my head, but you get the idea. In my own actual exam taking, I've several times gotten clues to, or even answers to, questions that I couldn't immediately answer by reading other questions in the exam. Ok. I've given away my secret. Now the whole world knows: I'm only good at taking testsgrin. Something else I've found valuable is a good knowledge of Oracle's architecture. If you know how Oracle is put together, and how the different processes work, you can often make intelligent guesses. For example (maybe not a perfect example): 37. You created a table and specified INITIAL 65000, yet your initial extent is actually 65536 bytes long. Why is that? 1. Oracle rounds up to the next power of 2. 2. The tablespace actually had 65536 bytes available, so Oracle allocated all available space. 3. Oracle's lowest unit of space allocation is the block, and it took 8 8KB blocks to cover the space you asked for. 4. Oracle always allocates at least enough 64KB chunks to cover the space that you ask for. To my neighbor, who knows nothing about Oracle, all these answers might seem plausible. But if you understand Oracle's architecture, including the concepts of blocks, segments, extents, tablespaces, and so forth, that knowledge might be just enough to help you zero in on the correct answer. I'm not sure this last was the best example I could have come up with, but all that aside, understanding the architecture has helped me a great deal in eliminating spurious answers to questions. Maybe, out of four answers to a question I didn't know, I could only eliminate two answers for architectural reasons, but even doing that increases my odds from guessing from 25% to 50%. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[1]: OCP question from Boson practice tests
My question, Richard, is can a person pass the exam just by studying what is correct? Or is it necessary to work harder to acquire some veneer of false knowledge specifically in order to pass the exam? Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 1/27 Atlanta - SQL Optimization 101: 2/16 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Prem Khanna J Sent: Wednesday, January 07, 2004 8:39 AM To: Multiple recipients of list ORACLE-L Hi Richard , Many a thanx for both of your replies . All my worry is : do such questions appear in the real exams also ? And your reply has increased my self-confidence. particularly the line : RFTrust what you *see*, not what you *read*. /RF RFYou actually proven this yourself and yet you still have doubts? /RF yes Richard : ( hope i will not repeat this as time goes and my experience grows. i.e., i will be more confident with my answers . okay , coming back to the sizing of temp tablespace question . if suppose , such a question appears in the exam too ( my bad luck ) , what will be your two best answers ? Thanks and Regards, Prem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re[1]: OCP question from Boson practice tests
for performance tuning exam you have to know some garbage. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 10:59 AM My question, Richard, is can a person pass the exam just by studying what is correct? Or is it necessary to work harder to acquire some veneer of false knowledge specifically in order to pass the exam? Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 1/27 Atlanta - SQL Optimization 101: 2/16 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Prem Khanna J Sent: Wednesday, January 07, 2004 8:39 AM To: Multiple recipients of list ORACLE-L Hi Richard , Many a thanx for both of your replies . All my worry is : do such questions appear in the real exams also ? And your reply has increased my self-confidence. particularly the line : RFTrust what you *see*, not what you *read*. /RF RFYou actually proven this yourself and yet you still have doubts? /RF yes Richard : ( hope i will not repeat this as time goes and my experience grows. i.e., i will be more confident with my answers . okay , coming back to the sizing of temp tablespace question . if suppose , such a question appears in the exam too ( my bad luck ) , what will be your two best answers ? Thanks and Regards, Prem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re[1]: OCP question from Boson practice tests
Misconceptions, superstitions and myths are always useful to know and believe in. They make people better socialized and the risk of being burnt at stake as a heretic(metaphorically, of course) is much lower. On 01/07/2004 10:59:26 AM, Cary Millsap wrote: Or is it necessary to work harder to acquire some veneer of false knowledge specifically in order to pass the exam? -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[1]: OCP question from Boson practice tests
From past history: I passed the 8 and 8i exams without having done any work in either version, nor did I study for them. I used Jonathan's method of using later questions to infer the answer to earlier ones, in part. Marlene Theriault, an excellent DBA, took several tries to pass because she knew the correct answers and therefore was usually wrong in the expected answer. :) --- Cary Millsap [EMAIL PROTECTED] wrote: My question, Richard, is can a person pass the exam just by studying what is correct? Or is it necessary to work harder to acquire some veneer of false knowledge specifically in order to pass the exam? Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 1/27 Atlanta - SQL Optimization 101: 2/16 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Prem Khanna J Sent: Wednesday, January 07, 2004 8:39 AM To: Multiple recipients of list ORACLE-L Hi Richard , Many a thanx for both of your replies . All my worry is : do such questions appear in the real exams also ? And your reply has increased my self-confidence. particularly the line : RFTrust what you *see*, not what you *read*. /RF RFYou actually proven this yourself and yet you still have doubts? /RF yes Richard : ( hope i will not repeat this as time goes and my experience grows. i.e., i will be more confident with my answers . okay , coming back to the sizing of temp tablespace question . if suppose , such a question appears in the exam too ( my bad luck ) , what will be your two best answers ? Thanks and Regards, Prem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[1]: OCP question from Boson practice tests
Wasn't it you, Cary, who got tought by his parents that every question has two answers: The right one and the one the teacher wants to hear? And you had to learn them both? That's merely what OCP is about, I think. Get a certificate to get hired, and get the proper knowledge to remain hired ;-) Regards, Carel-Jan === If you think education is expensive, try ignorance. (Derek Bok) === At 07:59 7-1-04 -0800, you wrote: My question, Richard, is can a person pass the exam just by studying what is correct? Or is it necessary to work harder to acquire some veneer of false knowledge specifically in order to pass the exam? Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 1/27 Atlanta - SQL Optimization 101: 2/16 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Prem Khanna J Sent: Wednesday, January 07, 2004 8:39 AM To: Multiple recipients of list ORACLE-L Hi Richard , Many a thanx for both of your replies . All my worry is : do such questions appear in the real exams also ? And your reply has increased my self-confidence. particularly the line : RFTrust what you *see*, not what you *read*. /RF RFYou actually proven this yourself and yet you still have doubts? /RF yes Richard : ( hope i will not repeat this as time goes and my experience grows. i.e., i will be more confident with my answers . okay , coming back to the sizing of temp tablespace question . if suppose , such a question appears in the exam too ( my bad luck ) , what will be your two best answers ? Thanks and Regards, Prem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Regards, Carel-Jan === If you think education is expensive, try ignorance. (Derek Bok) === -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Carel-Jan Engel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[1]: OCP question from Boson practice tests
Yes, I was the one. I was just wondering whether the OCP performance exam was really as bad as it used to be. I haven't seen it since whatever the things were called back in the early 90s. From some of what I've seen here, the answer is that yes it is the same. Not just philosophically the same, but probably some of the same release 7 questions are still on the test. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 1/27 Atlanta - SQL Optimization 101: 2/16 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Carel-Jan Engel Sent: Wednesday, January 07, 2004 11:05 AM To: Multiple recipients of list ORACLE-L Wasn't it you, Cary, who got tought by his parents that every question has two answers: The right one and the one the teacher wants to hear? And you had to learn them both? That's merely what OCP is about, I think. Get a certificate to get hired, and get the proper knowledge to remain hired ;-) Regards, Carel-Jan === If you think education is expensive, try ignorance. (Derek Bok) === At 07:59 7-1-04 -0800, you wrote: My question, Richard, is can a person pass the exam just by studying what is correct? Or is it necessary to work harder to acquire some veneer of false knowledge specifically in order to pass the exam? Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 1/27 Atlanta - SQL Optimization 101: 2/16 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Prem Khanna J Sent: Wednesday, January 07, 2004 8:39 AM To: Multiple recipients of list ORACLE-L Hi Richard , Many a thanx for both of your replies . All my worry is : do such questions appear in the real exams also ? And your reply has increased my self-confidence. particularly the line : RFTrust what you *see*, not what you *read*. /RF RFYou actually proven this yourself and yet you still have doubts? /RF yes Richard : ( hope i will not repeat this as time goes and my experience grows. i.e., i will be more confident with my answers . okay , coming back to the sizing of temp tablespace question . if suppose , such a question appears in the exam too ( my bad luck ) , what will be your two best answers ? Thanks and Regards, Prem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Regards, Carel-Jan === If you think education is expensive, try ignorance. (Derek Bok) === -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Carel-Jan Engel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing
RE: Re[1]: OCP question from Boson practice tests
or from the other side: the right one, and the one pig-headed students are convinced is right (even if you can incontrovertably demonstrate they are wrong). Does that make three answers? or two answers with three labels? Henry -Original Message- Carel-Jan Engel Sent: Wednesday, January 07, 2004 12:05 PM To: Multiple recipients of list ORACLE-L Wasn't it you, Cary, who got tought by his parents that every question has two answers: The right one and the one the teacher wants to hear? And you had to learn them both? That's merely what OCP is about, I think. Get a certificate to get hired, and get the proper knowledge to remain hired ;-) Regards, Carel-Jan === If you think education is expensive, try ignorance. (Derek Bok) === At 07:59 7-1-04 -0800, you wrote: My question, Richard, is can a person pass the exam just by studying what is correct? Or is it necessary to work harder to acquire some veneer of false knowledge specifically in order to pass the exam? Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 1/27 Atlanta - SQL Optimization 101: 2/16 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Prem Khanna J Sent: Wednesday, January 07, 2004 8:39 AM To: Multiple recipients of list ORACLE-L Hi Richard , Many a thanx for both of your replies . All my worry is : do such questions appear in the real exams also ? And your reply has increased my self-confidence. particularly the line : RFTrust what you *see*, not what you *read*. /RF RFYou actually proven this yourself and yet you still have doubts? /RF yes Richard : ( hope i will not repeat this as time goes and my experience grows. i.e., i will be more confident with my answers . okay , coming back to the sizing of temp tablespace question . if suppose , such a question appears in the exam too ( my bad luck ) , what will be your two best answers ? Thanks and Regards, Prem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Regards, Carel-Jan === If you think education is expensive, try ignorance. (Derek Bok) === -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Carel-Jan Engel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Poras, Henry R. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OCP question from Boson practice tests
Prem , OCP has nothing to do with knowledge and nothing to do with the real world. So if you want to give OCP, forget what you know and humbly, play by its rules. Right now if your are serious about giving OCP exams then please enable suspension of disbelief , don't ask why and just mug up the following 3 (any one of them may come up in the ocp exam , though not together) : 1. To optimize the performance of a sort in a temprary tablespace , set the UNIFORM SIZE to be a multiple of the parameter sort_area_size 2. To optimize the performance of a sort in a temprary tablespace , set the UNIFORM SIZE to be a multiple of sort_area_size * db_block_size 3. To optimize the performance of a sort in a temprary tablespace , set the UNIFORM SIZE to ben * sort_area_size + db_block_size. OCP has nothing to do with knowledge and nothing to do with the real world. So if you want to give OCP, forget what you know and play by its rules. Best of luck . - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 16:14 Hi List, this is the question . You are calculating the proper size for a temporary tablespace . Which of the following are two most important factors to consider ? A. users B. sort_area_size C. type of tablespace management D. db_block_size my choice is A B . but boson's choice is B D . the explanation given by boson is : when sizing a temporary tablespace , the formula is db_block_size * sort_area_size . is it so ? do we need not take no. of users into account ? kindly explain me . Regards, Prem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re[1]: OCP question from Boson practice tests
the pl/sql exam is really bad too. It got worse from 8i to 9i. 10% of the exam was on DBMS_LOB and no other packages were touched? I had about 6-7 questions on parameter ordering. Its accurate, just useless. I thought the architecture test wasn't bad at all. The 8i backup and recovery one was 'ok' also. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 12:19 PM Yes, I was the one. I was just wondering whether the OCP performance exam was really as bad as it used to be. I haven't seen it since whatever the things were called back in the early 90s. From some of what I've seen here, the answer is that yes it is the same. Not just philosophically the same, but probably some of the same release 7 questions are still on the test. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 1/27 Atlanta - SQL Optimization 101: 2/16 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Carel-Jan Engel Sent: Wednesday, January 07, 2004 11:05 AM To: Multiple recipients of list ORACLE-L Wasn't it you, Cary, who got tought by his parents that every question has two answers: The right one and the one the teacher wants to hear? And you had to learn them both? That's merely what OCP is about, I think. Get a certificate to get hired, and get the proper knowledge to remain hired ;-) Regards, Carel-Jan === If you think education is expensive, try ignorance. (Derek Bok) === At 07:59 7-1-04 -0800, you wrote: My question, Richard, is can a person pass the exam just by studying what is correct? Or is it necessary to work harder to acquire some veneer of false knowledge specifically in order to pass the exam? Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 1/27 Atlanta - SQL Optimization 101: 2/16 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Prem Khanna J Sent: Wednesday, January 07, 2004 8:39 AM To: Multiple recipients of list ORACLE-L Hi Richard , Many a thanx for both of your replies . All my worry is : do such questions appear in the real exams also ? And your reply has increased my self-confidence. particularly the line : RFTrust what you *see*, not what you *read*. /RF RFYou actually proven this yourself and yet you still have doubts? /RF yes Richard : ( hope i will not repeat this as time goes and my experience grows. i.e., i will be more confident with my answers . okay , coming back to the sizing of temp tablespace question . if suppose , such a question appears in the exam too ( my bad luck ) , what will be your two best answers ? Thanks and Regards, Prem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Regards, Carel-Jan === If you think education is expensive, try ignorance. (Derek Bok) === -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Carel-Jan Engel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like
RE: Re[1]: OCP question from Boson practice tests
Hi all I have a problem with a lot of the commentary on the OCP that I have read here and elsewhere, especially that which focusses on specific questions and the, ahem, 'product features' associated with them. My problem is this. To me the OCP, or rather the OU courses and the associated revision (= what the hell did I do 2 months ago I've got a test now) work necessary to pass the OCP were particularly helpful in illuminating areas in which I was, now what is the expression - ah yes, brain-dead. MTS and connection pooling for example, wonderful stuff, what a good idea. Don't use it myself, don't know how it works and keep getting the acronym confused with Microsoft Transaction Server. Oh what you mean maybe I should at least recognize the term and the idea behind it. Oh very well then. My guess would be that one could pass the exam just by working with Oracle for a couple of years and comparing that to some practice questions, one wouldn't do especially well but 60% or so will pass you. Doing the courses, especially if you get one of those educators who insist on knowing how the thing actually works as well as what the course notes say will be an even better investment. Of course criticism of the OCP based on the fact that it values version specific syntax over DBA/Developer principles is right on the money IMO. Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[1]: OCP question from Boson practice tests
My guess would be that one could pass the exam just by working with Oracle for a couple of years and comparing that to some practice questions, one True. I took the beta OCP tests in 1997, with about 150 questions per test. They were free at OOW, so it seemed like a good price. Three years experience, no problem. Of course, some of my answers were probably incorrect, in accordance with my misconceptions at the time, but they were good enough to pass the test. ;) Jared On Wed, 2004-01-07 at 14:34, Niall Litchfield wrote: Hi all I have a problem with a lot of the commentary on the OCP that I have read here and elsewhere, especially that which focusses on specific questions and the, ahem, 'product features' associated with them. My problem is this. To me the OCP, or rather the OU courses and the associated revision (= what the hell did I do 2 months ago I've got a test now) work necessary to pass the OCP were particularly helpful in illuminating areas in which I was, now what is the expression - ah yes, brain-dead. MTS and connection pooling for example, wonderful stuff, what a good idea. Don't use it myself, don't know how it works and keep getting the acronym confused with Microsoft Transaction Server. Oh what you mean maybe I should at least recognize the term and the idea behind it. Oh very well then. My guess would be that one could pass the exam just by working with Oracle for a couple of years and comparing that to some practice questions, one wouldn't do especially well but 60% or so will pass you. Doing the courses, especially if you get one of those educators who insist on knowing how the thing actually works as well as what the course notes say will be an even better investment. Of course criticism of the OCP based on the fact that it values version specific syntax over DBA/Developer principles is right on the money IMO. Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).