Thanx - I cleared the exam -- another OCP question

2004-01-19 Thread Prem Khanna J
Hi list , thanx a lot to all of you . i cleared the #1Z0-031 exam last week . thanx again for all the support given by you friends. Kind Regards, Prem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services

RE: Thanx - I cleared the exam -- another OCP question

2004-01-19 Thread DENNIS WILLIAMS
Prem - We had no doubt. I always figure when you've studied enough to doubt your study guide, you're ready to pass the exam. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, January 15, 2004 6:04 AM To: Multiple recipients of list ORACLE-L Hi

RE: another OCP question -- help me guys

2004-01-09 Thread Thater, William
Pete Sharman scribbled on the wall in glitter crayon: Well, so here's the challenge for RMOUG training days - loosening Rachel's lips. Who's gonna join me in this endeavour? :) oh i have several methods i'd like to try.;-) -- Bill Shrek Thater ORACLE DBA I'm going to work my

Re: OCP question from Boson practice tests

2004-01-09 Thread A Joshi
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

RE: Re[2]: another OCP question -- help me guys

2004-01-08 Thread Jamadagni, Rajendra
-Original Message- [irrelevant stuff deleted] P.S. I can work powerpoint too. Close your Powerpoint.exe and S L O W L Y back away from the keyboard and nobody gets hurt ... Raj Rajendra dot Jamadagni at

Re: another OCP question -- help me guys

2004-01-08 Thread Richard Foote
1. Assume boson is right and recheck your answer. I disagree. Based on the questions and answers I've seen here, I would recommend that one assumes Boson is *wrong*, scratch one's head in mild confusion, utter a few expletives under one's breath and move on. Cheers ;) Richard -- Please see

Re: Re[1]: OCP question from Boson practice tests

2004-01-08 Thread Richard Foote
- 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

Re: Re[1]: OCP question from Boson practice tests

2004-01-08 Thread Richard Foote
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

Re: OCP Question (Perf Tuning)

2004-01-08 Thread Richard Foote
We'll thats exactly what I'm doing right now, studying Oracle University instructor guides to temporarily start thinking like OU myself again - I'll be instructing an OCP Review course next week, meant for people who want to pass OCP. And in order to not distract the students, I won't even

RE: Re[1]: OCP question from Boson practice tests

2004-01-08 Thread Thater, William
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

Re: OCP Question (Perf Tuning)

2004-01-08 Thread Tanel Poder
After the students have scribbled everything down, he then leans forward and quietly whispers to them that in the real world, heart surgeons actual first check whether or not it's actually necessary to cut out the heart *beforehand*. He then gives them a little wink and a nod, the students

Re: another OCP question -- help me guys

2004-01-08 Thread Mogens Nørgaard
I demand to know who the other one is! Mogens Rachel Carmichael wrote: you leave me such straight lines :) which part is qualified as an accountant? you volunteer to be the sacrificial lamb? Hm, masochist? Before Jared tries to send everyone over to my list on this topic, I'll try to

Re: another OCP question -- help me guys

2004-01-08 Thread Rachel Carmichael
my lips are sealed... G --- Mogens_Nørgaard [EMAIL PROTECTED] wrote: I demand to know who the other one is! Mogens Rachel Carmichael wrote: you leave me such straight lines :) which part is qualified as an accountant? you volunteer to be the sacrificial lamb? Hm, masochist?

RE: another OCP question -- help me guys

2004-01-08 Thread Pete Sharman
Well, so here's the challenge for RMOUG training days - loosening Rachel's lips. Who's gonna join me in this endeavour? :) Pete Controlling developers is like herding cats. Kevin Loney, Oracle DBA Handbook Oh no, it's not. It's much harder than that! Bruce Pihlamae, long-term Oracle DBA

OCP question from Boson practice tests

2004-01-07 Thread Prem Khanna J
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.

another OCP question -- help me guys

2004-01-07 Thread Prem Khanna J
Hi list , sorry to pester you with questions regarding boson OCP questions . i have scheduled for #1Z0-031 exam and so desperately need help from this list . please bear with me for while . look at the 2 questions below . -

