RE: dba interview questions
What was all of that about swallows, anyway? And Bambi, didn't your last name formerly end with an s? It's great to have you back on the list, in any event. --- Bellow, Bambi [EMAIL PROTECTED] wrote: Kirti -- I've had that experience too. I generally start a telephone interview hopping around the person's resume and asking questions about individual jobs... what did they do here... what do they mean by that there what was the environment over there... was management supportive in that job over there... now let's talk about the technical side of things... because there's no way to tell whether you are talking to the person who's going in for the F2F over the phone... Notice that nowhere in there is any reference to swallows. That comes later in the interview when you want to discern whether this is established knowledge or just crammed 30 minutes before the phone is supposed to ring. Bambi. -Original Message- Sent: Tuesday, October 28, 2003 4:35 PM To: Multiple recipients of list ORACLE-L Better still, sometimes 'X' takes the questions while 'Y' the candidate just stands next to him because 'X' can answer but Y does not. Tel.int means you (most probably) have not seen the guys face..correct?? By the time Visa gets approved (if overseas candidate), 'Y' ensures that he 'gains' some experience. GovindanK -Original Message- Sent: 10/24/2003 7:45:29 AM To: [EMAIL PROTECTED] Oh! Well. I have not seen Tom's book yet. But still, when the candidate is explaining this stuff to you, there are plenty of opps to question him/her to find out if he/she really knows fundamental things.. During one phone interview, we could clearly hear the paper shuffle in the background, while the candidate asked us to repeat the question (a couple of times) to 'make sure' he understood it correctly before answering (reading?)it :) We stopped phone interview process after this!! - Kirti --- [EMAIL PROTECTED] wrote: that question is diagrammed and answered in tom kytes new book. :) im waiting to get asked it. there is a new ault book out on interview questions. I dont think they are very tough. I think situational questions are better. Have a development DB set up with things for the applicant to do. I find that most employers ask the same easy questions. Particularly developer questions --- system manager wrote: Dear List, Can anyone send me a list of dba interview questions? Thanks, ___ Get Your 10MB account for FREE at http://mail.arabia.com ! http://ads.arabia.com/?SHT=text_email_english Access MILLIONS of JOBS NOW! __ Do you Yahoo!? Exclusive Video Premiere - Britney Spears http://launch.yahoo.com/promos/britneyspears/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel 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: dba interview questions
How salty is the water? -Original Message- Bellow, Bambi Sent: 27 October 2003 17:20 To: Multiple recipients of list ORACLE-L Bill -- I appreciate your input to this very complex question. IMHO, however, she turned me into a newt! is, technically, an interview *statement* rather than an interview *question*. That being said, it can be used at the beginning or end of the interview to set tone, but lesser candidates might be inclined to send envelopes full of grass to thank you for taking the time to interview them. This may, or may not, be received favorably, and one must realize the risks in making bold statements when interviewing candidates who may be subpar. Along those lines, I admit that in all my years of interviewing, I have found that there are interview questions that it is simply better not to ask: when do you come around next? (leads interviewee to think that he has advanced to a second interview), and how do you know he's a king? (leads to answers about SCOTT and MILLER with CONNECT BYs. Not at all the intended response). However, I think you're on the right track, if a bit early in the scene. Perhaps you'd consider What also floats in water?. Of course, there are multiple answers (e.g., apples, very small stones, mud, churches) which could arguably be deemed to show an acceptable level of knowledge, an ability to think outside the box, and an inventive approach, even if the salient points might not be wholly accurate. Even so, the correct answer (a duck) is technically not correct as it does not float, but swims (new scientific has determined this with a fair amount of accuracy), and I'd hate to hire a DBA who was stuck in old paradigms of science and/or technology. A CICS programmer, sure, but not a DBA. Now, if you'll just bring me a shrubbery, I can get on with my database analysis. Bambi. -Original Message- Sent: Friday, October 24, 2003 9:24 AM To: Multiple recipients of list ORACLE-L Cary Millsap scribbled on the wall in glitter crayon: Bambi, Be careful. Many will fall in love with you if you continue to submit such things as this to the list. how about: she turned me into a newt! a newt? i got better. -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] Behind an able man there are always other able men. - Chinese Proverb -- 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: Bellow, Bambi 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.530 / Virus Database: 325 - Release Date: 22/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.530 / Virus Database: 325 - Release Date: 22/10/2003 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith 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: dba interview questions
I ask things like tell me the thing you've done that you are most proud of and tell me your nightmare situation and how did you recover from it Ans: My worst nightmare, my date pick her nose infront of me, I call cab infront of her. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing 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: dba interview questions
Only two questions are required to ensure you get an appropriate person for the job (any job): 1) What do you think of David Bowie, is he brilliant or what ? and providing they answer the above question positively 2) Are you any good ? Works every time ;) Richard - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 28, 2003 7:44 PM I ask things like tell me the thing you've done that you are most proud of and tell me your nightmare situation and how did you recover from it Ans: My worst nightmare, my date pick her nose infront of me, I call cab infront of her. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing 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: dba interview questions
Only two questions are required to ensure you get an appropriate person for the job (any job): 1) What do you think of David Bowie, is he brilliant or what ? David who? Shall we sign the contracts now? ;) Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder 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: dba interview questions
On 10/28/2003 06:59:24 AM, Richard Foote wrote: 1) What do you think of David Bowie, is he brilliant or what ? Or what. and providing they answer the above question positively 2) Are you any good ? I'm ad to the one. Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- 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: dba interview questions
You're likely to get the kind of response my kids would give: Wasn't he with the Beatles or the Stones or some other *old* band like that? Hell, my son considers the Offspring to be over the hill and Linkin Park as starting to lose it... About 7 years ago, I interviewed someone who listed Phish as one of his interests. I asked him What is Phish? and then spelled it for him. The expressions that swept across his face in one second ran from frank astonishment, to disbelief, to pity, to a carefully-composed poker face as he answered, A musical group that I like. Food for thought: when I was a kid in the 70s, my father would play his big band records and my brothers and I would roll our eyes and leave the house. Such lame, ancient music! At the time, those recordings were 30-35 years old... Um... For a kid today, the Stones, the Beatles, Pink Floyd, Frank Zappa, Yes, and Bowie are far more ancient. Not just in years, but the years do add up... ..'scuse me, I think I hear a bottle of Metamucil calling... on 10/28/03 4:59 AM, Richard Foote at [EMAIL PROTECTED] wrote: Only two questions are required to ensure you get an appropriate person for the job (any job): 1) What do you think of David Bowie, is he brilliant or what ? and providing they answer the above question positively 2) Are you any good ? Works every time ;) Richard - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 28, 2003 7:44 PM I ask things like tell me the thing you've done that you are most proud of and tell me your nightmare situation and how did you recover from it Ans: My worst nightmare, my date pick her nose infront of me, I call cab infront of her. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing 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: Tim Gorman 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: dba interview questions
I am shocked Tim you forgot Robbin Trower :-). -Original Message- Sent: Tuesday, October 28, 2003 7:09 AM To: Multiple recipients of list ORACLE-L You're likely to get the kind of response my kids would give: Wasn't he with the Beatles or the Stones or some other *old* band like that? Hell, my son considers the Offspring to be over the hill and Linkin Park as starting to lose it... About 7 years ago, I interviewed someone who listed Phish as one of his interests. I asked him What is Phish? and then spelled it for him. The expressions that swept across his face in one second ran from frank astonishment, to disbelief, to pity, to a carefully-composed poker face as he answered, A musical group that I like. Food for thought: when I was a kid in the 70s, my father would play his big band records and my brothers and I would roll our eyes and leave the house. Such lame, ancient music! At the time, those recordings were 30-35 years old... Um... For a kid today, the Stones, the Beatles, Pink Floyd, Frank Zappa, Yes, and Bowie are far more ancient. Not just in years, but the years do add up... ..'scuse me, I think I hear a bottle of Metamucil calling... on 10/28/03 4:59 AM, Richard Foote at [EMAIL PROTECTED] wrote: Only two questions are required to ensure you get an appropriate person for the job (any job): 1) What do you think of David Bowie, is he brilliant or what ? and providing they answer the above question positively 2) Are you any good ? Works every time ;) Richard - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 28, 2003 7:44 PM I ask things like tell me the thing you've done that you are most proud of and tell me your nightmare situation and how did you recover from it Ans: My worst nightmare, my date pick her nose infront of me, I call cab infront of her. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing 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: Tim Gorman 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: Conner, Bill 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: dba interview questions
Give whisky, scotch and beer to Mladen and he'll be good -Original Message- Mladen Gogala Sent: 28 octobre, 2003 08:59 To: Multiple recipients of list ORACLE-L On 10/28/2003 06:59:24 AM, Richard Foote wrote: 1) What do you think of David Bowie, is he brilliant or what ? Or what. and providing they answer the above question positively 2) Are you any good ? I'm ad to the one. Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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: dba interview questions
Oddly, I was thinking the same thing about Monty Python and the Holy Grail. And then I thought... NAAH. Grail is the only common denominator that I know of that all technical geeks have in common... but now that its some obscene number of years old, I've been on a quest to find another one... a non-Star Trek one, as Star Trek has so many adherents to various generations of it... Anyone? Bambi. -Original Message- Sent: Tuesday, October 28, 2003 8:09 AM To: Multiple recipients of list ORACLE-L You're likely to get the kind of response my kids would give: Wasn't he with the Beatles or the Stones or some other *old* band like that? Hell, my son considers the Offspring to be over the hill and Linkin Park as starting to lose it... About 7 years ago, I interviewed someone who listed Phish as one of his interests. I asked him What is Phish? and then spelled it for him. The expressions that swept across his face in one second ran from frank astonishment, to disbelief, to pity, to a carefully-composed poker face as he answered, A musical group that I like. Food for thought: when I was a kid in the 70s, my father would play his big band records and my brothers and I would roll our eyes and leave the house. Such lame, ancient music! At the time, those recordings were 30-35 years old... Um... For a kid today, the Stones, the Beatles, Pink Floyd, Frank Zappa, Yes, and Bowie are far more ancient. Not just in years, but the years do add up... ..'scuse me, I think I hear a bottle of Metamucil calling... on 10/28/03 4:59 AM, Richard Foote at [EMAIL PROTECTED] wrote: Only two questions are required to ensure you get an appropriate person for the job (any job): 1) What do you think of David Bowie, is he brilliant or what ? and providing they answer the above question positively 2) Are you any good ? Works every time ;) Richard - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 28, 2003 7:44 PM I ask things like tell me the thing you've done that you are most proud of and tell me your nightmare situation and how did you recover from it Ans: My worst nightmare, my date pick her nose infront of me, I call cab infront of her. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing 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: Tim Gorman 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: Bellow, Bambi 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: dba interview questions
Bellow, Bambi scribbled on the wall in glitter crayon: Oddly, I was thinking the same thing about Monty Python and the Holy Grail. And then I thought... NAAH. Grail is the only common denominator that I know of that all technical geeks have in common... but now that its some obscene number of years old, I've been on a quest to find another one... a non-Star Trek one, as Star Trek has so many adherents to various generations of it... Anyone? dust puppy and the one true ping? -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] The superior man is distressed by the limitation of his ability; he is not distressed by the fact that men do not recognize the ability he has. - Confucius -- 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: dba interview questions
How about Life of Brian? That's even better then the Holy Grail. On 10/28/2003 01:19:25 PM, Thater, William wrote: Bellow, Bambi scribbled on the wall in glitter crayon: Oddly, I was thinking the same thing about Monty Python and the Holy Grail. And then I thought... NAAH. Grail is the only common denominator that I know of that all technical geeks have in common... but now that its some obscene number of years old, I've been on a quest to find another one... a non-Star Trek one, as Star Trek has so many adherents to various generations of it... Anyone? dust puppy and the one true ping? -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] The superior man is distressed by the limitation of his ability; he is not distressed by the fact that men do not recognize the ability he has. - Confucius -- 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- 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: dba interview questions
Proud? landing a rock to fakie followed by a fakie 360 in near vertnot bad for a 41 yo Nightmare? Playing a particularly embarrasing gig with a manic dreppressive folk music ogre, 120 minutes of pure hell in front of an audience. I refused to play anymore gigs with him. Do I get the job...?? -Original Message- Sent: Tuesday, October 28, 2003 3:44 AM To: Multiple recipients of list ORACLE-L I ask things like tell me the thing you've done that you are most proud of and tell me your nightmare situation and how did you recover from it Ans: My worst nightmare, my date pick her nose infront of me, I call cab infront of her. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing 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: Odland, Brad 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: dba interview questions
Ghostbusters? When someone asks if you're a god, you say 'YES'! ...and the flowers are still standing. Tell him about the Twinkie, Egon. Joe vs. The Volcano? Not a nice place you have here, Joe. I know he can get the job, but can he do the job? The Hunt for Red October? Be careful what you shoot at, Ryan. Most things in here don't react well to bullets. Next time, Jack, write a [gosh darn] memo. I said speak your mind, Jack, but geezus. One ping only. Come on, Big D, fly! Princess Bride? Have fun storming the castle! Did I make it clear that your job is at stake? Do you want me to send you back where you were -- unemployed in Greenland? Simpsons? Your manager says for you to shut up. And the weak and nerdy are admired for their computer programming ability. (OK, not a movie) Young Frankenstein? Throw the third switch! Not the THIRD switch! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Mladen Gogala [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 28, 2003 12:44 PM To: Multiple recipients of list ORACLE-L Subject: Re: dba interview questions How about Life of Brian? That's even better then the Holy Grail. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich 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: dba interview questions
Ah. Some time ago when running a Youth Group, I discovered that there is only one infallible answer when faced with a 'popular beat music combo, m'lud' that one has never heard of. This consist of nodding ones head sagely and saying ' ah yes, but don't you think that they've gone a bit commercial'. Works every time - even with groups that have only released 1 record that sold 42 copies. Rumour has it even David Bowie fans are fooled by this particular line. Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tim Gorman Sent: 28 October 2003 14:09 To: Multiple recipients of list ORACLE-L Subject: Re: dba interview questions You're likely to get the kind of response my kids would give: Wasn't he with the Beatles or the Stones or some other *old* band like that? Hell, my son considers the Offspring to be over the hill and Linkin Park as starting to lose it... About 7 years ago, I interviewed someone who listed Phish as one of his interests. I asked him What is Phish? and then spelled it for him. The expressions that swept across his face in one second ran from frank astonishment, to disbelief, to pity, to a carefully-composed poker face as he answered, A musical group that I like. Food for thought: when I was a kid in the 70s, my father would play his big band records and my brothers and I would roll our eyes and leave the house. Such lame, ancient music! At the time, those recordings were 30-35 years old... Um... For a kid today, the Stones, the Beatles, Pink Floyd, Frank Zappa, Yes, and Bowie are far more ancient. Not just in years, but the years do add up... ..'scuse me, I think I hear a bottle of Metamucil calling... on 10/28/03 4:59 AM, Richard Foote at [EMAIL PROTECTED] wrote: Only two questions are required to ensure you get an appropriate person for the job (any job): 1) What do you think of David Bowie, is he brilliant or what ? and providing they answer the above question positively 2) Are you any good ? Works every time ;) Richard - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 28, 2003 7:44 PM I ask things like tell me the thing you've done that you are most proud of and tell me your nightmare situation and how did you recover from it Ans: My worst nightmare, my date pick her nose infront of me, I call cab infront of her. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing 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: Tim Gorman 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: 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: dba interview questions
How about Dogma? That's a new movie and it is hillarious. Salma Hayek character was very impresive. On 10/28/2003 02:49:32 PM, Jesse, Rich wrote: Ghostbusters? When someone asks if you're a god, you say 'YES'! ...and the flowers are still standing. Tell him about the Twinkie, Egon. Joe vs. The Volcano? Not a nice place you have here, Joe. I know he can get the job, but can he do the job? The Hunt for Red October? Be careful what you shoot at, Ryan. Most things in here don't react well to bullets. Next time, Jack, write a [gosh darn] memo. I said speak your mind, Jack, but geezus. One ping only. Come on, Big D, fly! Princess Bride? Have fun storming the castle! Did I make it clear that your job is at stake? Do you want me to send you back where you were -- unemployed in Greenland? Simpsons? Your manager says for you to shut up. And the weak and nerdy are admired for their computer programming ability. (OK, not a movie) Young Frankenstein? Throw the third switch! Not the THIRD switch! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Mladen Gogala [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 28, 2003 12:44 PM To: Multiple recipients of list ORACLE-L Subject: Re: dba interview questions How about Life of Brian? That's even better then the Holy Grail. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- 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: dba interview questions
Bumper sticker sighted just the other day: My karma ran over your dogma How about Dogma? That's a new movie and it is hillarious. Salma Hayek character was very impresive. On 10/28/2003 02:49:32 PM, Jesse, Rich wrote: Ghostbusters? When someone asks if you're a god, you say 'YES'! ...and the flowers are still standing. Tell him about the Twinkie, Egon. Joe vs. The Volcano? Not a nice place you have here, Joe. I know he can get the job, but can he do the job? The Hunt for Red October? Be careful what you shoot at, Ryan. Most things in here don't react well to bullets. Next time, Jack, write a [gosh darn] memo. I said speak your mind, Jack, but geezus. One ping only. Come on, Big D, fly! Princess Bride? Have fun storming the castle! Did I make it clear that your job is at stake? Do you want me to send you back where you were -- unemployed in Greenland? Simpsons? Your manager says for you to shut up. And the weak and nerdy are admired for their computer programming ability. (OK, not a movie) Young Frankenstein? Throw the third switch! Not the THIRD switch! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Mladen Gogala [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 28, 2003 12:44 PM To: Multiple recipients of list ORACLE-L Subject: Re: dba interview questions How about Life of Brian? That's even better then the Holy Grail. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman 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: dba interview questions
-Original Message- From: Mladen Gogala [mailto:[EMAIL PROTECTED] Sent: Wednesday, 29 October 2003 05:44 To: Multiple recipients of list ORACLE-L Subject: Re: dba interview questions How about Life of Brian? That's even better then the Holy Grail. You're right, Mladen ... because we're all individuals. Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen 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: dba interview questions
Better still, sometimes 'X' takes the questions while 'Y' the candidate just stands next to him because 'X' can answer but Y does not. Tel.int means you (most probably) have not seen the guys face..correct?? By the time Visa gets approved (if overseas candidate), 'Y' ensures that he 'gains' some experience. GovindanK <-Original Message-> Sent: 10/24/2003 7:45:29 AM To: [EMAIL PROTECTED] Oh! Well. I have not seen Tom's book yet. But still, when the candidate is explaining this stuff to you, there are plenty of opps to question him/her to find out if he/she really knows fundamental things.. During one phone interview, we could clearly hear the paper shuffle in the background, while the candidate asked us to repeat the question (a couple of times) to 'make sure' he understood it correctly before answering (reading?)it :) We stopped phone interview process after this!! - Kirti --- [EMAIL PROTECTED] wrote: > that question is diagrammed and answered in tom kytes new book. :) im waiting to get asked it. > > there is a new ault book out on interview questions. I dont think they are very tough. I think > situational questions are better. Have a development DB set up with things for the applicant to > do. > > I find that most employers ask the same easy questions. Particularly developer questions > > > --- system manager <[EMAIL PROTECTED]> wrote: > Dear List, Can anyone send me a list of dba interview questions? > > Thanks, > > ___Get Your 10MB account for FREE at http://mail.arabia.com !Access MILLIONS of JOBS NOW!
RE: dba interview questions
Kirti -- I've had that experience too. I generally start a telephone interview hopping around the person's resume and asking questions about individual jobs... what did they do here... what do they mean by that there what was the environment over there... was management supportive in that job over there... now let's talk about the technical side of things... because there's no way to tell whether you are talking to the person who's going in for the F2F over the phone... Notice that nowhere in there is any reference to swallows. That comes later in the interview when you want to discern whether this is established knowledge or just crammed 30 minutes before the phone is supposed to ring. Bambi. -Original Message-From: Govindan K [mailto:[EMAIL PROTECTED]Sent: Tuesday, October 28, 2003 4:35 PMTo: Multiple recipients of list ORACLE-LSubject: Re: dba interview questionsBetter still, sometimes 'X' takes the questions while 'Y' the candidate just stands next to himbecause 'X' can answer but Y does not. Tel.int means you (most probably) have not seen the guys face..correct??By the time Visa gets approved (if overseas candidate), 'Y' ensures that he 'gains' some experience.GovindanK-Original Message- Sent: 10/24/2003 7:45:29 AMTo: [EMAIL PROTECTED]Oh! Well. I have not seen Tom's book yet. But still, when the candidate is explaining this stuff to you, there are plenty of opps toquestion him/her to find out if he/she really knows fundamental things..During one phone interview, we could clearly hear the paper shuffle in the background, while thecandidate asked us to repeat the question (a couple of times) to 'make sure' he understood itcorrectly before answering (reading?)it :) We stopped phone interview process after this!! - Kirti--- [EMAIL PROTECTED] wrote: that question is diagrammed and answered in tom kytes new book. :) im waiting to get asked it. there is a new ault book out on interview questions. I dont think they are very tough. I think situational questions are better. Have a development DB set up with things for the applicant to do. I find that most employers ask the same easy questions. Particularly developer questions--- system manager <[EMAIL PROTECTED]>wrote: Dear List, Can anyone send me a list of dba interview questions? Thanks, ___Get Your 10MB account for FREE at http://mail.arabia.com !Access MILLIONS of JOBS NOW!
RE: dba interview questions
Please kill this thread, as it no longer has anything to do with DBA interview questions. Schilling, Ben [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/28/2003 02:29 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: dba interview questions Another bumper sticker seen today: That was Zen, this is Tao. -Original Message- Sent: Tuesday, October 28, 2003 4:20 PM To: Multiple recipients of list ORACLE-L Bumper sticker sighted just the other day: My karma ran over your dogma How about Dogma? That's a new movie and it is hillarious. Salma Hayek character was very impresive. On 10/28/2003 02:49:32 PM, Jesse, Rich wrote: Ghostbusters? When someone asks if you're a god, you say 'YES'! ...and the flowers are still standing. Tell him about the Twinkie, Egon. Joe vs. The Volcano? Not a nice place you have here, Joe. I know he can get the job, but can he do the job? The Hunt for Red October? Be careful what you shoot at, Ryan. Most things in here don't react well to bullets. Next time, Jack, write a [gosh darn] memo. I said speak your mind, Jack, but geezus. One ping only. Come on, Big D, fly! Princess Bride? Have fun storming the castle! Did I make it clear that your job is at stake? Do you want me to send you back where you were -- unemployed in Greenland? Simpsons? Your manager says for you to shut up. And the weak and nerdy are admired for their computer programming ability. (OK, not a movie) Young Frankenstein? Throw the third switch! Not the THIRD switch! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Mladen Gogala [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 28, 2003 12:44 PM To: Multiple recipients of list ORACLE-L Subject: Re: dba interview questions How about Life of Brian? That's even better then the Holy Grail. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman 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
RE: dba interview questions
Another bumper sticker seen today: That was Zen, this is Tao. -Original Message- Sent: Tuesday, October 28, 2003 4:20 PM To: Multiple recipients of list ORACLE-L Bumper sticker sighted just the other day: My karma ran over your dogma How about Dogma? That's a new movie and it is hillarious. Salma Hayek character was very impresive. On 10/28/2003 02:49:32 PM, Jesse, Rich wrote: Ghostbusters? When someone asks if you're a god, you say 'YES'! ...and the flowers are still standing. Tell him about the Twinkie, Egon. Joe vs. The Volcano? Not a nice place you have here, Joe. I know he can get the job, but can he do the job? The Hunt for Red October? Be careful what you shoot at, Ryan. Most things in here don't react well to bullets. Next time, Jack, write a [gosh darn] memo. I said speak your mind, Jack, but geezus. One ping only. Come on, Big D, fly! Princess Bride? Have fun storming the castle! Did I make it clear that your job is at stake? Do you want me to send you back where you were -- unemployed in Greenland? Simpsons? Your manager says for you to shut up. And the weak and nerdy are admired for their computer programming ability. (OK, not a movie) Young Frankenstein? Throw the third switch! Not the THIRD switch! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Mladen Gogala [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 28, 2003 12:44 PM To: Multiple recipients of list ORACLE-L Subject: Re: dba interview questions How about Life of Brian? That's even better then the Holy Grail. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman 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: Schilling, Ben INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: dba interview questions
Bill -- I appreciate your input to this very complex question. IMHO, however, she turned me into a newt! is, technically, an interview *statement* rather than an interview *question*. That being said, it can be used at the beginning or end of the interview to set tone, but lesser candidates might be inclined to send envelopes full of grass to thank you for taking the time to interview them. This may, or may not, be received favorably, and one must realize the risks in making bold statements when interviewing candidates who may be subpar. Along those lines, I admit that in all my years of interviewing, I have found that there are interview questions that it is simply better not to ask: when do you come around next? (leads interviewee to think that he has advanced to a second interview), and how do you know he's a king? (leads to answers about SCOTT and MILLER with CONNECT BYs. Not at all the intended response). However, I think you're on the right track, if a bit early in the scene. Perhaps you'd consider What also floats in water?. Of course, there are multiple answers (e.g., apples, very small stones, mud, churches) which could arguably be deemed to show an acceptable level of knowledge, an ability to think outside the box, and an inventive approach, even if the salient points might not be wholly accurate. Even so, the correct answer (a duck) is technically not correct as it does not float, but swims (new scientific has determined this with a fair amount of accuracy), and I'd hate to hire a DBA who was stuck in old paradigms of science and/or technology. A CICS programmer, sure, but not a DBA. Now, if you'll just bring me a shrubbery, I can get on with my database analysis. Bambi. -Original Message- Sent: Friday, October 24, 2003 9:24 AM To: Multiple recipients of list ORACLE-L Cary Millsap scribbled on the wall in glitter crayon: Bambi, Be careful. Many will fall in love with you if you continue to submit such things as this to the list. how about: she turned me into a newt! a newt? i got better. -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] Behind an able man there are always other able men. - Chinese Proverb -- 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: Bellow, Bambi 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: dba interview questions
Nope - you will get the diagram and basic description in Tom's book (and of course the Concepts manual) but that's not the idea of using this for an interview. As they (hopefully) draw the SGA you can drift into musings like: So - if all these changes are in memory - how do we ensure against not losing data if we have a power failure That (hopefully) leads us onto redo logs, which leads to more musings: But if we've only get three - what happens when all three are full , or if they're good - there is no such thing as full for a file - how does oracle 'know' that the redo is full etc etc etc... If its a production role - you simply head down the path that most appropriate for that. If its development, you start heading down other paths (say) when they talk about library cache ... eg parsing, blah blah blah... And perhaps the best thing is, you'll easily get to detect the honesty rating. Sometimes the best answer is I have no f...ing idea. That's fine with me, and so much better than a load of BS. The saddest thing I did last week was conduct 10 or so interviews (for developers, not DBA's). Not a single one could answer the question: What is a bind variable and explain its significance to Oracle :-( A couple gave me the time honoured answer of: Hmmm, yes, I used them in my last project but cannot quite remember the specificsspare me please Cheers Connor --- [EMAIL PROTECTED] wrote: that question is diagrammed and answered in tom kytes new book. :) im waiting to get asked it. there is a new ault book out on interview questions. I dont think they are very tough. I think situational questions are better. Have a development DB set up with things for the applicant to do. I find that most employers ask the same easy questions. Particularly developer questions From: Kirtikumar Deshpande [EMAIL PROTECTED] Date: 2003/10/24 Fri AM 09:49:26 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: dba interview questions The problem with such lists is that the prospects also have those... A few years ago Mike Ault published one. We used it to screen candidates via phone interviews. Two out of four I talked to gave me perfect answers: word to word from Mike's list. Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA with all it interal structures, all background processes, and explain how all this works together. - Kirti --- system manager [EMAIL PROTECTED] wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://mail.messenger.yahoo.co.uk -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http
RE: dba interview questions
A French or English Swallow? -Original Message- Sent: Thursday, October 23, 2003 5:39 PM To: Multiple recipients of list ORACLE-L Mladen -- I'm *stunned* you missed the most obvious of all DBA 101 questions... What is the average air velocity of an unladen swallow? Bambi. -Original Message- Sent: Thursday, October 23, 2003 4:14 PM To: Multiple recipients of list ORACLE-L 1) What does it mean to grokkk? 2) What is the answer to the question of life, universe and everything? 3) What happened to Sauron when he flipped the bird to Izildur? 4) What is the monolyth and what was its effect on the resident apes? 5) What is damagement? What color of the database saves memory? 6) What can you tell me about lord Edmund Blackadder? Chances are that if someone answers those questions correctly, you've got yourself a worthy DBA. On 10/23/2003 04:14:34 PM, system manager wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: system manager 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi 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: Mercadante, Thomas F 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: dba interview questions
The problem with such lists is that the prospects also have those... A few years ago Mike Ault published one. We used it to screen candidates via phone interviews. Two out of four I talked to gave me perfect answers: word to word from Mike's list. Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA with all it interal structures, all background processes, and explain how all this works together. - Kirti --- system manager [EMAIL PROTECTED] wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande 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: dba interview questions
Bellow, Bambi scribbled on the wall in glitter crayon: Mladen -- I'm *stunned* you missed the most obvious of all DBA 101 questions... What is the average air velocity of an unladen swallow? African or European?;-) -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] Experiments before 1880 showed that light always travels athe the same speed relative to you, no matter how you were moving - basis for Einsteins axiom on moving observers. -- 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: dba interview questions
Title: RE: dba interview questions That's the inherent problem with using those kinds of lists and books is that both sets of people can read and glean. 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: Kirtikumar Deshpande [mailto:[EMAIL PROTECTED]] Sent: Friday, October 24, 2003 8:49 AM To: Multiple recipients of list ORACLE-L Subject: Re: dba interview questions The problem with such lists is that the prospects also have those... A few years ago Mike Ault published one. We used it to screen candidates via phone interviews. Two out of four I talked to gave me perfect answers: word to word from Mike's list. Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA with all it interal structures, all background processes, and explain how all this works together. - Kirti --- system manager [EMAIL PROTECTED] wrote: Dear List, Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande 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). The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment.
RE: dba interview questions
Cary Millsap scribbled on the wall in glitter crayon: Bambi, Be careful. Many will fall in love with you if you continue to submit such things as this to the list. how about: she turned me into a newt! a newt? i got better. -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] Behind an able man there are always other able men. - Chinese Proverb -- 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: dba interview questions
that question is diagrammed and answered in tom kytes new book. :) im waiting to get asked it. there is a new ault book out on interview questions. I dont think they are very tough. I think situational questions are better. Have a development DB set up with things for the applicant to do. I find that most employers ask the same easy questions. Particularly developer questions From: Kirtikumar Deshpande [EMAIL PROTECTED] Date: 2003/10/24 Fri AM 09:49:26 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: dba interview questions The problem with such lists is that the prospects also have those... A few years ago Mike Ault published one. We used it to screen candidates via phone interviews. Two out of four I talked to gave me perfect answers: word to word from Mike's list. Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA with all it interal structures, all background processes, and explain how all this works together. - Kirti --- system manager [EMAIL PROTECTED] wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: dba interview questions
Pre-packaged questions are always a bad idea. When a company needs a DBA, it should know what do they need him for. Do they need them to monitor and troubleshoot production database and ensure the availability of the database, or help developers, or lead the database related projects or to help clients and install software or mop the floors and grind coffee? The abbreviation DBA can be applied to the great variety of business roles, some of which are mutually exclusive. Cary Millsap is using terms performance analyst and performance related projects. Traditionally, companies do not have performance analysts, they have DBA's performing this function. The abbreviation DBA came to mean almos anything short of performing brain surgery. To make a long story short, the company looking for a DBA should know what specific job functions are they interested in, what specific skills are needed to perform the required job functions and adjust the the interviewing process. For instance, if you need a DBA to go and help your clients, then driver's license would be a requirement. Sounds trivial, but I know a lot of folks from NYC that don't drive and don't have driver's license. Generally speaking, driver's license is not a requirement for the DBA position, but sometimes, it can be. On 10/24/2003 09:49:26 AM, Kirtikumar Deshpande wrote: The problem with such lists is that the prospects also have those... A few years ago Mike Ault published one. We used it to screen candidates via phone interviews. Two out of four I talked to gave me perfect answers: word to word from Mike's list. Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA with all it interal structures, all background processes, and explain how all this works together. - Kirti --- system manager [EMAIL PROTECTED] wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- 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: dba interview questions
Oh! Well. I have not seen Tom's book yet. But still, when the candidate is explaining this stuff to you, there are plenty of opps to question him/her to find out if he/she really knows fundamental things.. During one phone interview, we could clearly hear the paper shuffle in the background, while the candidate asked us to repeat the question (a couple of times) to 'make sure' he understood it correctly before answering (reading?)it :) We stopped phone interview process after this!! - Kirti --- [EMAIL PROTECTED] wrote: that question is diagrammed and answered in tom kytes new book. :) im waiting to get asked it. there is a new ault book out on interview questions. I dont think they are very tough. I think situational questions are better. Have a development DB set up with things for the applicant to do. I find that most employers ask the same easy questions. Particularly developer questions From: Kirtikumar Deshpande [EMAIL PROTECTED] Date: 2003/10/24 Fri AM 09:49:26 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: dba interview questions The problem with such lists is that the prospects also have those... A few years ago Mike Ault published one. We used it to screen candidates via phone interviews. Two out of four I talked to gave me perfect answers: word to word from Mike's list. Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA with all it interal structures, all background processes, and explain how all this works together. - Kirti --- system manager [EMAIL PROTECTED] wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande 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: dba interview questions
Mladen Gogala scribbled on the wall in glitter crayon: Pre-packaged questions are always a bad idea. When a company needs a DBA, it should know what do they need him for. Do they need them to but that would provide that the company actually know how to define job duties and then convey them to HR who would then be able to screen applicants on actual experience and not just groups of letters. -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] One had to cram all this stuff into one's mind for the examinations, whether one liked it or not. This coercion had such a deterring effect on me that, after I had passed the final examination, I found the consideration of any scientific problems distasteful to me for an entire year. - 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: dba interview questions
wait, the people you interview can read? :) we've had this discussion off and on on this list over the last few years. I've been on interviews where one of the questions was about what display setting I needed to make in order to do an install. This is Oracle? This is also documented in the install guide. a better question would have been what are the steps you take before doing an install? Standardized tests have standardized answers. The tests end up published (or the interviewees publish the questions) and you get OCP. I ask things like tell me the thing you've done that you are most proud of and tell me your nightmare situation and how did you recover from it --- April Wells [EMAIL PROTECTED] wrote: That's the inherent problem with using those kinds of lists and books is that both sets of people can read and glean. 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- Sent: Friday, October 24, 2003 8:49 AM To: Multiple recipients of list ORACLE-L The problem with such lists is that the prospects also have those... A few years ago Mike Ault published one. We used it to screen candidates via phone interviews. Two out of four I talked to gave me perfect answers: word to word from Mike's list. Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA with all it interal structures, all background processes, and explain how all this works together. - Kirti --- system manager [EMAIL PROTECTED] wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande 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). The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment. __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- 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: dba interview questions
Ryan Would that diagram be in Effective Oracle by Design by Tom Kyte? Can you elaborate? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, October 24, 2003 9:29 AM To: Multiple recipients of list ORACLE-L that question is diagrammed and answered in tom kytes new book. :) im waiting to get asked it. there is a new ault book out on interview questions. I dont think they are very tough. I think situational questions are better. Have a development DB set up with things for the applicant to do. I find that most employers ask the same easy questions. Particularly developer questions From: Kirtikumar Deshpande [EMAIL PROTECTED] Date: 2003/10/24 Fri AM 09:49:26 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: dba interview questions The problem with such lists is that the prospects also have those... A few years ago Mike Ault published one. We used it to screen candidates via phone interviews. Two out of four I talked to gave me perfect answers: word to word from Mike's list. Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA with all it interal structures, all background processes, and explain how all this works together. - Kirti --- system manager [EMAIL PROTECTED] wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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: dba interview questions
We prefer to ask their experiences and then throw a curve ball and ask them to defend it. Small issues like Why would/wouldn't an index help? etc ... Another question that I *always* ask is what do you or have you read in last 3 months outside of Oracle manuals? or Do you know any other sites that give you lot of oracle related information? I expect to hear at-least couple form following list ... ixora, hotsos, jlcomp, oracle-dba, oraperf, orapub. If they mention that they have read YAPP, that's a bonus too. But if someone says they haven't read anything other than manuals questions become a little steep. Raj -Original Message- Sent: Friday, October 24, 2003 9:49 AM To: Multiple recipients of list ORACLE-L The problem with such lists is that the prospects also have those... A few years ago Mike Ault published one. We used it to screen candidates via phone interviews. Two out of four I talked to gave me perfect answers: word to word from Mike's list. Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA with all it interal structures, all background processes, and explain how all this works together. - Kirti ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- 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: dba interview questions
On 10/24/2003 11:04:34 AM, Thater, William wrote: but that would provide that the company actually know how to define job duties and then convey them to HR who would then be able to screen applicants on actual experience and not just groups of letters. Now we are talking about the job description for damagement. HR is usually perfectly capable of picking the best candidate, the one with the most expensive suit, groundless self-confidence and least amount of knowledge or management capabilities. Racial, gender and religious prejudices are usually a plus. Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- 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: dba interview questions
Bill So you are an HR person with a well-written job description in hand and a stack of resumes on the other (how may would you say a job posting would garner today -- 200?) It has been a long week of major and minor employee issues and the hiring manager has begun making ugly noises about when am I going to see some candidates?. So you stuff the whole stack in your briefcase with the illusion of a nice quiet evening to get some solitude to really go through these resumes. But there are issues with your teenage daughter and your wife's reaction to these issues, and you glance at your watch, see it is 9 pm. and realize you meant to go through those resumes. So you sit down, read the job description once, looks like Greek, read it again, no better. Now you pick up the first resume and try to relate the words on the job description to the candidate's experience. You say to yourself, hmm . . this is going to be a long evening. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, October 24, 2003 10:05 AM To: Multiple recipients of list ORACLE-L Mladen Gogala scribbled on the wall in glitter crayon: Pre-packaged questions are always a bad idea. When a company needs a DBA, it should know what do they need him for. Do they need them to but that would provide that the company actually know how to define job duties and then convey them to HR who would then be able to screen applicants on actual experience and not just groups of letters. -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] One had to cram all this stuff into one's mind for the examinations, whether one liked it or not. This coercion had such a deterring effect on me that, after I had passed the final examination, I found the consideration of any scientific problems distasteful to me for an entire year. - 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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: dba interview questions
its in the first book expert one on one. he talks about it on his webpage. its also in the concepts document. its just a diagram of oracle and the background processes. he says its the weeding out question he asks. maybe 1 in 10 get it right. From: DENNIS WILLIAMS [EMAIL PROTECTED] Date: 2003/10/24 Fri AM 11:29:25 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Re: dba interview questions Ryan Would that diagram be in Effective Oracle by Design by Tom Kyte? Can you elaborate? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, October 24, 2003 9:29 AM To: Multiple recipients of list ORACLE-L that question is diagrammed and answered in tom kytes new book. :) im waiting to get asked it. there is a new ault book out on interview questions. I dont think they are very tough. I think situational questions are better. Have a development DB set up with things for the applicant to do. I find that most employers ask the same easy questions. Particularly developer questions From: Kirtikumar Deshpande [EMAIL PROTECTED] Date: 2003/10/24 Fri AM 09:49:26 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: dba interview questions The problem with such lists is that the prospects also have those... A few years ago Mike Ault published one. We used it to screen candidates via phone interviews. Two out of four I talked to gave me perfect answers: word to word from Mike's list. Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA with all it interal structures, all background processes, and explain how all this works together. - Kirti --- system manager [EMAIL PROTECTED] wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: dba interview questions
That's more like it. The recent postings re this thread got too serious and all suffered from the same fatal flaw - they assumed that the interviewer knows something about Oracle database administration. But then you don't need a list of interview questions. Those lists are for interviewers who know nothing about the job they are interviewing for, which is why they do not only need a list of questions, but also the cheat sheet with the answers. I like Bambi's question the best. At 09:44 AM 10/24/2003, you wrote: On 10/24/2003 11:04:34 AM, Thater, William wrote: but that would provide that the company actually know how to define job duties and then convey them to HR who would then be able to screen applicants on actual experience and not just groups of letters. Now we are talking about the job description for damagement. HR is usually perfectly capable of picking the best candidate, the one with the most expensive suit, groundless self-confidence and least amount of knowledge or management capabilities. Racial, gender and religious prejudices are usually a plus. Mladen Gogala Oracle DBA Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling 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: dba interview questions
Let me continue the story. Around 11PM you want to watch a movie, so you decide to pick a few candidates, according to their letterheads, the overall outlook of the resume , resounding company names that they worked for (no matter in what capacity), the school they attended and the overall physical appearance, if such information is available. You also remember that John, the guy you play poker with has intervened in favor of one of the candidates. The short list of candidates is assembled, with your friend's candidate on top. You remember that the hiring manager owes you a favor and, voila, the fresh DBA is here! On 10/24/2003 11:54:32 AM, DENNIS WILLIAMS wrote: Bill So you are an HR person with a well-written job description in hand and a stack of resumes on the other (how may would you say a job posting would garner today -- 200?) It has been a long week of major and minor employee issues and the hiring manager has begun making ugly noises about when am I going to see some candidates?. So you stuff the whole stack in your briefcase with the illusion of a nice quiet evening to get some solitude to really go through these resumes. But there are issues with your teenage daughter and your wife's reaction to these issues, and you glance at your watch, see it is 9 pm. and realize you meant to go through those resumes. So you sit down, read the job description once, looks like Greek, read it again, no better. Now you pick up the first resume and try to relate the words on the job description to the candidate's experience. You say to yourself, hmm . . this is going to be a long evening. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, October 24, 2003 10:05 AM To: Multiple recipients of list ORACLE-L Mladen Gogala scribbled on the wall in glitter crayon: Pre-packaged questions are always a bad idea. When a company needs a DBA, it should know what do they need him for. Do they need them to but that would provide that the company actually know how to define job duties and then convey them to HR who would then be able to screen applicants on actual experience and not just groups of letters. -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] One had to cram all this stuff into one's mind for the examinations, whether one liked it or not. This coercion had such a deterring effect on me that, after I had passed the final examination, I found the consideration of any scientific problems distasteful to me for an entire year. - 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City
Re: RE: dba interview questions
not sure i like the 'read outside the oracle manuals'. I find that alot of people read alot of really bad books and then dont read the stuff on OTN. oracle has very good docs. I do have a beef over lack of syntax examples... From: Jamadagni, Rajendra [EMAIL PROTECTED] Date: 2003/10/24 Fri AM 11:39:33 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: dba interview questions We prefer to ask their experiences and then throw a curve ball and ask them to defend it. Small issues like Why would/wouldn't an index help? etc ... Another question that I *always* ask is what do you or have you read in last 3 months outside of Oracle manuals? or Do you know any other sites that give you lot of oracle related information? I expect to hear at-least couple form following list ... ixora, hotsos, jlcomp, oracle-dba, oraperf, orapub. If they mention that they have read YAPP, that's a bonus too. But if someone says they haven't read anything other than manuals questions become a little steep. Raj -Original Message- Sent: Friday, October 24, 2003 9:49 AM To: Multiple recipients of list ORACLE-L The problem with such lists is that the prospects also have those... A few years ago Mike Ault published one. We used it to screen candidates via phone interviews. Two out of four I talked to gave me perfect answers: word to word from Mike's list. Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA with all it interal structures, all background processes, and explain how all this works together. - Kirti ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- 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). -- 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: dba interview questions
do any of you ask dbas pl/sql questions? I think its important for DBAs to be good developers as well. especially if they are part of a development team. I dont think the skill sets should be seperate. they overlap. From: Jamadagni, Rajendra [EMAIL PROTECTED] Date: 2003/10/24 Fri AM 11:39:33 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: dba interview questions We prefer to ask their experiences and then throw a curve ball and ask them to defend it. Small issues like Why would/wouldn't an index help? etc ... Another question that I *always* ask is what do you or have you read in last 3 months outside of Oracle manuals? or Do you know any other sites that give you lot of oracle related information? I expect to hear at-least couple form following list ... ixora, hotsos, jlcomp, oracle-dba, oraperf, orapub. If they mention that they have read YAPP, that's a bonus too. But if someone says they haven't read anything other than manuals questions become a little steep. Raj -Original Message- Sent: Friday, October 24, 2003 9:49 AM To: Multiple recipients of list ORACLE-L The problem with such lists is that the prospects also have those... A few years ago Mike Ault published one. We used it to screen candidates via phone interviews. Two out of four I talked to gave me perfect answers: word to word from Mike's list. Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA with all it interal structures, all background processes, and explain how all this works together. - Kirti ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- 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). -- 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: dba interview questions
Ask them what their daily, weekly, and monthly procedures are. How do they accomplish them? Do they have an example of their daily checklist (or can they generate it from memory)? Kirtikumar DeshpandeTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] kirtikumar_desh cc: pandeSubject: Re: dba interview questions @yahoo.com Sent by: ml-errors 10/24/2003 09:49 AM Please respond to ORACLE-L The problem with such lists is that the prospects also have those... A few years ago Mike Ault published one. We used it to screen candidates via phone interviews. Two out of four I talked to gave me perfect answers: word to word from Mike's list. Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA with all it interal structures, all background processes, and explain how all this works together. - Kirti --- system manager [EMAIL PROTECTED] wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande 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: Thomas Day 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: dba interview questions
I have had a couple of interviews for Oracle DBA jobs where they pull out a list of technical questions about the most minor items you can think of. Being able to answer them indicates how good a person's grey brain cells are at memorizing trivia. They do not measure a persons ability to problem solve which is a skill that I think a company would be interested in when hiring a DBA! My $0.02 worth, Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, October 24, 2003 9:39 AM Pre-packaged questions are always a bad idea. When a company needs a DBA, it should know what do they need him for. Do they need them to monitor and troubleshoot production database and ensure the availability of the database, or help developers, or lead the database related projects or to help clients and install software or mop the floors and grind coffee? The abbreviation DBA can be applied to the great variety of business roles, some of which are mutually exclusive. Cary Millsap is using terms performance analyst and performance related projects. Traditionally, companies do not have performance analysts, they have DBA's performing this function. The abbreviation DBA came to mean almos anything short of performing brain surgery. To make a long story short, the company looking for a DBA should know what specific job functions are they interested in, what specific skills are needed to perform the required job functions and adjust the the interviewing process. For instance, if you need a DBA to go and help your clients, then driver's license would be a requirement. Sounds trivial, but I know a lot of folks from NYC that don't drive and don't have driver's license. Generally speaking, driver's license is not a requirement for the DBA position, but sometimes, it can be. On 10/24/2003 09:49:26 AM, Kirtikumar Deshpande wrote: The problem with such lists is that the prospects also have those... A few years ago Mike Ault published one. We used it to screen candidates via phone interviews. Two out of four I talked to gave me perfect answers: word to word from Mike's list. Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA with all it interal structures, all background processes, and explain how all this works together. - Kirti --- system manager [EMAIL PROTECTED] wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- 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
RE: RE: dba interview questions
Sure do, here's my favorite: You have a database with 3000 registered users, you need to lock all accounts except for a list of 20. How would you do it? Obviously there's several correct answers. But the one I'm looking for is the anonymous PL/SQL block defined like: declare stmt varchar2(200); begin for a in (select username from dba_users where username not in ('SYS','SYSTEM',...)) loop stmt := 'alter user '||a.username||' account lock'; execute immediate stmt; end loop; end; / Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, October 24, 2003 12:00 PM To: Multiple recipients of list ORACLE-L do any of you ask dbas pl/sql questions? I think its important for DBAs to be good developers as well. especially if they are part of a development team. I dont think the skill sets should be seperate. they overlap. From: Jamadagni, Rajendra [EMAIL PROTECTED] Date: 2003/10/24 Fri AM 11:39:33 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: dba interview questions We prefer to ask their experiences and then throw a curve ball and ask them to defend it. Small issues like Why would/wouldn't an index help? etc ... Another question that I *always* ask is what do you or have you read in last 3 months outside of Oracle manuals? or Do you know any other sites that give you lot of oracle related information? I expect to hear at-least couple form following list ... ixora, hotsos, jlcomp, oracle-dba, oraperf, orapub. If they mention that they have read YAPP, that's a bonus too. But if someone says they haven't read anything other than manuals questions become a little steep. Raj -Original Message- Sent: Friday, October 24, 2003 9:49 AM To: Multiple recipients of list ORACLE-L The problem with such lists is that the prospects also have those... A few years ago Mike Ault published one. We used it to screen candidates via phone interviews. Two out of four I talked to gave me perfect answers: word to word from Mike's list. Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA with all it interal structures, all background processes, and explain how all this works together. - Kirti ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- 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). -- 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). -- 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
RE: RE: dba interview questions
What do you need the stmt for? Just do: begin for a in (select username from dba_users where username not in ('SYS','SYSTEM',...)) loop execute immediate 'alter user '||a.username||' account lock'; end loop; end; / Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it. - Tom Lehrer. -Original Message- Sent: Friday, October 24, 2003 2:00 PM To: Multiple recipients of list ORACLE-L Sure do, here's my favorite: You have a database with 3000 registered users, you need to lock all accounts except for a list of 20. How would you do it? Obviously there's several correct answers. But the one I'm looking for is the anonymous PL/SQL block defined like: declare stmt varchar2(200); begin for a in (select username from dba_users where username not in ('SYS','SYSTEM',...)) loop stmt := 'alter user '||a.username||' account lock'; execute immediate stmt; end loop; end; / Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, October 24, 2003 12:00 PM To: Multiple recipients of list ORACLE-L do any of you ask dbas pl/sql questions? I think its important for DBAs to be good developers as well. especially if they are part of a development team. I dont think the skill sets should be seperate. they overlap. From: Jamadagni, Rajendra [EMAIL PROTECTED] Date: 2003/10/24 Fri AM 11:39:33 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: dba interview questions We prefer to ask their experiences and then throw a curve ball and ask them to defend it. Small issues like Why would/wouldn't an index help? etc ... Another question that I *always* ask is what do you or have you read in last 3 months outside of Oracle manuals? or Do you know any other sites that give you lot of oracle related information? I expect to hear at-least couple form following list ... ixora, hotsos, jlcomp, oracle-dba, oraperf, orapub. If they mention that they have read YAPP, that's a bonus too. But if someone says they haven't read anything other than manuals questions become a little steep. Raj -Original Message- Sent: Friday, October 24, 2003 9:49 AM To: Multiple recipients of list ORACLE-L The problem with such lists is that the prospects also have those... A few years ago Mike Ault published one. We used it to screen candidates via phone interviews. Two out of four I talked to gave me perfect answers: word to word from Mike's list. Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA with all it interal structures, all background processes, and explain how all this works together. - Kirti ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- 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). -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL
RE: RE: dba interview questions
Heck, Our helpdesk doesn't even reset passwords!! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, October 24, 2003 3:04 PM To: Multiple recipients of list ORACLE-L I would have answered: I'd send the list to the help desk as they take care of logins and tell them to lock all accounts except the list I send. What is it you say?? your help desk doesn't do that? Tsk, tsk, tsk... hehehe -Original Message- Sent: Friday, October 24, 2003 1:00 PM To: Multiple recipients of list ORACLE-L Sure do, here's my favorite: You have a database with 3000 registered users, you need to lock all accounts except for a list of 20. How would you do it? Obviously there's several correct answers. But the one I'm looking for is the anonymous PL/SQL block defined like: declare stmt varchar2(200); begin for a in (select username from dba_users where username not in ('SYS','SYSTEM',...)) loop stmt := 'alter user '||a.username||' account lock'; execute immediate stmt; end loop; end; / Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, October 24, 2003 12:00 PM To: Multiple recipients of list ORACLE-L do any of you ask dbas pl/sql questions? I think its important for DBAs to be good developers as well. especially if they are part of a development team. I dont think the skill sets should be seperate. they overlap. From: Jamadagni, Rajendra [EMAIL PROTECTED] Date: 2003/10/24 Fri AM 11:39:33 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: dba interview questions We prefer to ask their experiences and then throw a curve ball and ask them to defend it. Small issues like Why would/wouldn't an index help? etc ... Another question that I *always* ask is what do you or have you read in last 3 months outside of Oracle manuals? or Do you know any other sites that give you lot of oracle related information? I expect to hear at-least couple form following list ... ixora, hotsos, jlcomp, oracle-dba, oraperf, orapub. If they mention that they have read YAPP, that's a bonus too. But if someone says they haven't read anything other than manuals questions become a little steep. Raj -Original Message- Sent: Friday, October 24, 2003 9:49 AM To: Multiple recipients of list ORACLE-L The problem with such lists is that the prospects also have those... A few years ago Mike Ault published one. We used it to screen candidates via phone interviews. Two out of four I talked to gave me perfect answers: word to word from Mike's list. Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA with all it interal structures, all background processes, and explain how all this works together. - Kirti ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- 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). -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL
RE: Re: dba interview questions
Title: RE: Re: dba interview questions and at least if someone takes the time to read a book and get the whole picture, they have some kind of gumshun. 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: Kirtikumar Deshpande [mailto:[EMAIL PROTECTED]] Sent: Friday, October 24, 2003 9:44 AM To: Multiple recipients of list ORACLE-L Subject: Re: Re: dba interview questions Oh! Well. I have not seen Tom's book yet. But still, when the candidate is explaining this stuff to you, there are plenty of opps to question him/her to find out if he/she really knows fundamental things.. During one phone interview, we could clearly hear the paper shuffle in the background, while the candidate asked us to repeat the question (a couple of times) to 'make sure' he understood it correctly before answering (reading?)it :) We stopped phone interview process after this!! - Kirti --- [EMAIL PROTECTED] wrote: that question is diagrammed and answered in tom kytes new book. :) im waiting to get asked it. there is a new ault book out on interview questions. I dont think they are very tough. I think situational questions are better. Have a development DB set up with things for the applicant to do. I find that most employers ask the same easy questions. Particularly developer questions From: Kirtikumar Deshpande [EMAIL PROTECTED] Date: 2003/10/24 Fri AM 09:49:26 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: dba interview questions The problem with such lists is that the prospects also have those... A few years ago Mike Ault published one. We used it to screen candidates via phone interviews. Two out of four I talked to gave me perfect answers: word to word from Mike's list. Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA with all it interal structures, all background processes, and explain how all this works together. - Kirti --- system manager [EMAIL PROTECTED] wrote: Dear List, Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande 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). The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged
RE: dba interview questions
Indeed. We all have our thing that we like to focus on. When I hire someone, I'm more interested in the program running in someone's head than I am in the data segment that's stored in there. The far-and-away best interviewing material I've ever seen is the Effective Interviewing! stuff written by Jim Kennedy and Anna Everest, which you can read about at http://www.interviewedge.com/. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney - SQL Optimization 101: 12/8-12 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- KENNETH JANUSZ Sent: Friday, October 24, 2003 10:09 AM To: Multiple recipients of list ORACLE-L I have had a couple of interviews for Oracle DBA jobs where they pull out a list of technical questions about the most minor items you can think of. Being able to answer them indicates how good a person's grey brain cells are at memorizing trivia. They do not measure a persons ability to problem solve which is a skill that I think a company would be interested in when hiring a DBA! My $0.02 worth, Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, October 24, 2003 9:39 AM Pre-packaged questions are always a bad idea. When a company needs a DBA, it should know what do they need him for. Do they need them to monitor and troubleshoot production database and ensure the availability of the database, or help developers, or lead the database related projects or to help clients and install software or mop the floors and grind coffee? The abbreviation DBA can be applied to the great variety of business roles, some of which are mutually exclusive. Cary Millsap is using terms performance analyst and performance related projects. Traditionally, companies do not have performance analysts, they have DBA's performing this function. The abbreviation DBA came to mean almos anything short of performing brain surgery. To make a long story short, the company looking for a DBA should know what specific job functions are they interested in, what specific skills are needed to perform the required job functions and adjust the the interviewing process. For instance, if you need a DBA to go and help your clients, then driver's license would be a requirement. Sounds trivial, but I know a lot of folks from NYC that don't drive and don't have driver's license. Generally speaking, driver's license is not a requirement for the DBA position, but sometimes, it can be. On 10/24/2003 09:49:26 AM, Kirtikumar Deshpande wrote: The problem with such lists is that the prospects also have those... A few years ago Mike Ault published one. We used it to screen candidates via phone interviews. Two out of four I talked to gave me perfect answers: word to word from Mike's list. Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA with all it interal structures, all background processes, and explain how all this works together. - Kirti --- system manager [EMAIL PROTECTED] wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail
Re[2]: dba interview questions
Friday, October 24, 2003, 9:49:26 AM, Kirti wrote: KD Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA KD with all it interal structures, all background processes, and explain how all this works KD together. That's not a half-bad idea. Of possibly more importance than whether they could draw that diagram perfectly might be their thought-process as they tried to fill in the pieces that they don't quite remember. 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: dba interview questions
I'm actually appending to Kirti's answer below here. Before my students receive a passing grade in my class, they are required to do exactly what Kirti and Connor have laid out. They must each do this as part of their final exam. Most of them have no difficulty. When they ask me how they should prepare for an interview, I've often told them that if they are not asked to stand up to a white board and lay everything out, they should offer to. Most of them do, and oftentimes they get the job, or they are told that they were one of the top five candidates. And to also add to Rachel's point, I tell them to carefully listen to any technical knowledge displayed by their hiring manager (if this is the person they are interviewing with). I once interviewed with someone who asked me to solve a potential problem they were currently having with their database. He told me they had recently added several indexes to such-and-such tables for such-and-such application, and it was *still* slow. I took a brief look and saw no statistics. I asked him if he had ever analyzed his tables or indexes. He told me they created explain plans all the time and still could not locate the problem. I asked him if he was using the cost-based optimizer. He informed me that he was not. He was in fact using optimizer=CHOOSE Yeah, you see where this is going. I ended up taking a job with a different company. I tell my students, that even if they are offered a job (and this is less potent advice in a failing economy) if at all possible, try to work for a person who is just as, if not more, knowledgeable than you are. If your boss is a good mentor you have a great potential to grow and further your knowledge. And if not, well, you could end up with the situation above. So, for the system manager who originally started this thread, hopefully you are just as knowledgeable as the candidates you hope to obtain? Or, you are forwarding the candidates on to someone who is? -Original Message- Rachel Carmichael Sent: Friday, October 24, 2003 11:10 AM To: Multiple recipients of list ORACLE-L wait, the people you interview can read? :) we've had this discussion off and on on this list over the last few years. I've been on interviews where one of the questions was about what display setting I needed to make in order to do an install. This is Oracle? This is also documented in the install guide. a better question would have been what are the steps you take before doing an install? Standardized tests have standardized answers. The tests end up published (or the interviewees publish the questions) and you get OCP. I ask things like tell me the thing you've done that you are most proud of and tell me your nightmare situation and how did you recover from it --- April Wells [EMAIL PROTECTED] wrote: That's the inherent problem with using those kinds of lists and books is that both sets of people can read and glean. 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- Sent: Friday, October 24, 2003 8:49 AM To: Multiple recipients of list ORACLE-L The problem with such lists is that the prospects also have those... A few years ago Mike Ault published one. We used it to screen candidates via phone interviews. Two out of four I talked to gave me perfect answers: word to word from Mike's list. Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA with all it interal structures, all background processes, and explain how all this works together. - Kirti --- system manager [EMAIL PROTECTED] wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande 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). The information contained
RE: dba interview questions
I've been in the position for over 10 years now in which this was a candidate algorithm for making decisions. It doesn't work. If you make decisions this way, you'll ultimately lose your good employees, your job, or--if it's not stopped--your whole business. It just doesn't work, because to survive in business you have to be *competitive*. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney - SQL Optimization 101: 12/8-12 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Mladen Gogala Sent: Friday, October 24, 2003 11:40 AM To: Multiple recipients of list ORACLE-L Let me continue the story. Around 11PM you want to watch a movie, so you decide to pick a few candidates, according to their letterheads, the overall outlook of the resume , resounding company names that they worked for (no matter in what capacity), the school they attended and the overall physical appearance, if such information is available. You also remember that John, the guy you play poker with has intervened in favor of one of the candidates. The short list of candidates is assembled, with your friend's candidate on top. You remember that the hiring manager owes you a favor and, voila, the fresh DBA is here! On 10/24/2003 11:54:32 AM, DENNIS WILLIAMS wrote: Bill So you are an HR person with a well-written job description in hand and a stack of resumes on the other (how may would you say a job posting would garner today -- 200?) It has been a long week of major and minor employee issues and the hiring manager has begun making ugly noises about when am I going to see some candidates?. So you stuff the whole stack in your briefcase with the illusion of a nice quiet evening to get some solitude to really go through these resumes. But there are issues with your teenage daughter and your wife's reaction to these issues, and you glance at your watch, see it is 9 pm. and realize you meant to go through those resumes. So you sit down, read the job description once, looks like Greek, read it again, no better. Now you pick up the first resume and try to relate the words on the job description to the candidate's experience. You say to yourself, hmm . . this is going to be a long evening. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, October 24, 2003 10:05 AM To: Multiple recipients of list ORACLE-L Mladen Gogala scribbled on the wall in glitter crayon: Pre-packaged questions are always a bad idea. When a company needs a DBA, it should know what do they need him for. Do they need them to but that would provide that the company actually know how to define job duties and then convey them to HR who would then be able to screen applicants on actual experience and not just groups of letters. -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] One had to cram all this stuff into one's mind for the examinations, whether one liked it or not. This coercion had such a deterring effect on me that, after I had passed the final examination, I found the consideration of any scientific problems distasteful to me for an entire year. - 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No
Re: Re: dba interview questions
sigh... add to this weekend's reading list Tom's new book (it's sitting on my dining room table, waiting) --- [EMAIL PROTECTED] wrote: that question is diagrammed and answered in tom kytes new book. :) im waiting to get asked it. there is a new ault book out on interview questions. I dont think they are very tough. I think situational questions are better. Have a development DB set up with things for the applicant to do. I find that most employers ask the same easy questions. Particularly developer questions From: Kirtikumar Deshpande [EMAIL PROTECTED] Date: 2003/10/24 Fri AM 09:49:26 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: dba interview questions The problem with such lists is that the prospects also have those... A few years ago Mike Ault published one. We used it to screen candidates via phone interviews. Two out of four I talked to gave me perfect answers: word to word from Mike's list. Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA with all it interal structures, all background processes, and explain how all this works together. - Kirti --- system manager [EMAIL PROTECTED] wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- 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]: dba interview questions
Being graphically challenged (my drawings without Visio(TM) or Dia are on the level of a 3 years old), I resent the idea. If I had to do drawing, I would not be a DBA today. That would be small loss for me and an enormous one for this list. Did I mention the fact that I'm very humble and modest? On 10/24/2003 11:34:26 AM, Jonathan Gennick wrote: Friday, October 24, 2003, 9:49:26 AM, Kirti wrote: KD Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA KD with all it interal structures, all background processes, and explain how all this works KD together. That's not a half-bad idea. Of possibly more importance than whether they could draw that diagram perfectly might be their thought-process as they tried to fill in the pieces that they don't quite remember. 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- 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: dba interview questions
I usually tend to ask questions like what has been your worst disaster scenario and how did you fix it, what other options would you have had and why didn't you use these etc.. The same with performance tuning issues... Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, October 24, 2003 5:44 PM Oh! Well. I have not seen Tom's book yet. But still, when the candidate is explaining this stuff to you, there are plenty of opps to question him/her to find out if he/she really knows fundamental things.. During one phone interview, we could clearly hear the paper shuffle in the background, while the candidate asked us to repeat the question (a couple of times) to 'make sure' he understood it correctly before answering (reading?)it :) We stopped phone interview process after this!! - Kirti --- [EMAIL PROTECTED] wrote: that question is diagrammed and answered in tom kytes new book. :) im waiting to get asked it. there is a new ault book out on interview questions. I dont think they are very tough. I think situational questions are better. Have a development DB set up with things for the applicant to do. I find that most employers ask the same easy questions. Particularly developer questions From: Kirtikumar Deshpande [EMAIL PROTECTED] Date: 2003/10/24 Fri AM 09:49:26 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: dba interview questions The problem with such lists is that the prospects also have those... A few years ago Mike Ault published one. We used it to screen candidates via phone interviews. Two out of four I talked to gave me perfect answers: word to word from Mike's list. Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA with all it interal structures, all background processes, and explain how all this works together. - Kirti --- system manager [EMAIL PROTECTED] wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande 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: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: dba interview questions
Sysmgr -- You see now how easy it is to weed out the DBAs who are strong in book knowledge and may have certifications that are not based on real world experiencee. Now, I know Mr. M is ok, so I can vouch for him personally; but, as a general rule, these are not the types of DBAs that you want to hire. Best wishes, Bambi. -Original Message- Sent: Friday, October 24, 2003 7:44 AM To: Multiple recipients of list ORACLE-L A French or English Swallow? -Original Message- Sent: Thursday, October 23, 2003 5:39 PM To: Multiple recipients of list ORACLE-L Mladen -- I'm *stunned* you missed the most obvious of all DBA 101 questions... What is the average air velocity of an unladen swallow? Bambi. -Original Message- Sent: Thursday, October 23, 2003 4:14 PM To: Multiple recipients of list ORACLE-L 1) What does it mean to grokkk? 2) What is the answer to the question of life, universe and everything? 3) What happened to Sauron when he flipped the bird to Izildur? 4) What is the monolyth and what was its effect on the resident apes? 5) What is damagement? What color of the database saves memory? 6) What can you tell me about lord Edmund Blackadder? Chances are that if someone answers those questions correctly, you've got yourself a worthy DBA. On 10/23/2003 04:14:34 PM, system manager wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: system manager 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi 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: Mercadante, Thomas F 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
RE: RE: dba interview questions
I would have answered: I'd send the list to the help desk as they take care of logins and tell them to lock all accounts except the list I send. What is it you say?? your help desk doesn't do that? Tsk, tsk, tsk... hehehe -Original Message- Sent: Friday, October 24, 2003 1:00 PM To: Multiple recipients of list ORACLE-L Sure do, here's my favorite: You have a database with 3000 registered users, you need to lock all accounts except for a list of 20. How would you do it? Obviously there's several correct answers. But the one I'm looking for is the anonymous PL/SQL block defined like: declare stmt varchar2(200); begin for a in (select username from dba_users where username not in ('SYS','SYSTEM',...)) loop stmt := 'alter user '||a.username||' account lock'; execute immediate stmt; end loop; end; / Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, October 24, 2003 12:00 PM To: Multiple recipients of list ORACLE-L do any of you ask dbas pl/sql questions? I think its important for DBAs to be good developers as well. especially if they are part of a development team. I dont think the skill sets should be seperate. they overlap. From: Jamadagni, Rajendra [EMAIL PROTECTED] Date: 2003/10/24 Fri AM 11:39:33 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: dba interview questions We prefer to ask their experiences and then throw a curve ball and ask them to defend it. Small issues like Why would/wouldn't an index help? etc ... Another question that I *always* ask is what do you or have you read in last 3 months outside of Oracle manuals? or Do you know any other sites that give you lot of oracle related information? I expect to hear at-least couple form following list ... ixora, hotsos, jlcomp, oracle-dba, oraperf, orapub. If they mention that they have read YAPP, that's a bonus too. But if someone says they haven't read anything other than manuals questions become a little steep. Raj -Original Message- Sent: Friday, October 24, 2003 9:49 AM To: Multiple recipients of list ORACLE-L The problem with such lists is that the prospects also have those... A few years ago Mike Ault published one. We used it to screen candidates via phone interviews. Two out of four I talked to gave me perfect answers: word to word from Mike's list. Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA with all it interal structures, all background processes, and explain how all this works together. - Kirti ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- 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). -- 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). -- 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
RE: RE: dba interview questions
I always find syntax examples in manuals ... don't know why ... Raj -Original Message- Sent: Friday, October 24, 2003 11:59 AM To: Multiple recipients of list ORACLE-L not sure i like the 'read outside the oracle manuals'. I find that alot of people read alot of really bad books and then dont read the stuff on OTN. oracle has very good docs. I do have a beef over lack of syntax examples... From: Jamadagni, Rajendra [EMAIL PROTECTED] Date: 2003/10/24 Fri AM 11:39:33 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: dba interview questions We prefer to ask their experiences and then throw a curve ball and ask them to defend it. Small issues like Why would/wouldn't an index help? etc ... Another question that I *always* ask is what do you or have you read in last 3 months outside of Oracle manuals? or Do you know any other sites that give you lot of oracle related information? I expect to hear at-least couple form following list ... ixora, hotsos, jlcomp, oracle-dba, oraperf, orapub. If they mention that they have read YAPP, that's a bonus too. But if someone says they haven't read anything other than manuals questions become a little steep. Raj -Original Message- Sent: Friday, October 24, 2003 9:49 AM To: Multiple recipients of list ORACLE-L The problem with such lists is that the prospects also have those... A few years ago Mike Ault published one. We used it to screen candidates via phone interviews. Two out of four I talked to gave me perfect answers: word to word from Mike's list. Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA with all it interal structures, all background processes, and explain how all this works together. - Kirti ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- 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). -- 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). ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- 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).
dba interview questions
Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: system manager 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: dba interview questions
Thursday, October 23, 2003, 4:14:34 PM, you wrote: sm Dear List,Can anyone send me a list of dba interview questions? Forget the questions. Somebody send me the answers! :) Heh. Maybe you could do the interview in Jeopardy format, where you state the answer, and force the candidate to back into the 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. -- 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: dba interview questions
1) What does it mean to grokkk? 2) What is the answer to the question of life, universe and everything? 3) What happened to Sauron when he flipped the bird to Izildur? 4) What is the monolyth and what was its effect on the resident apes? 5) What is damagement? What color of the database saves memory? 6) What can you tell me about lord Edmund Blackadder? Chances are that if someone answers those questions correctly, you've got yourself a worthy DBA. On 10/23/2003 04:14:34 PM, system manager wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: system manager 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- 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: dba interview questions - Found word(s) to be removed remove free list error email e-mail in the Text body.
Actually, the only important question is How much do you want ? Oh, for the good old days ... Seriously, Mike Ault had a list of questions once which may be a little dated now but would be a good staert. Perhaps on www.tusc.com where he used to work at. Mike ? -Original Message- Sent: Thursday, October 23, 2003 2:14 PM To: Multiple recipients of list ORACLE-L be removed remove free list error email e-mail in the Text body. 1) What does it mean to grokkk? 2) What is the answer to the question of life, universe and everything? 3) What happened to Sauron when he flipped the bird to Izildur? 4) What is the monolyth and what was its effect on the resident apes? 5) What is damagement? What color of the database saves memory? 6) What can you tell me about lord Edmund Blackadder? Chances are that if someone answers those questions correctly, you've got yourself a worthy DBA. On 10/23/2003 04:14:34 PM, system manager wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: system manager 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tony Johnson 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: dba interview questions
Mladen -- I'm *stunned* you missed the most obvious of all DBA 101 questions... What is the average air velocity of an unladen swallow? Bambi. -Original Message- Sent: Thursday, October 23, 2003 4:14 PM To: Multiple recipients of list ORACLE-L 1) What does it mean to grokkk? 2) What is the answer to the question of life, universe and everything? 3) What happened to Sauron when he flipped the bird to Izildur? 4) What is the monolyth and what was its effect on the resident apes? 5) What is damagement? What color of the database saves memory? 6) What can you tell me about lord Edmund Blackadder? Chances are that if someone answers those questions correctly, you've got yourself a worthy DBA. On 10/23/2003 04:14:34 PM, system manager wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: system manager 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi 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: dba interview questions
and which sql makes server HOT -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 23, 2003 2:14 PM 1) What does it mean to grokkk? 2) What is the answer to the question of life, universe and everything? 3) What happened to Sauron when he flipped the bird to Izildur? 4) What is the monolyth and what was its effect on the resident apes? 5) What is damagement? What color of the database saves memory? 6) What can you tell me about lord Edmund Blackadder? Chances are that if someone answers those questions correctly, you've got yourself a worthy DBA. On 10/23/2003 04:14:34 PM, system manager wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: system manager 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: AK 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: dba interview questions
African or European? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan Bellow, Bambi [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ech.com cc: Sent by: Subject: RE: dba interview questions [EMAIL PROTECTED] .com 10/23/2003 03:39 PM Please respond to ORACLE-L Mladen -- I'm *stunned* you missed the most obvious of all DBA 101 questions... What is the average air velocity of an unladen swallow? Bambi. -Original Message- Sent: Thursday, October 23, 2003 4:14 PM To: Multiple recipients of list ORACLE-L 1) What does it mean to grokkk? 2) What is the answer to the question of life, universe and everything? 3) What happened to Sauron when he flipped the bird to Izildur? 4) What is the monolyth and what was its effect on the resident apes? 5) What is damagement? What color of the database saves memory? 6) What can you tell me about lord Edmund Blackadder? Chances are that if someone answers those questions correctly, you've got yourself a worthy DBA. On 10/23/2003 04:14:34 PM, system manager wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: system manager 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author
RE: dba interview questions
Bambi, Be careful. Many will fall in love with you if you continue to submit such things as this to the list. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney - SQL Optimization 101: 12/8-12 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Bellow, Bambi Sent: Thursday, October 23, 2003 4:39 PM To: Multiple recipients of list ORACLE-L Mladen -- I'm *stunned* you missed the most obvious of all DBA 101 questions... What is the average air velocity of an unladen swallow? Bambi. -Original Message- Sent: Thursday, October 23, 2003 4:14 PM To: Multiple recipients of list ORACLE-L 1) What does it mean to grokkk? 2) What is the answer to the question of life, universe and everything? 3) What happened to Sauron when he flipped the bird to Izildur? 4) What is the monolyth and what was its effect on the resident apes? 5) What is damagement? What color of the database saves memory? 6) What can you tell me about lord Edmund Blackadder? Chances are that if someone answers those questions correctly, you've got yourself a worthy DBA. On 10/23/2003 04:14:34 PM, system manager wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: system manager 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command
RE: dba interview questions
OK, Sysmgr. There you have it. Hire Ron. -Original Message- Sent: Thursday, October 23, 2003 4:54 PM To: Multiple recipients of list ORACLE-L African or European? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan Bellow, Bambi [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ech.com cc: Sent by: Subject: RE: dba interview questions [EMAIL PROTECTED] .com 10/23/2003 03:39 PM Please respond to ORACLE-L Mladen -- I'm *stunned* you missed the most obvious of all DBA 101 questions... What is the average air velocity of an unladen swallow? Bambi. -Original Message- Sent: Thursday, October 23, 2003 4:14 PM To: Multiple recipients of list ORACLE-L 1) What does it mean to grokkk? 2) What is the answer to the question of life, universe and everything? 3) What happened to Sauron when he flipped the bird to Izildur? 4) What is the monolyth and what was its effect on the resident apes? 5) What is damagement? What color of the database saves memory? 6) What can you tell me about lord Edmund Blackadder? Chances are that if someone answers those questions correctly, you've got yourself a worthy DBA. On 10/23/2003 04:14:34 PM, system manager wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: system manager 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi 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: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing
RE: dba interview questions
Cary -- I'm just naturally lovable. But you they respect. Bambi. -Original Message- Sent: Thursday, October 23, 2003 5:29 PM To: Multiple recipients of list ORACLE-L Bambi, Be careful. Many will fall in love with you if you continue to submit such things as this to the list. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney - SQL Optimization 101: 12/8-12 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Bellow, Bambi Sent: Thursday, October 23, 2003 4:39 PM To: Multiple recipients of list ORACLE-L Mladen -- I'm *stunned* you missed the most obvious of all DBA 101 questions... What is the average air velocity of an unladen swallow? Bambi. -Original Message- Sent: Thursday, October 23, 2003 4:14 PM To: Multiple recipients of list ORACLE-L 1) What does it mean to grokkk? 2) What is the answer to the question of life, universe and everything? 3) What happened to Sauron when he flipped the bird to Izildur? 4) What is the monolyth and what was its effect on the resident apes? 5) What is damagement? What color of the database saves memory? 6) What can you tell me about lord Edmund Blackadder? Chances are that if someone answers those questions correctly, you've got yourself a worthy DBA. On 10/23/2003 04:14:34 PM, system manager wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: system manager 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling
RE: dba interview questions
Category: Init.ora parameters points: 1000 Answer: It depends! Category: CBO points: 1000 Answer: It depends!
RE: dba interview questions
hey! we forgot that one in the book.. DANG! --- Bellow, Bambi [EMAIL PROTECTED] wrote: Mladen -- I'm *stunned* you missed the most obvious of all DBA 101 questions... What is the average air velocity of an unladen swallow? Bambi. -Original Message- Sent: Thursday, October 23, 2003 4:14 PM To: Multiple recipients of list ORACLE-L 1) What does it mean to grokkk? 2) What is the answer to the question of life, universe and everything? 3) What happened to Sauron when he flipped the bird to Izildur? 4) What is the monolyth and what was its effect on the resident apes? 5) What is damagement? What color of the database saves memory? 6) What can you tell me about lord Edmund Blackadder? Chances are that if someone answers those questions correctly, you've got yourself a worthy DBA. On 10/23/2003 04:14:34 PM, system manager wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: system manager 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi 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!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- 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: dba interview questions
there are those of us who already worship her wit :) --- Cary Millsap [EMAIL PROTECTED] wrote: Bambi, Be careful. Many will fall in love with you if you continue to submit such things as this to the list. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney - SQL Optimization 101: 12/8-12 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Bellow, Bambi Sent: Thursday, October 23, 2003 4:39 PM To: Multiple recipients of list ORACLE-L Mladen -- I'm *stunned* you missed the most obvious of all DBA 101 questions... What is the average air velocity of an unladen swallow? Bambi. -Original Message- Sent: Thursday, October 23, 2003 4:14 PM To: Multiple recipients of list ORACLE-L 1) What does it mean to grokkk? 2) What is the answer to the question of life, universe and everything? 3) What happened to Sauron when he flipped the bird to Izildur? 4) What is the monolyth and what was its effect on the resident apes? 5) What is damagement? What color of the database saves memory? 6) What can you tell me about lord Edmund Blackadder? Chances are that if someone answers those questions correctly, you've got yourself a worthy DBA. On 10/23/2003 04:14:34 PM, system manager wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: system manager 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list
RE: dba interview questions
Title: RE: dba interview questions 1. 40 hours a week max, right? 2. Bermuda shorts and Hawaiian shirts are considered business casual? 3. What's the daily donut allotment? 4. Health club benefits? (See #3 above) 5. Stock options? 6. Is it OK that my emergency, after-hours phone number starts with 1-900? 7. Salary? Why if you have to ask, you can't afford me. Jerry Whittle ASIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: system manager [SMTP:[EMAIL PROTECTED] Dear List, Can anyone send me a list of dba interview questions? Thanks,
RE: Interview Questions for a Unix Solaris System Admin
-Original Message- you forgot to list the answers :) Waleed Having been a past sys admin, it was difficult to resist the temptation to respond to the initial post. But, since at least one person appears to have taken it as an indication of what kind of sys admin a candidate will be, I could resist no longer. This kind of questioning is sort of like expecting an Oracle DBA to walk up to a box and type out a complete CREATE DATABASE command that is appropriate for whatever version of Oracle is installed on the box. It tests the ability to memorize trivia rather than what you might expect during normal daily operations. Knowing that most facts can be looked up, I would be much more interested in the person's general philosophy of how to manage things. Is the person a control oriented person or a service oriented person? Try to determine if the person tends to take the time to do things right, or if they tend to go for the quick and dirty solution. Even though automation through scripting involves talent that most people do not have (just like most people are not talented musicians even if they learn a lot about music), I would still try to get some idea of how much talent the candidate has. Somebody who is a skilled script writer can, in effect, work 24 hours per day in surrogate form via cron. In general, I would place much less emphasis on the ability to spout off academic facts and more emphasis on practical day to day technique. I think some probing of the candidate's knowledge of backup and recovery is appropriate -- which means you kind of have to learn some of that yourself. I took the liberty of providing what I think are good answers to some of the questions. -Original Message- 1) What is an inode? Bonus: What important piece of file information is NOT stored in the inode? Might be better to ask the pros and cons and having many inodes as opposed to few; circumstances when you would not want to go with the default number you get when you create a file system (never happened when I was a sys admin). Answer: If this file system is to be used for storing an outrageous number of little files, you might consider increasing the number. In the old days when disks were expensive, and you knew that only a few big files were going on the file system, you might get a little more storage by cutting back on the inodes. I think a more practical question would be to ask how to determine if two file names refer to the same file; that is, the names are hard links. Answer: They have the same inode number as displayed by ls -i You could ask for a discussion of soft links versus hard links. For example: - soft links can refer to something on another file system; hard links can't. - a file exists as long as it has at least one hard link; a soft link can point to a non-existent file. - you can rename a file by creating a hard link, then rm the original file name; can't do that with soft links. - a soft link is essentially a file; a hard link is not. You might ask the circumstances under which the admin would AND has used soft links. In the past, I had the unpleasant experience of inheriting servers where the previous admin(s) had made extensive use of soft links resulting in boxes rife with spaghetti file systems. This usually happens because, for one reason or another, a bunch of files need to be moved from one place to another; then instead of fixing whatever uses those files to tell it to go the new location, a soft link to the new location gets created as a quick and dirty solution. These things accumulate, and eventually you have a mess and booby traps ready to blow up. 2) What is priority paging and how does it work? (mildly dated, but useful if they claim to have been around for a while) Never heard of it. Sounds like a term for a type of swapping (lazy versus not lazy). 3) What does sr stand for in vmstat output? man vmstat. vmstat Virtual Memory Statistics: (pagesize = 8192) procs memorypagesintr cpu r w u act free wire fault cow zero react pin pout in sy cs us sy id 10 1K 49 914K 279K 90K 130G 500M 1G 363 615M2 389 44K 3K 17 13 70 Ummm . got no sr here 4) How would I configure the gigabit ethernet interface to force it to be full duplex? I guess if this were a common daily activity, you would want somebody to know how to do this. For most places, you might do this ... o ... maybe once per year ... maybe. 5) How does RAID-5 work? Bonus question: how does raid-4 work? Extra-extra bonus question: how does raid-3 work? Most people will know that it involves stripe with parity; but better, I think, to ask about pros and cons of RAID-5 versus 0+1 (or 1+0). 6) What's the difference between the passwd and the shadow files? This is OK. I think I would phrase it as: What is the purpose of a shadow file. Answer: It's where the encrypted password is
RE: Interview Questions for a Unix Solaris System Admin
Yeah, wellummm...yeah, okay - that was dumb of me. Here they are: 1) What is an inode? Answer: An inode is an on-disk data structure that contains information about a file. Useful things it includes are size, modification time, and number of links that point to it (among other things) Bonus: What is not included in an inode? Answer: The file name. That comes from the referencing directory entry. 2) What is priority paging and how does it work? Answer (short version): Priority paging is a workaround for an irritating VM problem on Solaris 2.6 (and 7? memory escapes me at the moment) where buffered filesystem data was considered equally valued as application memory, and so large amounts of buffered filesystem i/o could actually cause applications to be swapped out. Priority paging, enabled in the /etc/system file, modifies the paging algorithm to reduce the effects of that. It doesn't come by default in solaris 2.6 - you need to install a later kernel patch for it (105181-21? maybe? bueller?) 3)What does sr stand for in vmstat output? Answer: Scan Rate - how often the kernel is sweeping through memory space looking for pages that can be marked inactive. It is not a problem necessarily, but rather an indication of memory pressure. 4) how would I configure the gigabit ethernet interface to force it to be full duplex? Answer: ndd /dev/ge and there's like four parameters you have to set, plus turning the autoneg_cap off. 5) How does raid-5 work? Answer: According to BAARF, poorly. Raid-4? Answer: dedicated parity disk Raid-3? Answer: dedicated parity disk w/ synchronized spindles 6) Difference between passwd and shadow files? Answer: the passwd has a x where the crypted password hash would be, while the hash goes in the shadow file. That's to prevent brute-force space searches for passwords by non-root users. The side effect, though, is that now applications that authenticate users need to be setuid, which opens up other secuity holes. The moral? You can't win. 7) What's the difference between rdsk and dsk? Answer: rdsk is raw, which has two implications - one, its a character device and two, it bypasses the system buffer cache. Bonus: difference between block and character? Answer: character devices take input one character at a time, while block devices take a quantity of data. The system calls for accessing said data also differ, but its too much to write now. 8) How do journaling filesystems work? Answer: by creating a journal, or intent log, about metadata changes that are going to occur to the filesystem. When a crash occurs, the journal is replayed. 9) What's the difference between ssh and telnet? Why is one preferable over the other? Answer: ssh is encrypted, which protects not just against people sniffing your traffic, but it prevents malicious session hijacking as well. There's no justification for telnet anymore - at the point when a cisco router can run ssh, so can your servers. 10) What's the difference between the e4000 and e4500, 6000 and 6500, etc.? Answer: the backplane (and hence, processor) speed. the eX500 series runs at a 100 MHz on the backplane, while the eX000 runs at 83? (not sure). The one exception is the e6500, which runs at 90 MHz normally due to its increased centerplane length. 11) What happens on an E6500 when I add boards in the bottom two slots? Answer: the centerplane steps down again from 90 MHz to 83, making it the same speed as an E6000 at that point. The problem is the length of the centerplane and electrical latencystupid speed of light. 12) On an Sbus e-class I/O tray, what performance considerations do I have to keep in mind when I'm installing Sbus cards? Answer: even though there are three sbus slots in a Sun I/O tray, there are only two controllers. Slot 0 is its own sbus controller, and then slots 1 and 2 share one. So, distribute your heavy vs. low i/o cards accordingly. 13) Why is NIS bad? Answer: no encryption, no strong authentication, no non-repudiation - basically completely devoid of any of the major AAA (Authorization, Authentication, and Accounting) principles of security systems. 14) What's the diff between TCP and UDP? Answer: tcp is connection-oriented, has all sorts of crafty algorithms to improve performance. UDP has none of those things. 15) How does DNS work? Answer: tree-based directory infrastructure, concepts of recursion and authoritative delegation. Too much to write in this email. Bonus: Is DNS TCP or UDP? Answer: Both. DNS requests and responses smaller than 512 bytes are UDP. If for some reason a request results in a 512 byte response, the server sends back a UDP packet with the TC (truncate) bit sent and the client retries using TCP. Also, zone transfers are always TCP. Bleh. There. My secrets are revealed. Good thing I don't have to deal with Solaris much anymore. Thanks, Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359
RE: Interview Questions for a Unix Solaris System Admin
Well, the purpose of the original post was to list a set of questions that, while admittedly academic in that they involve facts, cross 1) a broad cross-section of what a sysadmin might be asked to do and 2) range from easy to difficult. The point is not to know the answer to every question, though if they do, bully for them. The point is for what they don't know, can they use related knowledge they do have to answer the question? I was always far happier when someone said something like, You know, I'm not sure what isn't stored in an inode, but because symbolic links can have their own modification time, I'm going to guess its the modification time rather than I don't know. That is a wrong answer, but the fact that he was able to logic out what is a reasonable conclusion, is the sort of thing I like in people that work for me. It's true, some of the questions are esoterica, but again, its how they answer the question. There's a post I sent that has yet to arrive (in my box anyway) where I answer the questions. For the question about full-duplex, I can't remember the flags you set either - and I'd be fine with anyone who said, You know, I'd man the ge driver and then use ndd to set what I had to. The point is they knew to look up the ge driver and use ndd. Further discussion inline 1) What is an inode? Bonus: What important piece of file information is NOT stored in the inode? Might be better to ask the pros and cons and having many inodes as opposed to few; circumstances when you would not want to go with the default number you get when you create a file system (never happened when I was a sys admin). Very pertinent info snipped You might ask the circumstances under which the admin would AND has used soft links. In the past, I had the unpleasant experience of inheriting servers where the previous admin(s) had made extensive use of soft links resulting in boxes rife with spaghetti file systems. This usually happens because, for one reason or another, a bunch of files need to be moved from one place to another; then instead of fixing whatever uses those files to tell it to go the new location, a soft link to the new location gets created as a quick and dirty solution. These things accumulate, and eventually you have a mess and booby traps ready to blow up. These are equally valid questions, but I have found that by and large, sysadmins might know from reading a book somewhere that you need one inode per file and that hard links and sym links are different, but knowing what an inode is indicates that not only are they aware of all of the above but they can in-depth explain what is happening to the system. 2) What is priority paging and how does it work? (mildly dated, but useful if they claim to have been around for a while) Never heard of it. Sounds like a term for a type of swapping (lazy versus not lazy). Solaris-ism with 2.6 (the original question was for a Solaris admin) 3) What does sr stand for in vmstat output? man vmstat. vmstat Virtual Memory Statistics: (pagesize = 8192) procs memorypages intr cpu r w u act free wire fault cow zero react pin pout in sy cs us sy id 10 1K 49 914K 279K 90K 130G 500M 1G 363 615M2 389 44K 3K 17 13 70 Ummm . got no sr here Apparently you're not on a Solaris system - count yourself lucky. ;) 4) How would I configure the gigabit ethernet interface to force it to be full duplex? I guess if this were a common daily activity, you would want somebody to know how to do this. For most places, you might do this ... o ... maybe once per year ... maybe. I concur - but knowing that you use ndd to get/set network device driver parameters is the real thrust of the question. Asking about gigabit specifically gets into the process. I found that if I asked: How do you get/set network driver parameters in Solaris? The answer I would inevitably get was either I don't know or ndd . Throwing the part in about gigabit makes them think through the whole process, and watching people talk through how they would do something they are unfamiliar with, even in general principles, is very valuable. 5) How does RAID-5 work? Bonus question: how does raid-4 work? Extra-extra bonus question: how does raid-3 work? Most people will know that it involves stripe with parity; but better, I think, to ask about pros and cons of RAID-5 versus 0+1 (or 1+0). Good point. I usually use that as a follow-up question. 6) What's the difference between the passwd and the shadow files? This is OK. I think I would phrase it as: What is the purpose of a shadow file. Answer: It's where the encrypted password is (or can be) stored and is readable only by root. passwd file is world readable. If the encrypted password is visible, it makes it easier to run a cracker against it to
Interview Questions for a Unix Solaris System Admin
I've been asked to interview a system admin candidate for our Solaris shop. I've search Google and altavista, but haven't come up with any after 1999 interview questions. Does anyone have a list of interview question or a link to some? tia M Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo.
RE: Interview Questions for a Unix Solaris System Admin
question #1: Do you realize that your DBA is a God, and you will obey his/her edicts without question? question #2: Are you aware of the daily offering of food/beer required to keep in your God's (DBA's) good graces? etc... Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: M.Godlewski [SMTP:[EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 1:30 PM To: Multiple recipients of list ORACLE-L Subject: Interview Questions for a Unix Solaris System Admin I've been asked to interview a system admin candidate for our Solaris shop. I've search Google and altavista, but haven't come up with any after 1999 interview questions. Does anyone have a list of interview question or a link to some? tia M _ Do you Yahoo!? The New Yahoo! Search http://us.rd.yahoo.com/search/mailsig/*http://search.yahoo.com - Faster. Easier. Bingo. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: Interview Questions for a Unix Solaris System Admin
I've been in the same situation, I had to interview the company's sysadmin, though I am not one. Here you have a few points to start your list. Regards Gabriel The candidate must provide knolwedge about (how to's): 1. Start and stop a solaris system, including several levels of boot (1,2,3, etc). 2. Patch installation. 3. App's installation and configuration (kernel and semaphores). 4. Users creation. 5. Partitions creation. 6. Mount and unmount FileSystems. 7. DNS, IP configuration. 8. Monitoring and performance tuning (process, priorities, memory, disk, etc). 9. Services configuration SMTP, FTP, Internet, secure conections (HTTP, HTTPs). 10. Scripts programming. 11. Establish backup/recovery strategies. Plus: - Define Sun equipment architecture. --- M.Godlewski [EMAIL PROTECTED] wrote: I've been asked to interview a system admin candidate for our Solaris shop. I've search Google and altavista, but haven't come up with any after 1999 interview questions. Does anyone have a list of interview question or a link to some? tia M - Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo. __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gabriel Aragon 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: Interview Questions for a Unix Solaris System Admin
Okay, here are my favorites for senior candidates (I'm giving all my secrets away...): 1) What is an inode? Bonus: What important piece of file information is NOT stored in the inode? 2) What is priority paging and how does it work? (mildly dated, but useful if they claim to have been around for a while) 3) What does sr stand for in vmstat output? 4) How would I configure the gigabit ethernet interface to force it to be full duplex? 5) How does RAID-5 work? Bonus question: how does raid-4 work? Extra-extra bonus question: how does raid-3 work? 6) What's the difference between the passwd and the shadow files? 7) What's the difference between the dsk and rdsk devices in /dev? Bonus question: what's the difference between a block and a character device? 8) How do journaling filesystems work? 9) What's the difference between ssh and telnet? Why is one preferable over the other? 10) What's the difference between the e4000 and the e4500 (or e6000 and e6500, etc. - also a bit dated, but there's still a million of the things out there) 11) What happens on an E6500 when I add boards in the bottom two slots? (I won't ask this if the person has never touched an E6500) 12) On an Sbus e-class I/O tray, what performance considerations do I have to keep in mind when I'm installing Sbus cards? 13) Why is NIS bad? 14) What's the difference between TCP and UDP? 15) How does DNS work? Bonus question: is DNS TCP or UDP? Then I usually throw in some amorphous questions: tell me about a performance problem you tracked down and solved, how do you normally secure a freshly installed Solaris server, etc. Then I follow up with product specific questions - oracle, sun cluster, veritas volume manager, storage, etc. Thanks, Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 http://www.gridapp.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 1:44 PM To: Multiple recipients of list ORACLE-L Subject: RE: Interview Questions for a Unix Solaris System Admin question #1: Do you realize that your DBA is a God, and you will obey his/her edicts without question? question #2: Are you aware of the daily offering of food/beer required to keep in your God's (DBA's) good graces? etc... Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: M.Godlewski [SMTP:[EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 1:30 PM To: Multiple recipients of list ORACLE-L Subject:Interview Questions for a Unix Solaris System Admin I've been asked to interview a system admin candidate for our Solaris shop. I've search Google and altavista, but haven't come up with any after 1999 interview questions. Does anyone have a list of interview question or a link to some? tia M _ Do you Yahoo!? The New Yahoo! Search http://us.rd.yahoo.com/search/mailsig/*http://search.yahoo.com - Faster. Easier. Bingo. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: Matthew Zito 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: Interview Questions for a Unix Solaris System Admin
These are nice questions. I'm not sure how I would identify if they are technical enough to handle the job though.[EMAIL PROTECTED] wrote: question #1: Do you realize that your DBA is a God, and you will obeyhis/her edicts without question?question #2: Are you aware of the daily offering of food/beer required tokeep in your God's (DBA's) good graces?etc...Scott ShaferSan Antonio, TX210.581.6217 -Original Message- From: M.Godlewski [SMTP:[EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 1:30 PM To: Multiple recipients of list ORACLE-L Subject: Interview Questions for a Unix Solaris System Admin I've been asked to interview a system admin candidate for our Solaris shop. I've search Google and altavista, but haven't come up with any after 1999 interview questions. Does anyone have a list of interview question or a link to some?tia ! M _ Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo.-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo.
RE: Interview Questions for a Unix Solaris System Admin
You only spend time on the technical stuff if they pass this round. Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: M.Godlewski [SMTP:[EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 2:20 PM To: Multiple recipients of list ORACLE-L Subject: RE: Interview Questions for a Unix Solaris System Admin These are nice questions. I'm not sure how I would identify if they are technical enough to handle the job though. [EMAIL PROTECTED] wrote: question #1: Do you realize that your DBA is a God, and you will obey his/her edicts without question? question #2: Are you aware of the daily offering of food/beer required to keep in your God's (DBA's) good graces? etc... Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: M.Godlewski [SMTP:[EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 1:30 PM To: Multiple recipients of list ORACLE-L Subject: Interview Questions for a Unix Solaris System Admin I've been asked to interview a system admin candidate for our Solaris shop. I've search Google and altavista, but haven't come up with any after 1999 interview questions. Does anyone have a list of interview question or a link to some? tia ! M _ Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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!? The New Yahoo! Search http://us.rd.yahoo.com/search/mailsig/*http://search.yahoo.com - Faster. Easier. Bingo. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: Interview Questions for a Unix Solaris System Admin
Matthew, Thanks for the list of questions.Matthew Zito [EMAIL PROTECTED] wrote: Okay, here are my favorites for senior candidates (I'm giving all mysecrets away...):1) What is an inode? Bonus: What important piece of file information isNOT stored in the inode?2) What is priority paging and how does it work? (mildly dated, butuseful if they claim to have been around for a while)3) What does sr stand for in vmstat output?4) How would I configure the gigabit ethernet interface to force it tobe full duplex?5) How does RAID-5 work? Bonus question: how does raid-4 work?Extra-extra bonus question: how does raid-3 work?6) What's the difference between the passwd and the shadow files?7) What's the difference between the dsk and rdsk devices in /dev? Bonusquestion: what's the difference between a block and a character device?8) How do journaling filesystems work?9) What's the difference between ss! h and telnet? Why is one preferableover the other?10) What's the difference between the e4000 and the e4500 (or e6000 ande6500, etc. - also a bit dated, but there's still a million of thethings out there)11) What happens on an E6500 when I add boards in the bottom two slots?(I won't ask this if the person has never touched an E6500)12) On an Sbus e-class I/O tray, what performance considerations do Ihave to keep in mind when I'm installing Sbus cards?13) Why is NIS bad?14) What's the difference between TCP and UDP? 15) How does DNS work? Bonus question: is DNS TCP or UDP?Then I usually throw in some amorphous questions: tell me about aperformance problem you tracked down and solved, how do you normallysecure a freshly installed Solaris server, etc. Then I follow up withproduct specific questions - oracle, sun cluster, veritas volumemanager, storage, etc. Thanks,Matt--Matthew ZitoGridApp SystemsEmail: [EMAIL PROTECTED]Cell: 646-220-3551Phone: 212-358-8211 x 359http://www.gridapp.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 1:44 PM To: Multiple recipients of list ORACLE-L Subject: RE: Interview Questions for a Unix Solaris System Admin question #1: Do you realize that your DBA is a God, and you will obey his/her edicts without question? question #2: Are you aware of the daily offering of food/beer required to keep in your God's (DBA's) good graces? etc... Scott Shafer San Antonio, TX 210.581.6217-Original Message- From: M.Godlewski [SMTP:[EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 1:30 PM! To: Multiple recipients of list ORACLE-L Subject: Interview Questions for a Unix Solaris System AdminI've been asked to interview a system admin candidate for our Solaris shop. I've search Google and altavista, but haven't come up with any after 1999 interview questions. Does anyone have a list of interview question or a link to some?tiaM_Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: Matthew ZitoINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo.
RE: Interview Questions for a Unix Solaris System Admin
you forgot to list the answers :) Waleed -Original Message- Sent: Tuesday, July 15, 2003 3:14 PM To: Multiple recipients of list ORACLE-L Okay, here are my favorites for senior candidates (I'm giving all my secrets away...): 1) What is an inode? Bonus: What important piece of file information is NOT stored in the inode? 2) What is priority paging and how does it work? (mildly dated, but useful if they claim to have been around for a while) 3) What does sr stand for in vmstat output? 4) How would I configure the gigabit ethernet interface to force it to be full duplex? 5) How does RAID-5 work? Bonus question: how does raid-4 work? Extra-extra bonus question: how does raid-3 work? 6) What's the difference between the passwd and the shadow files? 7) What's the difference between the dsk and rdsk devices in /dev? Bonus question: what's the difference between a block and a character device? 8) How do journaling filesystems work? 9) What's the difference between ssh and telnet? Why is one preferable over the other? 10) What's the difference between the e4000 and the e4500 (or e6000 and e6500, etc. - also a bit dated, but there's still a million of the things out there) 11) What happens on an E6500 when I add boards in the bottom two slots? (I won't ask this if the person has never touched an E6500) 12) On an Sbus e-class I/O tray, what performance considerations do I have to keep in mind when I'm installing Sbus cards? 13) Why is NIS bad? 14) What's the difference between TCP and UDP? 15) How does DNS work? Bonus question: is DNS TCP or UDP? Then I usually throw in some amorphous questions: tell me about a performance problem you tracked down and solved, how do you normally secure a freshly installed Solaris server, etc. Then I follow up with product specific questions - oracle, sun cluster, veritas volume manager, storage, etc. Thanks, Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 http://www.gridapp.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 1:44 PM To: Multiple recipients of list ORACLE-L Subject: RE: Interview Questions for a Unix Solaris System Admin question #1: Do you realize that your DBA is a God, and you will obey his/her edicts without question? question #2: Are you aware of the daily offering of food/beer required to keep in your God's (DBA's) good graces? etc... Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: M.Godlewski [SMTP:[EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 1:30 PM To: Multiple recipients of list ORACLE-L Subject:Interview Questions for a Unix Solaris System Admin I've been asked to interview a system admin candidate for our Solaris shop. I've search Google and altavista, but haven't come up with any after 1999 interview questions. Does anyone have a list of interview question or a link to some? tia M _ Do you Yahoo!? The New Yahoo! Search http://us.rd.yahoo.com/search/mailsig/*http://search.yahoo.com - Faster. Easier. Bingo. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: Matthew Zito 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: Khedr, Waleed 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
RE: Oracle Interview questions for Implementation/Maintenence
Santosh For maintenance, you might study recommended checklists of regular DBA activities. If you have time, you might pick up a copy of Oracle DBA Checklists Pocket Reference. www.orapub.com http://www.orapub.com has a DBA checklist available for free. For implementation, here are some issues to consider: Database Change Request Date: __ Change Request #: __ Project: Requester: __ Requester Phone: ___ Request is for instance: ___ System: Reason for change: _ Data model change approval: (authorized by division) Date: __ Users/systems/teams affected by change, and how:__ Description of change(s): Table Change __ ___ __ ___ __ ___ __ ___ __ ___ __ ___ New tables: Size (# of rows) Growth pattern (static, load/purge, steady growth, other) ___ ___ static ___ load/purge ___ steady growth ___ ___ static ___ load/purge ___ steady growth ___ ___ static ___ load/purge ___ steady growth ___ ___ static ___ load/purge ___ steady growth ___ ___ static ___ load/purge ___ steady growth Retain existing data? yes no Location of scripts: ___ Requested Date / Time for change implementation: __ Have users/systems/teams been notified? __ This change was successfully implemented in production __ Date: ___ -Original Message- Sent: Monday, March 24, 2003 12:24 AM To: Multiple recipients of list ORACLE-L Hello list, I will be attending interview on oracle..but the position is for Maintenance/Implementation of Software. Could any one of you provide me with set of questions related to maintenance/Implementation issues in oracle ? Regards, Santosh _ http://promos.hotbar.com/promos/promodll.dll?RunPromoEl=hotbar%5felement%3 bst%3bSG=RAND=86682 Upgrade Your Email - Click here! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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).
Oracle Interview questions for Implementation/Maintenence
Hellolist, I will be attending interview on oracle..but the position is for Maintenance/Implementation of Software. Could any one of you provide me with set of questions related to maintenance/Implementation issues in oracle ? Regards, Santosh
OT: SqlServer Interview Questions
I've just been elected to particiate in the candidate interview process for a SQL Server DBA at one of our satelite offices. After 10 years of working with Oracle, the only thing I know about SQL Server is the weekly security advisories for either it or Win 2k. Any tips, links, flames, etc would be appreciated. Thanks, Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The problem with some people is that when they aren't drunk, they're sober. --William Butler Yeats. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: SqlServer Interview Questions
Ask them if they plan on using SQL Servers DTS to load data to/from your Oracle databases? Ask if they are planning on making a linked server to your Oracle databases and how they plan to handle security on it? I also do the SQL Server DBA crap here Dave -Original Message- Sent: Thursday, June 13, 2002 12:22 PM To: Multiple recipients of list ORACLE-L I've just been elected to particiate in the candidate interview process for a SQL Server DBA at one of our satelite offices. After 10 years of working with Oracle, the only thing I know about SQL Server is the weekly security advisories for either it or Win 2k. Any tips, links, flames, etc would be appreciated. Thanks, Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The problem with some people is that when they aren't drunk, they're sober. --William Butler Yeats. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: SqlServer Interview Questions
You can evaluate his / her general attitude about work. Most people give the right answers at first, but you can dig in a bit more to see if they really believe in being organized, etc. Re. SQL Server I don't know enough about it at this point to be helpful, finding practical issues that aren't covered in the MCSE exams would be ideal I think, just to see. My CDN$0.02. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Thursday, June 13, 2002 2:22 PM To: Multiple recipients of list ORACLE-L I've just been elected to particiate in the candidate interview process for a SQL Server DBA at one of our satelite offices. After 10 years of working with Oracle, the only thing I know about SQL Server is the weekly security advisories for either it or Win 2k. Any tips, links, flames, etc would be appreciated. Thanks, Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The problem with some people is that when they aren't drunk, they're sober. --William Butler Yeats. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: SqlServer Interview Questions
Although the site has a problems with there SQL server I would have a look at the notes on the cramsession site for SQL server to give you some guides. Also have a look around the MS site for some bulletins on SQL server problems with there fixes and see what there knowledge is there, Another resource is possibly Techrepublic for general interest stuff on SQL server Try him on routine maintenance things that DBA's should be doing regardless of product. things like index rebuilds, space management, explain plans, etc etc and for a tricky one ask them about the wait interface, can't tell you much about it but it has one and it has a number of wait events that it uses. Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Boivin, Patrice J [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 14-06-2002 10:28 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:RE: SqlServer Interview Questions You can evaluate his / her general attitude about work. Most people give the right answers at first, but you can dig in a bit more to see if they really believe in being organized, etc. Re. SQL Server I don't know enough about it at this point to be helpful, finding practical issues that aren't covered in the MCSE exams would be ideal I think, just to see. My CDN$0.02. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Thursday, June 13, 2002 2:22 PM To: Multiple recipients of list ORACLE-L I've just been elected to particiate in the candidate interview process for a SQL Server DBA at one of our satelite offices. After 10 years of working with Oracle, the only thing I know about SQL Server is the weekly security advisories for either it or Win 2k. Any tips, links, flames, etc would be appreciated. Thanks, Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The problem with some people is that when they aren't drunk, they're sober. --William Butler Yeats. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). STG32488 Description: Binary data
Re: interview questions
It really depends on what the job entails. On Mon, 15 Apr 2002, Maria Aurora VT de la Vega wrote: Hello Gurus. I would like to ask anyone who were at one point worked as Oracle Developers... or anyone who can give their opinion... I will be interviewing applicants for Oracle Developer position. Since I'm the only Oracle person in this shop, I was tasked to handle this interview. I have 0 experience with the use of any Oracle Development tools... And for me, as long as they know how to SQL and PLSQL...and respects their DBA... they're OK. I am not sure if there are other things I should ask.. Inputs Please! thanks. -- Maria Aurora VT de la Vega (OCP) Database Specialist Philippine Stock Exchange, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: interview questions
Maria - Oracle has quite a panoply of development tools, are you looking for someone who is expert in all of them, or can you narrow it down a bit. An old memory may be in order here. Remember the days of time-sharing? If not, look it up. Anyway I worked for a company that offered CDC and Cray services, and decided to get offer IBM services. So they leased a group of IBM computers and interviewed for some experts. The problem is it is really hard to tell an expert from a wannabe if you don't know the area. We got a bunch of wannabes, near as I could tell. For good interview questions, search Google for Oracle Developer Certification. A link I found is: http://www.whizlabs.com/ocp/ocp-1Z0-121-tips.html Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, April 15, 2002 10:43 PM To: Multiple recipients of list ORACLE-L Hello Gurus. I would like to ask anyone who were at one point worked as Oracle Developers... or anyone who can give their opinion... I will be interviewing applicants for Oracle Developer position. Since I'm the only Oracle person in this shop, I was tasked to handle this interview. I have 0 experience with the use of any Oracle Development tools... And for me, as long as they know how to SQL and PLSQL...and respects their DBA... they're OK. I am not sure if there are other things I should ask.. Inputs Please! thanks. -- Maria Aurora VT de la Vega (OCP) Database Specialist Philippine Stock Exchange, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: interview questions
How familiar are they with using trace, tkprof, and tuning the SQL they write? Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Maria Aurora VT de la Vega [SMTP:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 10:43 PM To: Multiple recipients of list ORACLE-L Subject: interview questions Hello Gurus. I would like to ask anyone who were at one point worked as Oracle Developers... or anyone who can give their opinion... I will be interviewing applicants for Oracle Developer position. Since I'm the only Oracle person in this shop, I was tasked to handle this interview. I have 0 experience with the use of any Oracle Development tools... And for me, as long as they know how to SQL and PLSQL...and respects their DBA... they're OK. I am not sure if there are other things I should ask.. Inputs Please! thanks. -- Maria Aurora VT de la Vega (OCP) Database Specialist -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
interview questions
Hello Gurus. I would like to ask anyone who were at one point worked as Oracle Developers... or anyone who can give their opinion... I will be interviewing applicants for Oracle Developer position. Since I'm the only Oracle person in this shop, I was tasked to handle this interview. I have 0 experience with the use of any Oracle Development tools... And for me, as long as they know how to SQL and PLSQL...and respects their DBA... they're OK. I am not sure if there are other things I should ask.. Inputs Please! thanks. -- Maria Aurora VT de la Vega (OCP) Database Specialist Philippine Stock Exchange, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: interview questions
What if one or more of your candidates are members of this list ^_^? I suggest to arrange your questions on level of difficulty, easy to hard to make the candidate feel comfortable A few simple ones Which control to use for what purpose: e.g., mutually exclusive options, more than one option from several options What would you prefer for items that are not updateable, use display item or make text item disabled Medium What to consider while manually joining two blocks Using timer in forms Difficult Checking duplicate on non PK columns in a block Blocks based on procedures HTH! Aleem -Original Message- Sent: Tuesday, April 16, 2002 8:43 AM To: Multiple recipients of list ORACLE-L Subject:interview questions Hello Gurus. I would like to ask anyone who were at one point worked as Oracle Developers... or anyone who can give their opinion... I will be interviewing applicants for Oracle Developer position. Since I'm the only Oracle person in this shop, I was tasked to handle this interview. I have 0 experience with the use of any Oracle Development tools... And for me, as long as they know how to SQL and PLSQL...and respects their DBA... they're OK. I am not sure if there are other things I should ask.. Inputs Please! thanks. -- Maria Aurora VT de la Vega (OCP) Database Specialist Philippine Stock Exchange, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Abdul Aleem INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
possible interview questions
Dear Brian and other gurus ! May i ask U to give a word or two on the topics U mentioned , i.e. How to detect, diagnose, and recover from an instance hang; What do you do when a user calls and says the system is slow or that theycan't connect; How to capture application SQL errors from the db side when the application is not providing a quality ORA-n message. I'll also appreciate very much if other list members could post any possible interview non-trivial questions with some short answers. Thanks a lot in advance. Andre -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: possible interview questions
- Original Message - From: "Andrey Bronfin" I'll also appreciate very much if other list members could post any possible interview non-trivial questions with some short answers. try "Where can one get sample Interview Questions?" from http://www.orafaq.com/faqjobs.htm#INTERVIEWand also browse the list archives - I think this was discussed a month or two ago hth, Marin "...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. "
RE: Developer Interview Questions? - Thanks!
Between all your suggestions and what I'd put together already I think I'm ready for him :). Jay Miller -Original Message- Sent: Friday, February 15, 2002 5:22 PM To: Multiple recipients of list ORACLE-L In addition to SQL tuning, the prospective employee should know what cursor variables are, bind variables, and the advantages of using them. The hopeful candidate should also know how to minimize opening cursors through reuse, or at least not look like a scared deer in the headlights when asked about it. Excellent paper on this by Bjorn Engsig at http://otn.oracle.com/deploy/performance Jared John Kanagaraj [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/15/02 01:38 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Developer Interview Questions? Jay, I would feel that PL/SQL tuning is the same as SQL tuning. Just pull out one of your complicated Explain Plan or TKProf outputs and ask the Interviewee (is there such a word?) to explain the meaning. Also quiz him/her about the various joins and the approach he/she would take when a DBA/User complains of a slow query - If 'trace file', 'tkprof' and 'explain plan' don't appear in the answer, then you may as well stop the interview :) John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Grace - Getting something we don't deserve Mercy - NOT getting something we deserve Click on 'http://www.needhim.org' for Grace and Mercy that is freely available! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- From: Miller, Jay [mailto:[EMAIL PROTECTED]] Sent: Friday, February 15, 2002 10:14 AM To: Multiple recipients of list ORACLE-L Subject: Developer Interview Questions? I've been asked to conduct a technical interview for a new PL/SQL developer, with an emphasis on performance tuning issues (which is why I'm doing it instead of one of the existing developers who seem to have some difficulty with the idea of running something through Explain Plan before sending it to me to go into production - I usually do all the SQL tuning). I've put together a few things but wondered if anyone could point me to a document with some good interview questions (I've only conducted DBA technical interviews in the past). Thanks! Jay Miller x48355 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Developer Interview Questions?
- Original Message - I've put together a few things but wondered if anyone could point me to a document with some good interview questions (I've only conducted DBA technical interviews in the past). check out http://www.orafaq.com/faqjobs.htm#INTERVIEW , especially Download Mike Adult's DBA Interview questions - it contains lots of PL/SQL questions hth, Marin ...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Developer Interview Questions?
I've been asked to conduct a technical interview for a new PL/SQL developer, with an emphasis on performance tuning issues (which is why I'm doing it instead of one of the existing developers who seem to have some difficulty with the idea of running something through Explain Plan before sending it to me to go into production - I usually do all the SQL tuning). I've put together a few things but wondered if anyone could point me to a document with some good interview questions (I've only conducted DBA technical interviews in the past). Thanks! Jay Miller x48355 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).