RE: another OCP question -- help me guys
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 ticket if I can... -- Gilwell song [EMAIL PROTECTED] God is subtle but he is not malicious. - Albert Einstein -- 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).
RE: Re[2]: another OCP question -- help me guys
-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 nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra 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: another OCP question -- help me guys
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 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: another OCP question -- help me guys
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 bring it at least slightly back on topic. I really don't care if someone has a degree or has completed the OCP exams. I want to see what they have done in practice, or if they are interviewing for a truly junior position, I want to know how they learn, what they've played with on their own. Two of the smartest men I have ever known never finished college. --- Niall Litchfield [EMAIL PROTECTED] wrote: 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. Nothing so useful as Art in my background, just graphs with the axes befuddled. Niall P.S. I can work powerpoint too. -- 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). __ 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: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= 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: another OCP question -- help me guys
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? 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 a degree or has completed the OCP exams. I want to see what they have done in practice, or if they are interviewing for a truly junior position, I want to know how they learn, what they've played with on their own. Two of the smartest men I have ever known never finished college. __ 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: another OCP question -- help me guys
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 -Original Message- Sent: Friday, 9 January 2004 1:09 PM To: Multiple recipients of list ORACLE-L my lips are sealed... G --- Mogens_Nrgaard [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? 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 a degree or has completed the OCP exams. I want to see what they have done in practice, or if they are interviewing for a truly junior position, I want to know how they learn, what they've played with on their own. Two of the smartest men I have ever known never finished college. __ 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman 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).
another OCP question -- help me guys
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 . - QUESTION #1 what happens when you issue the command below . drop tablespace testtbs including contents cascade constraints and datafiles; A.the tablespace will be dropped , constraints will be droppped and the datafiles will be taken out of the o/s. B. statement will fail C.you must drop constraints before issuing this command. this is what happens when i try on 9.2.0.4 : ERROR at line 1: ORA-02173: invalid option for DROP TABLESPACE but boson's choice is A. i wonder how ??? - QUESTION #2 you need to determine how much space has been allocated for a table. which view would give you this information ? A. dba_extents B. dba_ts_quotas C. dba_segments my choice is C . but boson's choice is A . it says other views cannot give the required details . a metalink doc says that dba_segments.blocks gives the total number of blocks allocated to the table. what will be the choice that you would go for ? - so now i have the question whether boson is reliable ? how many in this list have used it ? or am i missing something : (( 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: another OCP question -- help me guys
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 correct bits ;) Just a personal opinion (don't get me started on OCP) but if I were going for a certification classifying me as a Professional, I would like to display a greater air of confidence in that I know what all this stuff actually means. I mean once you get the certificate, you'll actually be expected to know how to tune a temp tablespace, drop a tablespace, etc, right ... You're heading in the right direction by questioning these questions but knowing the answers to questions is not the same as being able to solve real-life problems which should be the mandatory skill of any so-called certified professional. I guess I'm suggesting that before you pin on the certification badge, you should have the skills to determine the correct answers to these questions yourself. Now you've gone and got me started on OCP, but hopefully you know what I mean. Question 1) Answer B - Statement will fail. You actually proven this yourself and yet you still have doubts? Trust what you *see*, not what you *read*. The cascade constraints clause if used must go at the end of the statement. Question 2) Answer A and C. Again, a simple query or describe of these views would do the trick. I think we can safely say that Boson (whatever he/she/it is) is not a very reliable source ... Good luck with your OCP Richard - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 9:24 PM 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 . - QUESTION #1 what happens when you issue the command below . drop tablespace testtbs including contents cascade constraints and datafiles; A.the tablespace will be dropped , constraints will be droppped and the datafiles will be taken out of the o/s. B. statement will fail C.you must drop constraints before issuing this command. this is what happens when i try on 9.2.0.4 : ERROR at line 1: ORA-02173: invalid option for DROP TABLESPACE but boson's choice is A. i wonder how ??? - QUESTION #2 you need to determine how much space has been allocated for a table. which view would give you this information ? A. dba_extents B. dba_ts_quotas C. dba_segments my choice is C . but boson's choice is A . it says other views cannot give the required details . a metalink doc says that dba_segments.blocks gives the total number of blocks allocated to the table. what will be the choice that you would go for ? - so now i have the question whether boson is reliable ? how many in this list have used it ? or am i missing something : (( 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: another OCP question -- help me guys
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 question does not appear to have tested their test. As for question 2, until you asked, I too would have looked in DBA_EXTENTS. But as I look at one table in my database, I see that DBA_SEGMENTS.BLOCKS reports the same value as DBA_EXTENTS.BLOCKS. It may be that DBA_SEGMENTS reports on SUM(BLOCKS) for all extents in each segment. Interesting. I'll have to read the docs on this, to find out for certain what's going on. One thing to be aware of with respect to question 2 below is that in a partitioned table, each partition is a segment. Thus, whether you go to DBA_EXTENTS or DBA_SEGMENTS, you do need to be sure to consider all partitions of the table in question. 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. Wednesday, January 7, 2004, 6:24:24 AM, Prem Khanna J ([EMAIL PROTECTED]) wrote: PKJ Hi list , sorry to pester you with questions regarding PKJ boson OCP questions . i have scheduled for #1Z0-031 exam PKJ and so desperately need help from this list . PKJ please bear with me for while . look at the 2 questions below . PKJ - PKJ QUESTION #1 PKJ what happens when you issue the command below . PKJ drop tablespace testtbs including contents cascade constraints and PKJ datafiles; PKJ A.the tablespace will be dropped , constraints will be droppped and the PKJ datafiles will be taken out of the o/s. PKJ B. statement will fail PKJ C.you must drop constraints before issuing this command. PKJ this is what happens when i try on 9.2.0.4 : PKJ ERROR at line 1: ORA-02173: invalid option for DROP TABLESPACE PKJ but boson's choice is A. i wonder how ??? PKJ - PKJ QUESTION #2 PKJ you need to determine how much space has been allocated for a table. PKJ which view would give you this information ? PKJ A. dba_extents PKJ B. dba_ts_quotas PKJ C. dba_segments PKJ my choice is C . PKJ but boson's choice is A . it says other views cannot give PKJ the required details . PKJ a metalink doc says that dba_segments.blocks gives the PKJ total number of blocks allocated to the table. PKJ what will be the choice that you would go for ? PKJ - PKJ so now i have the question whether boson is reliable ? PKJ how many in this list have used it ? PKJ or am i missing something : (( PKJ Regards, PKJ Prem. PKJ -- PKJ Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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: another OCP question -- help me guys
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 blocks in a single select, without aggregation. To use DBA_EXTENTS you'd have to use sum(blocks) in the select. From prior experience with OCP exams, they tend to go for the simplest way to get an answer. So DBA_SEGMENTS is the correct answer in their view, although you *can* get the same information from DBA_EXTENTS. --- Jonathan Gennick [EMAIL PROTECTED] wrote: 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 question does not appear to have tested their test. As for question 2, until you asked, I too would have looked in DBA_EXTENTS. But as I look at one table in my database, I see that DBA_SEGMENTS.BLOCKS reports the same value as DBA_EXTENTS.BLOCKS. It may be that DBA_SEGMENTS reports on SUM(BLOCKS) for all extents in each segment. Interesting. I'll have to read the docs on this, to find out for certain what's going on. One thing to be aware of with respect to question 2 below is that in a partitioned table, each partition is a segment. Thus, whether you go to DBA_EXTENTS or DBA_SEGMENTS, you do need to be sure to consider all partitions of the table in question. 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. Wednesday, January 7, 2004, 6:24:24 AM, Prem Khanna J ([EMAIL PROTECTED]) wrote: PKJ Hi list , sorry to pester you with questions regarding PKJ boson OCP questions . i have scheduled for #1Z0-031 exam PKJ and so desperately need help from this list . PKJ please bear with me for while . look at the 2 questions below . PKJ - PKJ QUESTION #1 PKJ what happens when you issue the command below . PKJ drop tablespace testtbs including contents cascade constraints and PKJ datafiles; PKJ A.the tablespace will be dropped , constraints will be droppped and the PKJ datafiles will be taken out of the o/s. PKJ B. statement will fail PKJ C.you must drop constraints before issuing this command. PKJ this is what happens when i try on 9.2.0.4 : PKJ ERROR at line 1: ORA-02173: invalid option for DROP TABLESPACE PKJ but boson's choice is A. i wonder how ??? PKJ - PKJ QUESTION #2 PKJ you need to determine how much space has been allocated for a table. PKJ which view would give you this information ? PKJ A. dba_extents PKJ B. dba_ts_quotas PKJ C. dba_segments PKJ my choice is C . PKJ but boson's choice is A . it says other views cannot give PKJ the required details . PKJ a metalink doc says that dba_segments.blocks gives the PKJ total number of blocks allocated to the table. PKJ what will be the choice that you would go for ? PKJ - PKJ so now i have the question whether boson is reliable ? PKJ how many in this list have used it ? PKJ or am i missing something : (( PKJ Regards, PKJ Prem. PKJ -- PKJ Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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). __ 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
Re[2]: another OCP question -- help me guys
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 statement. I stand corrected, though I did admit up front to not having checked the manual. I was eating breakfast at the time, so forgive me that one lapse. I liked Richard's point about trusting what you see. He was spot on with that comment, at least in this context. 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[2]: another OCP question -- help me guys
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. --- Jonathan Gennick [EMAIL PROTECTED] wrote: 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 statement. I stand corrected, though I did admit up front to not having checked the manual. I was eating breakfast at the time, so forgive me that one lapse. I liked Richard's point about trusting what you see. He was spot on with that comment, at least in this context. 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). __ 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[2]: another OCP question -- help me guys
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 just one test, but people want it. You really don't even need to know java. Just object-oriented programming and memorize a bunch of fairly useless information. Getting a good salary is more about your resume and how well you speak than it is about your skill set. I've had alot of technical interviews and they all seem to ask the same easy questions. They are interested in: years of experience, degree, where your degree is from, certification, and in some cases where you worked before. There is some bias in the DC area for 'top 5' consulting. I think that means Booz Allen, and Ernst and Young. Not sure who the other 3 happen to be. People don't seem to be all that interested in whether you can actually do the job. They just assume your better than someone else if you have a nicer resume. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 9:34 AM 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. --- Jonathan Gennick [EMAIL PROTECTED] wrote: 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 statement. I stand corrected, though I did admit up front to not having checked the manual. I was eating breakfast at the time, so forgive me that one lapse. I liked Richard's point about trusting what you see. He was spot on with that comment, at least in this context. 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). __ 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). -- 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[3]: another OCP question -- help me guys
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 would expect. /Cary The second answer is the one i mostly fail to find. 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: Re[2]: another OCP question -- help me guys
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]: another OCP question -- help me guys 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 just one test, but people want it. You really don't even need to know java. Just object-oriented programming and memorize a bunch of fairly useless information. Getting a good salary is more about your resume and how well you speak than it is about your skill set. I've had alot of technical interviews and they all seem to ask the same easy questions. They are interested in: years of experience, degree, where your degree is from, certification, and in some cases where you worked before. There is some bias in the DC area for 'top 5' consulting. I think that means Booz Allen, and Ernst and Young. Not sure who the other 3 happen to be. People don't seem to be all that interested in whether you can actually do the job. They just assume your better than someone else if you have a nicer resume. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 9:34 AM 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. --- Jonathan Gennick [EMAIL PROTECTED] wrote: 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 RC of the RC statement. I stand corrected, though I did admit up front to not having checked the manual. I was eating breakfast at the time, so forgive me that one lapse. I liked Richard's point about trusting what you see. He was spot on with that comment, at least in this context. 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). __ 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). -- 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
Re[3]: another OCP question -- help me guys
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 a nicer resume. I agree . Because resume is the mirror which reflects an individual until the interview happens . 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: Re[2]: another OCP question -- help me guys
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 different people, both non-technical questions and technical ones in and out of my area of expertise. and this was AFTER a 90 minute phone technical interview. I've been on interviews where there was no DBA on site, so the technical aspect of the interview was more an informal consulting session (how would you handle this problem, when I could tell it was one they were currently having) I'm not interested in how much you've memorized. Or how well you take standardized tests. I do ask questions that pertain to skill set and creative thinking. Unfortunately these days, personnel departments do the initial screening and they use a keyword search on college degree and OCP. Wherever possible, I try to do the initial search and interview myself and THEN pass a candidate along to HR. That way I can at least argue for someone really good, even if their resume doesn't hit the keywords. 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? And while we definitely need people who know a little about everything (the primary care physician as it were) we still need experts in specialized areas. I wouldn't necessarily urge people to study lots and lots of things, that usually ends up meaning they do none of them well. Okay, can you tell you poked one of my pet peeves? Off the soapbox for now :) my $0.02, for what it's worth (which is less and less these days!) Rachel --- Ryan [EMAIL PROTECTED] wrote: 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 just one test, but people want it. You really don't even need to know java. Just object-oriented programming and memorize a bunch of fairly useless information. Getting a good salary is more about your resume and how well you speak than it is about your skill set. I've had alot of technical interviews and they all seem to ask the same easy questions. They are interested in: years of experience, degree, where your degree is from, certification, and in some cases where you worked before. There is some bias in the DC area for 'top 5' consulting. I think that means Booz Allen, and Ernst and Young. Not sure who the other 3 happen to be. People don't seem to be all that interested in whether you can actually do the job. They just assume your better than someone else if you have a nicer resume. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 9:34 AM 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. __ 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[2]: another OCP question -- help me guys
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 gets you past the HR department so you actually get to talk to someone. trust me, i know all about this one having neither a degree or an OCP. and having lost jobs to those art history degree holders. [and yes i have been asked to go back to those same places as a consultant to fix the mess. and no i didn't.] -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] You see, wire telegraph is a kind of a very, very long cat. You pull his tail in New York and his head is meowing in Los Angeles. Do you understand this? And radio operates exactly the same way: you send signals here, they receive them there. The only difference is that there is no cat. - Albert Einstein, when asked to describe radio -- 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).
Re: Re[2]: another OCP question -- help me guys
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 science degree from harvard, while at the same time halving my skillset and performance. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 10:29 AM 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 gets you past the HR department so you actually get to talk to someone. trust me, i know all about this one having neither a degree or an OCP. and having lost jobs to those art history degree holders. [and yes i have been asked to go back to those same places as a consultant to fix the mess. and no i didn't.] -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] You see, wire telegraph is a kind of a very, very long cat. You pull his tail in New York and his head is meowing in Los Angeles. Do you understand this? And radio operates exactly the same way: you send signals here, they receive them there. The only difference is that there is no cat. - Albert Einstein, when asked to describe radio -- 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). -- 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[2]: another OCP question -- help me guys
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 or not, a college degree in art history really does help in two ways. First, people exposed to sufficient quantity of art tend to be nobler and more spiritual, according to the popular beliefs, then cynical mathematicians and computer geeks like me. Being noble and spiritual means that they don't fight back but do as they're told which makes them into good corporate drones. Art history is like an army boot camp for wannabe geeks. Their appearance also tends to be much more pleasant and polished then an appearance of a hard core computer geek. Second, art history majors make perfect sacrificial lambs. An art history major in IT department can be blamed for anything from bad weather, corrupt backup tape to stupid application design. My understanding is that you've moved to the management, which is the move that I admire and respect. As a manager, you should know the value of a sacrificial lamb that can be blamed for anything. If you want to make the next step in your career, the step from management to damagement, you'll have to learn how to play the blame shifting game. Art history majors are priceless for that. -- 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[2]: another OCP question -- help me guys
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 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 gets you past the HR department so you actually get to talk to someone. trust me, i know all about this one having neither a degree or an OCP. and having lost jobs to those art history degree holders. [and yes i have been asked to go back to those same places as a consultant to fix the mess. and no i didn't.] -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] You see, wire telegraph is a kind of a very, very long cat. You pull his tail in New York and his head is meowing in Los Angeles. Do you understand this? And radio operates exactly the same way: you send signals here, they receive them there. The only difference is that there is no cat. - Albert Einstein, when asked to describe radio -- 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). __ 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[2]: another OCP question -- help me guys
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 now. but then many of those job requirements are generated by a company's HR and then sent out by the consulting firms. and less and less of them are mentioning experience. now there's and interesting trend, we don't care how long or even if you've done the job, just if you have a degree or an OCP. -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] The point is to develop the childlike inclination for play and the childlike desire for recognition and to guide the child over to important fields for society. Such a school demands from the teacher that he be a kind of artist in his province. - Albert Einstein -- 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).
Re: Re[2]: another OCP question -- help me guys
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 --- Mladen Gogala [EMAIL PROTECTED] wrote: 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 or not, a college degree in art history really does help in two ways. First, people exposed to sufficient quantity of art tend to be nobler and more spiritual, according to the popular beliefs, then cynical mathematicians and computer geeks like me. Being noble and spiritual means that they don't fight back but do as they're told which makes them into good corporate drones. Art history is like an army boot camp for wannabe geeks. Their appearance also tends to be much more pleasant and polished then an appearance of a hard core computer geek. Second, art history majors make perfect sacrificial lambs. An art history major in IT department can be blamed for anything from bad weather, corrupt backup tape to stupid application design. My understanding is that you've moved to the management, which is the move that I admire and respect. As a manager, you should know the value of a sacrificial lamb that can be blamed for anything. If you want to make the next step in your career, the step from management to damagement, you'll have to learn how to play the blame shifting game. Art history majors are priceless for that. -- 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). __ 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[2]: another OCP question -- help me guys
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 recipients of list ORACLE-L Subject: Re: Re[2]: another OCP question -- help me guys 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 --- Mladen Gogala [EMAIL PROTECTED] wrote: 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 or not, a college degree in art history really does help in two ways. First, people exposed to sufficient quantity of art tend to be nobler and more spiritual, according to the popular beliefs, then cynical mathematicians and computer geeks like me. Being noble and spiritual means that they don't fight back but do as they're told which makes them into good corporate drones. Art history is like an army boot camp for wannabe geeks. Their appearance also tends to be much more pleasant and polished then an appearance of a hard core computer geek. Second, art history majors make perfect sacrificial lambs. An art history major in IT department can be blamed for anything from bad weather, corrupt backup tape to stupid application design. My understanding is that you've moved to the management, which is the move that I admire and respect. As a manager, you should know the value of a sacrificial lamb that can be blamed for anything. If you want to make the next step in your career, the step from management to damagement, you'll have to learn how to play the blame shifting game. Art history majors are priceless for that. -- 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). __ 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[2]: another OCP question -- help me guys
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 absolutely would not let the paperwork through, end of conversation. So yes it does matter even when it makes no sense. BTW: they did fill the job a year later with a person who had a degree in English believe it or not. Her clearance was inactive not current as well. Guess it's better than no clearance. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, January 07, 2004 10:29 AM To: Multiple recipients of list ORACLE-L 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 gets you past the HR department so you actually get to talk to someone. trust me, i know all about this one having neither a degree or an OCP. and having lost jobs to those art history degree holders. [and yes i have been asked to go back to those same places as a consultant to fix the mess. and no i didn't.] -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] You see, wire telegraph is a kind of a very, very long cat. You pull his tail in New York and his head is meowing in Los Angeles. Do you understand this? And radio operates exactly the same way: you send signals here, they receive them there. The only difference is that there is no cat. - Albert Einstein, when asked to describe radio -- 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). -- 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: Re[2]: another OCP question -- help me guys
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 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 science degree from harvard, while at the same time halving my skillset and performance. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 10:29 AM 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 gets you past the HR department so you actually get to talk to someone. trust me, i know all about this one having neither a degree or an OCP. and having lost jobs to those art history degree holders. [and yes i have been asked to go back to those same places as a consultant to fix the mess. and no i didn't.] -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] You see, wire telegraph is a kind of a very, very long cat. You pull his tail in New York and his head is meowing in Los Angeles. Do you understand this? And radio operates exactly the same way: you send signals here, they receive them there. The only difference is that there is no cat. - Albert Einstein, when asked to describe radio -- 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). -- 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). -- 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: Re[2]: another OCP question -- help me guys
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 to the office. While blue collar refers to the people who get their hands dirty, wearing blue denim shirts. Always amused me that the IBM field staff had to wear white shirts and ties while working on machinery that had grease and carbon etc all over it. --- Goulet, Dick [EMAIL PROTECTED] wrote: 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 absolutely would not let the paperwork through, end of conversation. So yes it does matter even when it makes no sense. BTW: they did fill the job a year later with a person who had a degree in English believe it or not. Her clearance was inactive not current as well. Guess it's better than no clearance. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, January 07, 2004 10:29 AM To: Multiple recipients of list ORACLE-L 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 gets you past the HR department so you actually get to talk to someone. trust me, i know all about this one having neither a degree or an OCP. and having lost jobs to those art history degree holders. [and yes i have been asked to go back to those same places as a consultant to fix the mess. and no i didn't.] -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] You see, wire telegraph is a kind of a very, very long cat. You pull his tail in New York and his head is meowing in Los Angeles. Do you understand this? And radio operates exactly the same way: you send signals here, they receive them there. The only difference is that there is no cat. - Albert Einstein, when asked to describe radio -- 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). -- 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). __ 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: another OCP question -- help me guys
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? :) - QUESTION #1 what happens when you issue the command below . drop tablespace testtbs including contents cascade constraints and datafiles; but boson's choice is A. i wonder how ??? Statement is incorrect, cascade constraints is placed in the end. Fine that explains that boson is wrong. But if you want to prepare for ocp then , you must also consider the possibility that a novice like me was sitting at boson preparing these questions. So the next time you come across a question whose answer doesn't match yours do the following in the order specified: 1. Assume boson is right and recheck your answer. Try it out on a test database. (make sure you get the conditions of the question correctly implemented). See the docs. 2. Assume boson is right and read the solution /explanation for the answer, then tally it with your answer and solution. 3. Still not happy ? Assume boson is right and re-read the question, there may be one word or a comma or a full stop or a bracket ,etc that is completly changing the meaning of the question but you may skipped it when reading the question. (It happens a lot to me, but then I am dumb :). Now tally your answer with boson 4. Still not happy ? (there is no pleasing you, is there? :) ok now you can do two things: 4a. The question and the solution given by boson are blatantly wrong (because of a typo or because I had set the question paper ) AND YOU ARE ABLE TO COMPLETLY REASON OUT out what is so wrong about the question and answer, what should it have been, what if that part of the question was changed so , etc etc, ; then correct the question and answer and move onto the next one. 4b The question is still blatantly wrong but you have a nagging doubt, then ask around . There may be some obscure formula (which works only in OCP exams) or the answer may be the least of all the evils given . Either which way time to mug it up Now keeping in mind these policies, have another look at the two questions you have given above and below. - QUESTION #2 you need to determine how much space has been allocated for a table. which view would give you this information ? A. dba_extents B. dba_ts_quotas C. dba_segments my choice is C . but boson's choice is A . it says other views cannot give the required details . a metalink doc says that dba_segments.blocks gives the total number of blocks allocated to the table. what will be the choice that you would go for ? - Both A and C are right. What will really boggle your mind is deciding what to say if you get the exact same question in the ocp exam and you have to make a single choice. But relax ocp exams are not as troublesome, they are much more professionally prepared. so now i have the question whether boson is reliable ? how many in this list have used it ? or am i missing something : (( After reading my letter I hope there is at least one thing you can say : Boson is not reliable , but it is essential. Remember , there is a big difference between studying and studying for an exam . And the only way to ace the ocp is to do many question papers like boson. .. -- 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[2]: another OCP question -- help me guys
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. Nothing so useful as Art in my background, just graphs with the axes befuddled. Niall P.S. I can work powerpoint too. -- 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[2]: another OCP question -- help me guys
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 a degree or has completed the OCP exams. I want to see what they have done in practice, or if they are interviewing for a truly junior position, I want to know how they learn, what they've played with on their own. Two of the smartest men I have ever known never finished college. --- Niall Litchfield [EMAIL PROTECTED] wrote: 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. Nothing so useful as Art in my background, just graphs with the axes befuddled. Niall P.S. I can work powerpoint too. -- 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). __ 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: another OCP question -- help me guys
-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 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? :) there are lot of OCP-busters here :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen, Nahata (IE10) 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).