Re: another OCP question -- help me guys

2004-01-07 Thread Richard Foote
Hi Prem, Firstly, thank you for bringing back fond memories of when I used to teach this stuff for Oracle. If we ever meet one day, I'll show you my highlighter penned copy of the notes showing the various errors and inaccuracies (except the Performance Tuning course where I highlighted the

Re: another OCP question -- help me guys

2004-01-07 Thread Jonathan Gennick
Hello Prem, The syntax the question gives for DROP TABLESPACE doesn't look right to me. Without looking at the current docsgrin, I believe INCLUDING CONTENTS is a valid option, and that the others are invalid. Thus, answer B, the statement will fail, looks correct. Whoever wrote that test

Re: OCP question from Boson practice tests

2004-01-07 Thread Richard Foote
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

Re: another OCP question -- help me guys

2004-01-07 Thread Rachel Carmichael
Jonathan, I successfully use drop tablespace including contents and datafiles all the time. And a quick check of the docs shows that cascade constraints is valid but, as Richard said, belongs at the end of the statement. As for the second question. DBA_SEGMENTS gives you the total allocated

Re[2]: another OCP question -- help me guys

2004-01-07 Thread Jonathan Gennick
Wednesday, January 7, 2004, 8:29:25 AM, Rachel Carmichael ([EMAIL PROTECTED]) wrote: RC I successfully use drop tablespace including contents and datafiles RC all the time. And a quick check of the docs shows that cascade RC constraints is valid but, as Richard said, belongs at the end of the RC

Re: Re[2]: another OCP question -- help me guys

2004-01-07 Thread Rachel Carmichael
I didn't mean to scold... you post way more information than I usually do! And I answer whilst eating breakfast at times too :) Richard *is* right, the problem is, the sql statement is misformed but the answer key says it will work. Which is yet another reason I dislike the OCP exams. ---

Re[1]: OCP question from Boson practice tests

2004-01-07 Thread Prem Khanna J
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

RE: OCP question from Boson practice tests

2004-01-07 Thread Goulet, Dick
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

Re: Re[2]: another OCP question -- help me guys

2004-01-07 Thread Ryan
A small but growing number of employers want certification. Considering the job market, I recommend anyone who is not at Rachel's, etc.. level to get certified as both a developer and a DBA. I'm doing Java also, just to have it. The java test is a total joke. You only need to get 52% right and its

Re[3]: another OCP question -- help me guys

2004-01-07 Thread Prem Khanna J
Thanx for your reply Gennick. ..and for your word of caution about partitioned tables. Cary , sometime back said that : Cary There are always two answers to a question that your teacher would ask at school . First one is the right answer. Second one is the answer that your teacher

RE: Re[2]: another OCP question -- help me guys

