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
- rgaffuri_at_cox.net 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
> <kirtikumar_deshpande_at_yahoo.com>
> > Date: 2003/10/24 Fri AM 09:49:26 EDT
> > To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> > 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 <sysmgr_at_netlimit.com> 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: kirtikumar_deshpande_at_yahoo.com
> >
> > 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: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> ORACLE-L
> > (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: <rgaffuri_at_cox.net
> INET: rgaffuri_at_cox.net
>
> 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: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (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: connor_mcdonald_at_yahoo.com
"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: hamcdc_at_yahoo.co.uk
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: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Sat Oct 25 2003 - 06:39:25 CDT