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 specifics"spare 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
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 se
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 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.orafa
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: 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.fat
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:/
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:
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 remov
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: 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
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 w
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: 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: 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).