2004-01-07 Thread Stefick Ronald S Contr ESC/HRIDA
Title: RE: Re[2]: another OCP question -- help me guys Uh No one can be at Rachel's level. She's the DBA Goddess -Original Message- From: Ryan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 07, 2004 8:55 AM To: Multiple recipients of list ORACLE-L Subject: Re: Re[2

Re[3]: another OCP question -- help me guys

2004-01-07 Thread Prem Khanna J
Ryan People don't seem to be all that interested in Ryan whether you can actually do the job. Ryan , i would change your first line as Some people don't seem to ... Because some people really DO care about what one can do. Ryan They just assume your better than someone Ryan else if you have

Re: Re[2]: another OCP question -- help me guys

2004-01-07 Thread Rachel Carmichael
Michael Abbey once said (I'm paraphrasing here) the resume and OCP get you in the door. It's your experience that gets you the job and keeps you there We've had numerous discussions on this list about interview questions. I've been on interviews where I spent an entire day (9-4) and talked to 11

Re[2]: OCP question from Boson practice tests

2004-01-07 Thread Jonathan Gennick
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

RE: Re[2]: another OCP question -- help me guys

2004-01-07 Thread Thater, William
Rachel Carmichael scribbled on the wall in glitter crayon: Oh yeah -- how does having a college degree in art history make a person a better DBA? how does my degree, which is in computer science but which is 28 years old, have anything to do with current programming and database work? it

Re: Re[2]: another OCP question -- help me guys

2004-01-07 Thread Ryan
degrees and ocps often do alot more than get you past the HR department. most jobs these days are short term temp jobs. temp companies offer you salary based mainly on your resume. most technical interviews are a joke. I can make more money if I double my experience level and have a computer

Re: Re[2]: another OCP question -- help me guys

2004-01-07 Thread Mladen Gogala
On 01/07/2004 10:19:25 AM, Rachel Carmichael wrote: Oh yeah -- how does having a college degree in art history make a person a better DBA? how does my degree, which is in computer science but which is 28 years old, have anything to do with current programming and database work? Believe it

RE: Re[1]: OCP question from Boson practice tests

2004-01-07 Thread Cary Millsap
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

RE: Re[2]: another OCP question -- help me guys

2004-01-07 Thread Rachel Carmichael
I do understand, and that's why I said that I tried to bring people in first, before HR (as you know) --- Thater, William [EMAIL PROTECTED] wrote: Rachel Carmichael scribbled on the wall in glitter crayon: Oh yeah -- how does having a college degree in art history make a person a better

RE: Re[2]: another OCP question -- help me guys

2004-01-07 Thread Thater, William
Rachel Carmichael scribbled on the wall in glitter crayon: I do understand, and that's why I said that I tried to bring people in first, before HR (as you know) yup, but most places don't have a Goddess on staff.;-) and i'm seeing the requirement for OCP being listed in consulting postings

Re: Re[1]: OCP question from Boson practice tests

2004-01-07 Thread Ryan
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

Re: Re[1]: OCP question from Boson practice tests

2004-01-07 Thread Mladen Gogala
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

RE: Re[1]: OCP question from Boson practice tests

2004-01-07 Thread Rachel Carmichael
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

Re: Re[2]: another OCP question -- help me guys

2004-01-07 Thread Rachel Carmichael
Now I understand their use, I shall immediately go out and hire an art history major as the deparmental sacrifical lamb (and dartboard while we are at it) I'm still a hands-on DBA, although I have some paperwork responsibilities as well. Not management, other than my own work :) Rachel ---

RE: Re[1]: OCP question from Boson practice tests

2004-01-07 Thread Carel-Jan Engel
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

RE: Re[2]: another OCP question -- help me guys

2004-01-07 Thread Loughmiller, Greg
Title: RE: Re[2]: another OCP question -- help me guys brutal, absolutely brutal... Rachel, can ya out-source your sacrificial lamb for our use as well:-) -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 07, 2004 11:54 AM To: Multiple

RE: Re[2]: another OCP question -- help me guys

2004-01-07 Thread Goulet, Dick
Rachel, A few years ago I was offered a job by a defense contractor in the area who was looking for a DBA, but more importantly a DBA with a still active clearance. Well all was well in 90% of that company, except HR. Simple answer, no degree no job. I don't have the degree so they

Re: OCP Question (Perf Tuning)

2004-01-07 Thread Tanel Poder
What I have heard is that all the OCP questions are taken from the Oracle University Student Guide. After all, you wouldn't you expect the class to prepare you? Someone suggested that you think like a computer. Well, for the philosophy behind the exam, think like an organization, namely Oracle

RE: Re[1]: OCP question from Boson practice tests

2004-01-07 Thread Cary Millsap
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,

RE: Re[1]: OCP question from Boson practice tests

2004-01-07 Thread Poras, Henry R.
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

RE: Re[2]: another OCP question -- help me guys

2004-01-07 Thread Poras, Henry R.
what you lose in worth you gain in self-worth. Henry -Original Message- Ryan Sent: Wednesday, January 07, 2004 10:55 AM To: Multiple recipients of list ORACLE-L degrees and ocps often do alot more than get you past the HR department. most jobs these days are short term temp jobs. temp

