RE: interview question ???

I like Tom Kyte's suggestion:

Here's a pencil and paper. Diagram out Oracle for me. Show me the various sets of files, and the different processes that make up the instance. Breifly explain what type of information is in each file or set of files, and the purpose of the various background processes.

Now, THAT is a question you really can't worm your way out of. Either you know it or you don't. And if you don't, you don't have any business passing yourself off as an Oracle DBA.

-Mark

On Mon, 2002-10-14 at 20:58, Rachel Carmichael wrote:
> reminds me of my most favorite BAD review of DBA 101:
>
> "I consider myself as an Oracle DBA beginner and want to lie on my
> resume. Though I have completed the whole book I still feel confused
> about the Oracle architecture and basic Oracle DBA commands. This book
> is not a good reference book for a starter. Besides, this book doesn't
> cover some preliminary but important topics such as Oracle Network and
> background processes. If you just like me want to cheat on your resume
> to get a DBA job, get a different book. "
>
> I just wanted to write and say THANK YOU!
>
> This is why I ask interview questions like "tell me your worst
> nightmare experience and how you resolved it". They can't cheat that
> answer.
>
>
>
> --- "Johnston, Tim" <TJohnston_at_quallaby.com> wrote:
> > Seems in line to me... There is a big difference between "Help me
> > with this
> > problem at my current job" and "Help get this job that I'm not
> > qualified
> > for"...
> >
> > Tim
> >
> > -----Original Message-----
> > Sent: Monday, October 14, 2002 6:29 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Is this for a job interview?
> >
> > I for one, am not going to help proliferate the number of DBA's
> > that don't know what they're doing, when there are many available
> > that do.
> >
> > If I'm way out of line here, then let me know, but this sure looks
> > like
> > a good opportunity to recommend some RTFM.
> >
> > Jared
> >
> >
> >
> >
> >
> >
> > Leslie Lu <leslie_y_lu_at_yahoo.com>
> > Sent by: root_at_fatcity.com
> > 10/14/2002 02:43 PM
> > Please respond to ORACLE-L
> >
> >
> > To: Multiple recipients of list ORACLE-L
> > <ORACLE-L_at_fatcity.com>
> > cc:
> > Subject: interview question ???
> >
> >
> > Hi,
> >
> > My agent asked me these couple of questions through
> > email, can any one give me some idea? Thank you!
> >
> > Leslie
> >
> > -----------------------
> > What are a couple ways to detect block corruption
> > within an oracle database?
> >
> > What is the wait interface?
> >
> > What v$view would you query to get a list of database
> > files that need to be backed up?
> >
> >
> >
> > __________________________________________________
> > Do you Yahoo!?
> > Faith Hill - Exclusive Performances, Videos & More
> > http://faith.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Leslie Lu
> > INET: leslie_y_lu_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.com
> > --
> > Author:
> > INET: Jared.Still_at_radisys.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.com
> > --
> > Author: Johnston, Tim
> > INET: TJohnston_at_quallaby.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).
>
>
> __________________________________________________
> Do you Yahoo!?
> Faith Hill - Exclusive Performances, Videos & More
> http://faith.yahoo.com

-- 
--
Mark J. Bobak
Oracle DBA
mark_at_bobak.net
"It is not enough to have a good mind.  The main thing is to use it
well."
 						-- Rene Descartes
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark J. Bobak
  INET: mark_at_bobak.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).