RE: dba interview questions

[Paul Baumgartel]

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

[Schilling, Ben]

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

RE: dba interview questions

[Jared . Still]

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 

RE: dba interview questions

[Bellow, Bambi]

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

[Govindan K]

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

[Grant Allen]

> -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

[Tim Gorman]

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

[Mladen Gogala]

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

[Niall Litchfield]

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

[Jesse, Rich]

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

[Odland, Brad]

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

[Mladen Gogala]

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  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

[Thater, William]

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  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

[Bellow, Bambi]

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  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

[Stephane Paquette]

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

[Conner, Bill]

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

[Tim Gorman]

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

[Mladen Gogala]

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

[Tanel Poder]

> 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

[Richard Foote]

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

[Sinardy Xing]

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

[Mark Leith]

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

[Bellow, Bambi]

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

[Connor McDonald]

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
> th

RE: RE: dba interview questions

[Jamadagni, Rajendra]

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
--

RE: RE: dba interview questions

[Odland, Brad]

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 s

RE: dba interview questions

[Bellow, Bambi]

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 

Re: Re: dba interview questions

[Tanel Poder]

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
> h

Re: Re[2]: dba interview questions

[Mladen Gogala]

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

[Rachel Carmichael]

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: dba interview questions

[Cary Millsap]

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 p

RE: dba interview questions

[Melanie Caffrey]

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
>

Re[2]: dba interview questions

[Jonathan Gennick]

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

[Cary Millsap]

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

RE: Re: dba interview questions

[April Wells]

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

[Goulet, Dick]

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 messa

RE: RE: dba interview questions

[Scott Canaan]

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 fro

RE: RE: dba interview questions

[Goulet, Dick]

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

Re: dba interview questions

[KENNETH JANUSZ]

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 expres

Re: dba interview questions

[Thomas Day]

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]>


  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: RE: dba interview questions

[rgaffuri]

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

[rgaffuri]

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: dba interview questions

[Mladen Gogala]

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 Cit

Re: dba interview questions

[Wolfgang Breitling]

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: Re: dba interview questions

[rgaffuri]

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: dba interview questions

[DENNIS WILLIAMS]

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: dba interview questions

[Mladen Gogala]

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

[Jamadagni, Rajendra]

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: Re: dba interview questions

[DENNIS WILLIAMS]

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

[Rachel Carmichael]

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: dba interview questions

[Thater, William]

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: Re: dba interview questions

[Kirtikumar Deshpande]

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]

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

[rgaffuri]

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

[Thater, William]

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: dba interview questions

[April Wells]

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

[Thater, William]

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

[Kirtikumar Deshpande]

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

[Mercadante, Thomas F]

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

[Whittle Jerome Contr NCI]

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: dba interview questions

[Rachel Carmichael]

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 mail

RE: dba interview questions

[Rachel Carmichael]

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

RE: dba interview questions

[Eberhard, Jeff]

Category: Init.ora parameters
points: 1000
Answer: It depends!

Category: CBO
points: 1000
Answer: It depends!

RE: dba interview questions

[Bellow, Bambi]

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
--

RE: dba interview questions

[Bellow, Bambi]

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

RE: dba interview questions

[Cary Millsap]

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

RE: dba interview questions

[Ron Thomas]

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 othe

Re: dba interview questions

[AK]

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

[Bellow, Bambi]

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 - Found word(s) to be removed remove free list error email e-mail in the Text body.

[Tony Johnson]

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 Gogala]

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

[Jonathan Gennick]

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).

dba interview questions

[system manager]

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: Interview Questions for a Unix Solaris System Admin

[Matthew Zito]

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).
> 

> 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 v

RE: Interview Questions for a Unix Solaris System Admin

[Matthew Zito]

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
ht

RE: Interview Questions for a Unix Solaris System Admin

[Stephen Lee]

> -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 encry

RE: Interview Questions for a Unix Solaris System Admin

[Khedr, Waleed]

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).
--

RE: Interview Questions for a Unix Solaris System Admin

[M.Godlewski]

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 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).> -- 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

[Scott . Shafer]

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

[M.Godlewski]

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

[Matthew Zito]

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

[Gabriel Aragon]

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

[Scott . Shafer]

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).

Interview Questions for a Unix Solaris System Admin

[M.Godlewski]

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: Oracle Interview questions for Implementation/Maintenence

[DENNIS WILLIAMS]

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   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



  _  

 
 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

[Santosh Varma]

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


 

RE: SqlServer Interview Questions

[Peter . McLarty]

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: SqlServer Interview Questions

[Boivin, Patrice J]

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

[Farnsworth, Dave]

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).

OT: SqlServer Interview Questions

[Ron Thomas]

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: interview questions

[mkshrivastava]

Dear all,

You may get something useful to you in the following links :

http://www.orafaq.com
http://www.orafaq.com/papers/d2kinter.doc


Regds

mks

-- 
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).

RE: interview questions

[Scott . Shafer]

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).

RE: interview questions

[DENNIS WILLIAMS]

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

[Alex]

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

[Abdul Aleem]

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).

interview questions

[Maria Aurora VT de la Vega]

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: possible interview questions

[Marin Dimitrov]

 
- 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#INTERVIEW and 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. 
"

possible interview questions

[Andrey Bronfin]

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: Developer Interview Questions? - Thanks!

[Miller, Jay]

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
--

Re: Developer Interview Questions?

[Marin Dimitrov]

- 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).