RE: Re[2]: another OCP question -- help me guys

2004-01-07 Thread Rachel Carmichael
I know it makes no sense... but it has something to do with a (very) antiquated class system and the difference between white-collar workers and blue-collar workers and salary vs hourly wages for the non-US, the term white collar worker refers to office staff, who would wear a white shirt and tie

Re: another OCP question -- help me guys

2004-01-07 Thread bulbultyagi
Hi list , sorry to pester you with questions regarding boson OCP questions . i have scheduled for #1Z0-031 exam and so desperately need help from this list . please bear with me for while . look at the 2 questions below . Don't apologize Prem, who else are you gonna call, ghostbusters? :)

Re: OCP question from Boson practice tests

2004-01-07 Thread bulbultyagi
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

Re: Re[1]: OCP question from Boson practice tests

2004-01-07 Thread Ryan
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

Re: Re[2]: OCP Question (Perf Tuning)

2004-01-07 Thread Tanel Poder
Btw, why do you want to take an errorstack on a behaviour-changing event? Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 11:24 PM Oracle doesn't but Jonathan Lewis does, in his Tutorials. I found out about that

RE: Re[2]: another OCP question -- help me guys

2004-01-07 Thread Niall Litchfield
Rachel writes Now I understand their use, I shall immediately go out and hire an art history major as the deparmental sacrifical lamb (and dartboard while we are at it) Hey I have an *economics* degree, *and* am a part-qualified accountant. I claim that sacrificial lamb position as my own.

RE: Re[2]: another OCP question -- help me guys

2004-01-07 Thread Rachel Carmichael
you leave me such straight lines :) which part is qualified as an accountant? you volunteer to be the sacrificial lamb? Hm, masochist? Before Jared tries to send everyone over to my list on this topic, I'll try to bring it at least slightly back on topic. I really don't care if someone has

RE: Re[1]: OCP question from Boson practice tests

2004-01-07 Thread Niall Litchfield
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

RE: Re[1]: OCP question from Boson practice tests

2004-01-07 Thread Jared Still
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

RE: another OCP question -- help me guys

2004-01-07 Thread Naveen, Nahata (IE10)
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 11:45 PM To: Multiple recipients of list ORACLE-L Subject: Re: another OCP question -- help me guys Hi list , sorry to pester you with questions regarding boson OCP

OCP Question (Perf Tuning)

2004-01-06 Thread Jay Wade
Hello: I was looking through some OCP questions posted on the web and came across the one below. I believe the answer is (D), because the join type would be dependent on the number of rows within the table. Is this correct or does the OPTIMIZER_MODE set to FIRST_ROWS alter this behavior? The

Re: OCP Question (Perf Tuning)

2004-01-06 Thread Ryan
D is probably the answer, but most of the time oracle will choose nested loop. Beware the OCP tuning test. It is completely and totally inaccurate. I emailed the author of the Sybex tuning book and he agreed with me. He said he wrote the book to the test and knows its garbage. - Original

Re: OCP Question (Perf Tuning)

2004-01-06 Thread Mladen Gogala
Nope. The answer is b). In the FIRST_ROWS mode, optimizer prefers NL to all other methos despite the price. On 2004.01.06 13:44, Jay Wade wrote: Hello: I was looking through some OCP questions posted on the web and came across the one below. I believe the answer is (D), because the join

Re[2]: OCP Question (Perf Tuning)

2004-01-06 Thread Jonathan Gennick
Tuesday, January 6, 2004, 1:59:26 PM, Mladen Gogala ([EMAIL PROTECTED]) wrote: MG Nope. The answer is b). In the FIRST_ROWS mode, optimizer prefers NL to all other MG methos despite the price. Does Oracle themselves *document* that what you say is the case? I believe you, but I'm not sure that

Re: OCP Question (Perf Tuning)

2004-01-06 Thread Ryan
thought so, I'm not 100% certain the OCP will say that though. alot of inaccuracies in that test. btw, Ive been playing with first_rows lately. I've noticed that it has a preference for 'INDEX FULL SCAN' over 'INDEX RANGE SCAN'. Ive found that in some test cases where you have two tables

