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 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://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