RE: OCP Question (Perf Tuning)

2004-01-06 Thread Stephen.Lee
Think like a computer. Which execution plan will be the result? result of what? an insert statement? -- 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

Re: OCP Question (Perf Tuning)

2004-01-06 Thread Jonathan Lewis
Note in-line. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see

RE: OCP Question (Perf Tuning)

2004-01-06 Thread Paula_Stankus
FIRST_ROWS would alter the behavior regardless of the number of rows. -Original Message- Jay Wade Sent: Tuesday, January 06, 2004 1:44 PM To: Multiple recipients of list ORACLE-L Hello: I was looking through some OCP questions posted on the web and came across the one below. I

RE: OCP Question (Perf Tuning)

2004-01-06 Thread DENNIS WILLIAMS
What I have heard is that all the OCP questions are taken from the Oracle University Student Guide. After all, you wouldn't you expect the class to prepare you? Someone suggested that you think like a computer. Well, for the philosophy behind the exam, think like an organization, namely Oracle

Re: OCP Question (Perf Tuning)

2004-01-06 Thread Mladen Gogala
Jonathan, you're right. Interesting thing is that bitmap indexes, which were made for DW processing and not for OLTP will also be considered for NL context in First_Rows mode. Here is the proof, which also proves that I'm a lousy typist: SQL set autorace on explain SP2-0158: unknown SET option

RE: OCP Question (Perf Tuning)

2004-01-06 Thread Stephen.Lee
What I meant is that the question cannot be answered without making human assumptions about the question itself. It is a little difficult (Note little not lot) to believe that such a poorly written question would appear on a test that costs money to take. -Original Message- Someone

Re: Re[2]: OCP Question (Perf Tuning)

2004-01-06 Thread Mladen Gogala
Oracle doesn't but Jonathan Lewis does, in his Tutorials. I found out about that from Scott Gosset in 8i internals class in NYC. Seems still to be true. Gospel of Jonathan should suffice, however. I just discovered that my 10053 trace name errorstack forever, level 12 causes ORA-600 in 9.2. Let

Re: OCP Question (Perf Tuning)

2004-01-06 Thread Jay Wade
recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: OCP Question (Perf Tuning) Date: Tue, 06 Jan 2004 11:34:26 -0800 thought so, I'm not 100% certain the OCP will say that though. alot of inaccuracies in that test. btw, Ive been playing with first_rows lately. I've noticed that it has a preference

RE: OCP Question (Perf Tuning)

2004-01-06 Thread Niall Litchfield
Jonathan noted that Nope. The answer is b). In the FIRST_ROWS mode, optimizer prefers NL to all other methos despite the price. Unless the alternative is a full tablescan on the inner table - in which case merge or hash joins can be considered. For some reason hash joins were

Re: OCP Question (Perf Tuning)

2004-01-06 Thread Jonathan Lewis
I see you're running on Oracle 9 there, and that can make a big difference. After posting my hypothesis, I created a test case, which behaved as I had predicted - but the behaviour changed in Oracle 9, and I had to do some tweaking. Turns out my test case highlighted what looks like a but in

Re: OCP Question (Perf Tuning)

2004-01-06 Thread Jonathan Lewis
A bigger error in option (d) is that it leaves open the ambiguity of whether the rows should, or should not, be part of the answer to the join. Oracle's choice of join could be affected by adding 100 rows to the table that should be included in the join, but remain unchanged if you add

Re: Re[2]: OCP Question (Perf Tuning)

2004-01-06 Thread Jay Wade
Thanks again for all your help. Does the ALL_ROWS hint force a preference in Join Types as well? If so would it try to force a HASH JOIN? From: Mladen Gogala [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Re[2]: OCP Question

Re: Re[2]: OCP Question (Perf Tuning)

2004-01-06 Thread Mladen Gogala
PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Re[2]: OCP Question (Perf Tuning) Date: Tue, 06 Jan 2004 13:24:25 -0800 Oracle doesn't but Jonathan Lewis does, in his Tutorials. I found out about that from Scott Gosset in 8i internals class in NYC. Seems

RE: OCP Question

2003-08-14 Thread Mercadante, Thomas F
Jay, I would guess B and E. I see no reason for a redo-log switch. Looks like a trick question. B is one correct answer. The other correct is either E or A. I would go for E. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, August 05, 2003 11:59 AM

OCP Question

2003-08-14 Thread Jay Wade
Hello: I was going through some OCP questions and wanted to make sure that my answers where correct. This question comes from a 3rd party testing site, I have been checking each question against my study guides to make sure they are correct. I've done some testing and think that my answers

RE: 9i-OCP Question

2003-08-14 Thread Ron Thomas
: [EMAIL PROTECTED]Subject: RE: 9i-OCP Question .com

RE: 9i-OCP Question

2003-08-14 Thread Gudmundur Bjarni Josepsson
Title: Message The silliest questions I remember seeing in an OCP exam were the questions in the Oracle8 Networking exam which asked about the sequence of dialog boxes in the Network Configuration Assistant! I took the 8i OCP upgrade exam this weekend. I was amazed at one question. It

RE: 9i-OCP Question

2003-08-14 Thread Stephen Lee
There is scientific research that shows that moderate consumption of alcohol while learning and while testing improves scores. NOW you have a good excuse! -Original Message- In high school, I took the SAT exams and got a great score, enough to be satisfied with. My guidance

Re: 9i-OCP Question

2003-08-04 Thread Tim Gorman
Experience with various flavors of storage technology plus a decade of DBA experience can't possibly prepare me for what I haven't read (i.e. Oracle's recommendations). In a multiple-choice test format, unlike real life, I can't possibly argue with what Oracle has recommended... No wonder I

Re: 9i-OCP Question

2003-08-04 Thread Tim Gorman
Unless ordering superannuated storage from eBay, disks are sized at either 36Gb, 73Gb, or larger. Dedicating these devices to online redo log files of size 100Mb, 500Mb, or 1Gb might be tough to get past the CFO. The CIO/CTO might well also ask why some form of RAID-1 or RAID-5 redundancy is not

RE: 9i-OCP Question

2003-08-04 Thread Stephen Lee
An invaluable aid for test taking is -- I learned this when I took Organic Chemistry -- bourbon in water with ice in your favorite convenience drink cup. Everyone at the test site is sure you have a soft drink. -Original Message- Experience with various flavors of storage technology

Re: 9i-OCP Question

2003-08-04 Thread M.Godlewski
I took the 8i OCP upgrade exam this weekend. I was amazed at one question. It was asking about the OUI andinstalling third party software. Now I've been an Oracle DBA for many years, and I would have thought Oracle would be more concerned about the Oracle database and the way it works rather then

RE: 9i-OCP Question

2003-08-04 Thread Eberhard, Jeff
Perhaps it is a question which doesn't get scored (hopefully). I'm not sure if all the tests are like this but I took the 9i upgrade exam last week. It had 60 questions but only scores on 53 of them (it tosses out 7). Unfortunately you don't know which questions will be scored or not. --Jeff

Re: 9i-OCP Question

2003-08-04 Thread Tim Gorman
In high school, I took the SAT exams and got a great score, enough to be satisfied with. My guidance counselor insisted I gild the lily and take the exams again. I showed up that morning with no sleep, a throbbing hangover, and eyes looking like fried eggs pasted to my head... ...scored 60

Re: 9i-OCP Question

2003-08-01 Thread Jonathan Gennick
Wednesday, July 30, 2003, 1:19:31 PM, you wrote: Q If you have 2 redo log groups with 4 members each, how many disks does SK Oracle recommend SKto keep the redo log files? My first thought was 8, and I think you might be able to make a case for 8. However, you should have at least 4, because

RE: 9i-OCP Question

2003-07-31 Thread Boivin, Patrice J
We use a SAN. Where does that leave me? : ) Patrice. -Original Message- Sent: Wednesday, July 30, 2003 7:10 PM To: Multiple recipients of list ORACLE-L I'm constantly amazed (and relieved!) that there's disagreement on the most fundamental principles. First, I found myself nodding

RE: 9i-OCP Question

2003-07-31 Thread Boivin, Patrice J
I am wondering... where do these questions come from? There is a disclosure agreement at the beginning of each Oracle exam... Patrice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services--

RE: 9i-OCP Question

2003-07-31 Thread Senthil Kumar
Hi This ques from a model examnothing to worry about disclosure and all!!! -Original Message- Boivin, Patrice J Sent: Thursday, July 31, 2003 6:24 PM To: Multiple recipients of list ORACLE-L I am wondering... where do these questions come from? There is a disclosure agreement

RE: 9i-OCP Question

2003-07-31 Thread April Wells
Title: RE: 9i-OCP Question didn't you say it was a question/answer out of the book? April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message- From: Senthil Kumar

RE: 9i-OCP Question

2003-07-31 Thread Jared Still
Our Prod SAP system has 4 RAID1's dedicated to redo of 500m each on an Clariion CX600 SAN. Several groups with 2 members each. That's 600 gig of physical disk dedicated to redo, and nothing else. Jared On Thu, 2003-07-31 at 04:59, Boivin, Patrice J wrote: We use a SAN. Where does that

RE: 9i-OCP Question

2003-07-31 Thread Jacques Kilchoer
Except that: 1) five disks was not one of the possible answers, and 2) we don't know that the database is in archivelog mode. For the 9i OCP examination the correct answer is answer number 4 (4 disks). I'm willing to bet on it! -Original Message- From: Ron Yount [mailto:[EMAIL

9i-OCP Question

2003-07-30 Thread Senthil Kumar
Hi all, What is the correct answer for this? Q If you have 2 redo log groups with 4 members each, how many disks does Oracle recommend to keep the redo log files? 1. 8 2. 2 3. 1 4. 4 Which is the correct answer. TIA Senthil -- Please see the official ORACLE-L FAQ: http://www.orafaq.net

Re: 9i-OCP Question

2003-07-30 Thread Mladen Gogala
The answer is 4. Of course, no one in the right mind would have 2 groups with 4 members each. On 2003.07.30 13:19, Senthil Kumar wrote: Hi all, What is the correct answer for this? Q If you have 2 redo log groups with 4 members each, how many disks does Oracle recommend to keep the redo log

Re: 9i-OCP Question

2003-07-30 Thread Kirtikumar Deshpande
I will guess -- 1. - Kirti --- Senthil Kumar [EMAIL PROTECTED] wrote: Hi all, What is the correct answer for this? Q If you have 2 redo log groups with 4 members each, how many disks does Oracle recommend to keep the redo log files? 1. 8 2. 2 3. 1 4. 4 Which is the

Re: 9i-OCP Question

2003-07-30 Thread KENNETH JANUSZ
Why? What is the logic? Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 12:29 PM The answer is 4. Of course, no one in the right mind would have 2 groups with 4 members each. On 2003.07.30 13:19,

Re: 9i-OCP Question

2003-07-30 Thread rgaffuri
according to the 8i osborne ocp book, the answer is 2. From: Senthil Kumar [EMAIL PROTECTED] Date: 2003/07/30 Wed PM 01:19:31 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: 9i-OCP Question Hi all, What is the correct answer for this? Q If you have 2 redo

Re: 9i-OCP Question

2003-07-30 Thread Mladen Gogala
So, what do you need us for? On 2003.07.30 13:29, [EMAIL PROTECTED] wrote: according to the 8i osborne ocp book, the answer is 2. From: Senthil Kumar [EMAIL PROTECTED] Date: 2003/07/30 Wed PM 01:19:31 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: 9i-OCP Question

Re: 9i-OCP Question

2003-07-30 Thread AK
Answe is 4 disks . to keep each member on different disks . -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 10:19 AM Hi all, What is the correct answer for this? Q If you have 2 redo log groups with 4 members

  1   2   >