RE: Help - DBA interview questions I faced

[Dharani Ravi]

Dear Patrice Boivin and other list members,

Thanks for your guidance.  I am in the process of
learning DBA stuff by reading concepts manual and I
will try to experiment using personal oracle.

Thanks and Regards.
Dharan.

--- "Boivin, Patrice J" <[EMAIL PROTECTED]>
wrote:
> Dharan,
> 
> Read the Concepts Manual again.  If you can, go
> through the DBA 101 book and
> perhaps some of those "Starter Kits" Oracle Press
> has been cranking out
> lately.
> 
> Are you administering Oracle database(s) now?  Take
> time to poke around and
> see what is happening.  Create a user account for
> yourself to experiment
> with, being careful not to cripple the rest of the
> system.  You can do that
> by ensuring you don't have rights / privileges that
> give you too much
> freedom on the database.
> 
> To understand, you need to read (know), but you also
> need to practice
> (experience).  Once you will have done both, you
> will have learned from
> mistakes and you will understand what is happening. 
> That will also give you
> a handle on which questions are relevant and which
> are not during
> interviews.  Your next Oracle interview might be
> administered by someone who
> knows little or nothing about Oracle.  (i.e. they
> are looking for a DBA,
> because their previous one left in disgust or they
> never had one).
> 
> If you understand the basics of Oracle and you
> demonstrate during the
> interview that you do not consider saving face
> (putting up appearances)
> being more important than learning and fixing
> problems, you will have an
> honest chance at being hired as a junior DBA.
> 
> At first you will have to live, eat, breathe, dream
> Oracle.  You have to
> decide on this path and never give up.  Never giving
> up is a crucial DBA
> trait.  You have to be more stubborn than the
> server(s) you administer.  You
> also have to be willing to change your approach if
> the previous one didn't
> work, the end result is what you aim for, and it is
> what you keep striving
> for until you get there.  You have to take personal
> responsibility for the
> systems you administer.  You must be reliable.
> 
> 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]
> <mailto:[EMAIL PROTECTED]> 
> 
> 
>   -Original Message-
>   From:   Dharani Ravi [SMTP:[EMAIL PROTECTED]]
>   Sent:   Tuesday, December 25, 2001 7:45 AM
>   To: Multiple recipients of list ORACLE-L
>   Subject:Re: Help - DBA interview questions I faced
> 
>   Dear Rachel,
> 
>   Thanks for your reply.  Initially I felt
> demoralised
>   after reading your  reply.  Truth is always bitter.
> 
>   You are correct.  My Oracle concepts knowledge
> needs
>   to be improved.  I read Oracle 8 concepts manual
> two
>   years ago.  I am working for a small company where
>   there are no seperate DBAs, System Administrators
> and
>   Network Admins.  Only three staff are identified to
>   look after the abovementioned jobs in addition to
>   development job.  Most of our time goes for report
>   generation, foxpro programs and other  activities. 
> I
>   do not have a senior person from whom I can learn
> the
>   job. Jobs like DB creation, maintanence, backup and
>   recovery are done by me and I learned the job from
>   manuals and by experience.  I wanted to work in a
>   production env where I can learn more about DBA
> job. 
>   I need your guidance and seniors guidance from this
>   group.  Hope you will appreciate my position and I
>   sincerely request you to clarify my doubts.  I will
> be
>   grateful to you If you can clarify my mistakes made
> by
>   me in the interview.  I seek the support from this
>   group to develop myself as a DBA.
> 
>   Merry Christmas.
> 
>   Regards.
>   Dharan.
>   --- Rachel Carmichael <[EMAIL PROTECTED]>
> wrote:
>   > Dharan,
>   > 
>   > Answering just those questions will not give you
>   > enough knowledge to
>   > truly be able to answer Oracle questions in an
>   > interview.
>   > 
>   > Based on the answers you gave, it seems to me
> that
>   > you do not
>   > understand the concepts 

Re: Help - DBA interview questions I faced

[Scott Shafer]

Opinions vary, but often involve management "fundament-snorkeling".

--Scott

"Diver down!"


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, December 27, 2001 6:40 AM


I am wondering how such people get into positions where they are responsible
for hiring new staff, if they themselves know nothing.

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: Wednesday, December 26, 2001 7:05 AM
To: Multiple recipients of list ORACLE-L

and eventually, when they realize they can't find that omniscient
person, they come back to reality


--- Robert Chin <[EMAIL PROTECTED]> wrote:
> > I liked the interviews where they told me about their project,
and
> > I told them how I could contribute - strengths and weaknesses.
> > I'm great at *.  I don't know much about YYY, but I'm
willing
> to
> > learn..We cannot know everything.
>
> That worked in the "good old days" (pre-2001), not any more, not
by a
> long shot
> These days one is expected to be EXPERT of everything the
employers
> list
> explicitly and implicitly (which seems to be getting longer...)
plus
> this and
> that
>
> Oracle guru ? you'd wish it's so simple...so Mr Xyz, do you know
SQL
> Server ?
> Sybase ?
> MQ ? Java ? EJB? ASP? Data Warehousing ? data modeling ? Oracle
Apps
> ?
> SAP? Essbase ?  Cognos ? Informatica ?
>
> That's what's so freaky and hedious the job market for hands-on
> techies is.
> You ARE expected to know everything !
>
> Robert Chin
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Robert Chin
>   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).


__
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
  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).


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Scott Shafer
  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: Help - DBA interview questions I faced

[Peter . McLarty]

In some organisations I have worked for you get to be a manager by longevity so you could be a programmer one day and because you stuck it out, the next one your an IT manager for everything IT, Dont laugh one of the guys there now got to be the IT manager just that way. I didnt want to stick it out long enough to see if I could make IT manager

Cheers




--
=
Peter McLarty               E-mail: [EMAIL PROTECTED]
Technical Consultant        WWW: http://www.mincom.com
APAC Technical Services     Phone: +61 (0)7 3303 3461
Brisbane,  Australia        Mobile: +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"

=









"Boivin, Patrice J" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
27/12/2001 10:40 PM
Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Fax to:        
        Subject:        RE: Help - DBA interview questions I faced


I am wondering how such people get into positions where they are responsible
for hiring new staff, if they themselves know nothing.

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-
                 From:                 Rachel Carmichael [SMTP:[EMAIL PROTECTED]]
                 Sent:                 Wednesday, December 26, 2001 7:05 AM
                 To:                 Multiple recipients of list ORACLE-L
                 Subject:                 Re: Help - DBA interview questions I faced

                 and eventually, when they realize they can't find that omniscient
                 person, they come back to reality


                 --- Robert Chin <[EMAIL PROTECTED]> wrote:
                 > > I liked the interviews where they told me about their project,
and
                 > > I told them how I could contribute - strengths and weaknesses.
                 > > I'm great at *.  I don't know much about YYY, but I'm
willing
                 > to
                 > > learn..We cannot know everything.
                 > 
                 > That worked in the "good old days" (pre-2001), not any more, not
by a
                 > long shot
                 > These days one is expected to be EXPERT of everything the
employers
                 > list
                 > explicitly and implicitly (which seems to be getting longer...)
plus
                 > this and
                 > that
                 > 
                 > Oracle guru ? you'd wish it's so simple...so Mr Xyz, do you know
SQL
                 > Server ?
                 > Sybase ?
                 > MQ ? Java ? EJB? ASP? Data Warehousing ? data modeling ? Oracle
Apps
                 > ?
                 > SAP? Essbase ?  Cognos ? Informatica ?
                 > 
                 > That's what's so freaky and hedious the job market for hands-on
                 > techies is.
                 > You ARE expected to know everything !
                 > 
                 > Robert Chin
                 > 
                 > -- 
                 > Please see the official ORACLE-L FAQ: http://www.orafaq.com
                 > -- 
                 > Author: Robert Chin
                 >   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).


                 __
                 Do You Yahoo!?
                 S

Re: Help - DBA interview questions I faced

[Dwayne Cox]

Thanks Patrice!  That was an outstanding synopsis!  And it explains why I am 
behind the curve...I have been a little reluctant (such an understatement) to 
make the time commitment.  Guess there's nothing to it but to do it.  Thanks 
for the encouragement/push!

-D-


On Thursday 27 December 2001 07:55 am, Boivin, Patrice J wrote:
> Dharan,
>
> Read the Concepts Manual again.  If you can, go through the DBA 101 book
> and perhaps some of those "Starter Kits" Oracle Press has been cranking out
> lately.
>
> Are you administering Oracle database(s) now?  Take time to poke around and
> see what is happening.  Create a user account for yourself to experiment
> with, being careful not to cripple the rest of the system.  You can do that
> by ensuring you don't have rights / privileges that give you too much
> freedom on the database.
>
> To understand, you need to read (know), but you also need to practice
> (experience).  Once you will have done both, you will have learned from
> mistakes and you will understand what is happening.  That will also give
> you a handle on which questions are relevant and which are not during
> interviews.  Your next Oracle interview might be administered by someone
> who knows little or nothing about Oracle.  (i.e. they are looking for a
> DBA, because their previous one left in disgust or they never had one).
>
> If you understand the basics of Oracle and you demonstrate during the
> interview that you do not consider saving face (putting up appearances)
> being more important than learning and fixing problems, you will have an
> honest chance at being hired as a junior DBA.
>
> At first you will have to live, eat, breathe, dream Oracle.  You have to
> decide on this path and never give up.  Never giving up is a crucial DBA
> trait.  You have to be more stubborn than the server(s) you administer. 
> You also have to be willing to change your approach if the previous one
> didn't work, the end result is what you aim for, and it is what you keep
> striving for until you get there.  You have to take personal responsibility
> for the systems you administer.  You must be reliable.
>
> Regards,
> Patrice Boivin
> Systems Analyst (Oracle Certified DBA)
>

-- 
Dwayne Cox[EMAIL PROTECTED]
DBA, Development Department,  Info Tech, Inc.
5700 SW 34th Street, Suite 1235   phone: (352) 381.4521
Gainesville, FL  32608 fax: (352) 381.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dwayne Cox
  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: Help - DBA interview questions I faced

[Jared . Still]

Patrice,

This is excellent!  Thanks capsulizing the essence of a DBA.

Make that a *good* DBA.  :)

Jared



   
  
"Boivin, Patrice   
  
J"  To: Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>  
<[EMAIL PROTECTED]   cc:
  
mpo.gc.ca>      Subject: RE: Help - DBA interview 
questions I faced  
Sent by:   
  
[EMAIL PROTECTED]   
  
   
  
   
  
12/27/01 04:55 AM  
  
Please respond to  
  
ORACLE-L   
  
   
  
   
  




Dharan,

Read the Concepts Manual again.  If you can, go through the DBA 101 book
and
perhaps some of those "Starter Kits" Oracle Press has been cranking out
lately.

Are you administering Oracle database(s) now?  Take time to poke around and
see what is happening.  Create a user account for yourself to experiment
with, being careful not to cripple the rest of the system.  You can do that
by ensuring you don't have rights / privileges that give you too much
freedom on the database.

To understand, you need to read (know), but you also need to practice
(experience).  Once you will have done both, you will have learned from
mistakes and you will understand what is happening.  That will also give
you
a handle on which questions are relevant and which are not during
interviews.  Your next Oracle interview might be administered by someone
who
knows little or nothing about Oracle.  (i.e. they are looking for a DBA,
because their previous one left in disgust or they never had one).

If you understand the basics of Oracle and you demonstrate during the
interview that you do not consider saving face (putting up appearances)
being more important than learning and fixing problems, you will have an
honest chance at being hired as a junior DBA.

At first you will have to live, eat, breathe, dream Oracle.  You have to
decide on this path and never give up.  Never giving up is a crucial DBA
trait.  You have to be more stubborn than the server(s) you administer.
You
also have to be willing to change your approach if the previous one didn't
work, the end result is what you aim for, and it is what you keep striving
for until you get there.  You have to take personal responsibility for the
systems you administer.  You must be reliable.

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] <mailto:[EMAIL PROTECTED]>







--
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: Help - DBA interview questions I faced

[Rachel Carmichael]

Ramesh,

Don't be sorry, I just don't want people buying my book and expecting
Gaja and Kirti's wonderful stuff.

Thank you -- we tried hard to make the book a good one. We're in the
beginning stages of revising it for 9i and hope to make it even better.

Rachel

--- [EMAIL PROTECTED] wrote:
> Rachel,
> I'm Sorry for quoting wrong book. Actually I have both books and both
> are 
> excellent!
> 
> Regards,
> Ramesh D Papnoi
> Oracle DBA @ Chemtex Global Engineers Pvt. Ltd., Mumbai, India
> (BrainBench & Brainbuzz Certified Oracle 8/8i DBA & Developer)
> http://www22.Brinkster.com/rpapnoi
> 
> -- Original Text --
> 
> To: internet["Multiple recipients of list ORACLE-L"
> <[EMAIL PROTECTED]>]
> 
> dba 101 is not by gaja and kirti -- that's performance tuning 101
> which
> is indeed an excellent book
> 
> dba 101 is theriault, carmichael and viscusi.
> --- [EMAIL PROTECTED] wrote:
> > Dear Ravi
> > DBA 101 book - BY Gaja and kirti is available in India (indian
> > edition).  I 
> > already have one. Excelent book!!
> > 
> > Regards,
> > Ramesh D Papnoi
> > Oracle DBA @ Chemtex Global Engineers Pvt. Ltd., Mumbai, India
> > (BrainBench & Brainbuzz Certified Oracle 8/8i DBA & Developer)
> > http://www22.Brinkster.com/rpapnoi
> > 
> > -- Original Text --
> > 
> > To: internet["Multiple recipients of list ORACLE-L"
> > <[EMAIL PROTECTED]>]
> > 
> > Dear Rachel,
> > 
> > Thanks for your reply and guidance.  Also thanks to
> > Kirti Deshpande and Jenny Jacobson  for their replies.
> >  In India Oracle DBA 101 book is not yet released. 
> > Once it is released I will defently purchase the book.
> >  
> > 
> > Regarding Question No.1, I told that Server Process is
> > the background process and sysauth or objauth view is
> > used to  check for username and password.  The
> > employer told me that I am wrong.  Could you pl
> > clarify.
> > 
> > 
> > 1)  When you enter 'sqlplus scott/tiger'  which
> > background process checks for authentication ?  From
> > which table/view it checks for authentication ?  If
> > password is wrong from where oracle throws the msg ? 
> > 
> > Regards.
> > Dharan.
> > 
> > 
> > 
> > __
> > Do You Yahoo!?
> > Send your FREE holiday greetings online!
> > http://greetings.yahoo.com
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > -- 
> > Author: Dharani Ravi
> >   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).
> 
> 
> __
> Do You Yahoo!?
> Send your FREE holiday greetings online!
> http://greetings.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Rachel Carmichael
>   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 PROTECTE

RE: Help - DBA interview questions I faced

[Boivin, Patrice J]

I am wondering how such people get into positions where they are responsible
for hiring new staff, if they themselves know nothing.

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] <mailto:[EMAIL PROTECTED]> 


-Original Message-
From:   Rachel Carmichael [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, December 26, 2001 7:05 AM
To: Multiple recipients of list ORACLE-L
Subject:        Re: Help - DBA interview questions I faced

and eventually, when they realize they can't find that omniscient
person, they come back to reality


--- Robert Chin <[EMAIL PROTECTED]> wrote:
> > I liked the interviews where they told me about their project,
and
> > I told them how I could contribute - strengths and weaknesses.
> > I'm great at *.  I don't know much about YYY, but I'm
willing
> to
> > learn..We cannot know everything.
> 
> That worked in the "good old days" (pre-2001), not any more, not
by a
> long shot
> These days one is expected to be EXPERT of everything the
employers
> list
> explicitly and implicitly (which seems to be getting longer...)
plus
> this and
> that
> 
> Oracle guru ? you'd wish it's so simple...so Mr Xyz, do you know
SQL
> Server ?
> Sybase ?
> MQ ? Java ? EJB? ASP? Data Warehousing ? data modeling ? Oracle
Apps
> ?
> SAP? Essbase ?  Cognos ? Informatica ?
> 
> That's what's so freaky and hedious the job market for hands-on
> techies is.
> You ARE expected to know everything !
> 
> Robert Chin
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Robert Chin
>   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).


__
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  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: Help - DBA interview questions I faced

[Boivin, Patrice J]

Dharan,

Read the Concepts Manual again.  If you can, go through the DBA 101 book and
perhaps some of those "Starter Kits" Oracle Press has been cranking out
lately.

Are you administering Oracle database(s) now?  Take time to poke around and
see what is happening.  Create a user account for yourself to experiment
with, being careful not to cripple the rest of the system.  You can do that
by ensuring you don't have rights / privileges that give you too much
freedom on the database.

To understand, you need to read (know), but you also need to practice
(experience).  Once you will have done both, you will have learned from
mistakes and you will understand what is happening.  That will also give you
a handle on which questions are relevant and which are not during
interviews.  Your next Oracle interview might be administered by someone who
knows little or nothing about Oracle.  (i.e. they are looking for a DBA,
because their previous one left in disgust or they never had one).

If you understand the basics of Oracle and you demonstrate during the
interview that you do not consider saving face (putting up appearances)
being more important than learning and fixing problems, you will have an
honest chance at being hired as a junior DBA.

At first you will have to live, eat, breathe, dream Oracle.  You have to
decide on this path and never give up.  Never giving up is a crucial DBA
trait.  You have to be more stubborn than the server(s) you administer.  You
also have to be willing to change your approach if the previous one didn't
work, the end result is what you aim for, and it is what you keep striving
for until you get there.  You have to take personal responsibility for the
systems you administer.  You must be reliable.

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] <mailto:[EMAIL PROTECTED]> 


-Original Message-
From:   Dharani Ravi [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, December 25, 2001 7:45 AM
To: Multiple recipients of list ORACLE-L
    Subject:    Re: Help - DBA interview questions I faced

Dear Rachel,

Thanks for your reply.  Initially I felt demoralised
after reading your  reply.  Truth is always bitter. 
You are correct.  My Oracle concepts knowledge needs
to be improved.  I read Oracle 8 concepts manual two
years ago.  I am working for a small company where
there are no seperate DBAs, System Administrators and
Network Admins.  Only three staff are identified to
look after the abovementioned jobs in addition to
development job.  Most of our time goes for report
generation, foxpro programs and other  activities.  I
do not have a senior person from whom I can learn the
job. Jobs like DB creation, maintanence, backup and
recovery are done by me and I learned the job from
manuals and by experience.  I wanted to work in a
production env where I can learn more about DBA job. 
I need your guidance and seniors guidance from this
group.  Hope you will appreciate my position and I
sincerely request you to clarify my doubts.  I will be
grateful to you If you can clarify my mistakes made by
me in the interview.  I seek the support from this
group to develop myself as a DBA.

Merry Christmas.

Regards.
Dharan.
--- Rachel Carmichael <[EMAIL PROTECTED]> wrote:
> Dharan,
> 
> Answering just those questions will not give you
> enough knowledge to
> truly be able to answer Oracle questions in an
> interview.
> 
> Based on the answers you gave, it seems to me that
> you do not
> understand the concepts behind how Oracle works at
> all.  I would
> suggest you read the documentation (specifically the
> Concepts and
> Administrator's manuals to start) to get a better
> understanding of
> Oracle.
> 
> I would also suggest you talk to the senior DBA
> where you are and ask
> him or her to help you learn about the database.
> 
> Rachel
> 
> --- Dharani Ravi <[EMAIL PROTECTED]> wrote:
> > Dear Seniors,
> > 
> > I am a junior DBA and last weekend I attended a
> > interview for DBA post.  The following questions
> were
> > asked to me and I could not able to answer to the
> > employers satsifac

Re: Help - DBA interview questions I faced

[rpapnoi]

Rachel,
I'm Sorry for quoting wrong book. Actually I have both books and both are 
excellent!

Regards,
Ramesh D Papnoi
Oracle DBA @ Chemtex Global Engineers Pvt. Ltd., Mumbai, India
(BrainBench & Brainbuzz Certified Oracle 8/8i DBA & Developer)
http://www22.Brinkster.com/rpapnoi

-- Original Text --

To: internet["Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>]

dba 101 is not by gaja and kirti -- that's performance tuning 101 which
is indeed an excellent book

dba 101 is theriault, carmichael and viscusi.
--- [EMAIL PROTECTED] wrote:
> Dear Ravi
> DBA 101 book - BY Gaja and kirti is available in India (indian
> edition).  I 
> already have one. Excelent book!!
> 
> Regards,
> Ramesh D Papnoi
> Oracle DBA @ Chemtex Global Engineers Pvt. Ltd., Mumbai, India
> (BrainBench & Brainbuzz Certified Oracle 8/8i DBA & Developer)
> http://www22.Brinkster.com/rpapnoi
> 
> -- Original Text --
> 
> To: internet["Multiple recipients of list ORACLE-L"
> <[EMAIL PROTECTED]>]
> 
> Dear Rachel,
> 
> Thanks for your reply and guidance.  Also thanks to
> Kirti Deshpande and Jenny Jacobson  for their replies.
>  In India Oracle DBA 101 book is not yet released. 
> Once it is released I will defently purchase the book.
>  
> 
> Regarding Question No.1, I told that Server Process is
> the background process and sysauth or objauth view is
> used to  check for username and password.  The
> employer told me that I am wrong.  Could you pl
> clarify.
> 
> 
> 1)  When you enter 'sqlplus scott/tiger'  which
> background process checks for authentication ?  From
> which table/view it checks for authentication ?  If
> password is wrong from where oracle throws the msg ? 
> 
> Regards.
> Dharan.
> 
> 
> 
> __
> Do You Yahoo!?
> Send your FREE holiday greetings online!
> http://greetings.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Dharani Ravi
>   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).


__
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  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).

Re: Help - DBA interview questions I faced

[Rachel Carmichael]

and eventually, when they realize they can't find that omniscient
person, they come back to reality


--- Robert Chin <[EMAIL PROTECTED]> wrote:
> > I liked the interviews where they told me about their project, and
> > I told them how I could contribute - strengths and weaknesses.
> > I'm great at *.  I don't know much about YYY, but I'm willing
> to
> > learn..We cannot know everything.
> 
> That worked in the "good old days" (pre-2001), not any more, not by a
> long shot
> These days one is expected to be EXPERT of everything the employers
> list
> explicitly and implicitly (which seems to be getting longer...)  plus
> this and
> that
> 
> Oracle guru ? you'd wish it's so simple...so Mr Xyz, do you know SQL
> Server ?
> Sybase ?
> MQ ? Java ? EJB? ASP? Data Warehousing ? data modeling ? Oracle Apps
> ?
> SAP? Essbase ?  Cognos ? Informatica ?
> 
> That's what's so freaky and hedious the job market for hands-on
> techies is.
> You ARE expected to know everything !
> 
> Robert Chin
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Robert Chin
>   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).


__
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  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: Help - DBA interview questions I faced

[Rachel Carmichael]

dba 101 is not by gaja and kirti -- that's performance tuning 101 which
is indeed an excellent book

dba 101 is theriault, carmichael and viscusi.
--- [EMAIL PROTECTED] wrote:
> Dear Ravi
> DBA 101 book - BY Gaja and kirti is available in India (indian
> edition).  I 
> already have one. Excelent book!!
> 
> Regards,
> Ramesh D Papnoi
> Oracle DBA @ Chemtex Global Engineers Pvt. Ltd., Mumbai, India
> (BrainBench & Brainbuzz Certified Oracle 8/8i DBA & Developer)
> http://www22.Brinkster.com/rpapnoi
> 
> -- Original Text --
> 
> To: internet["Multiple recipients of list ORACLE-L"
> <[EMAIL PROTECTED]>]
> 
> Dear Rachel,
> 
> Thanks for your reply and guidance.  Also thanks to
> Kirti Deshpande and Jenny Jacobson  for their replies.
>  In India Oracle DBA 101 book is not yet released. 
> Once it is released I will defently purchase the book.
>  
> 
> Regarding Question No.1, I told that Server Process is
> the background process and sysauth or objauth view is
> used to  check for username and password.  The
> employer told me that I am wrong.  Could you pl
> clarify.
> 
> 
> 1)  When you enter 'sqlplus scott/tiger'  which
> background process checks for authentication ?  From
> which table/view it checks for authentication ?  If
> password is wrong from where oracle throws the msg ? 
> 
> Regards.
> Dharan.
> 
> 
> 
> __
> Do You Yahoo!?
> Send your FREE holiday greetings online!
> http://greetings.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Dharani Ravi
>   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).


__
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  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: Help - DBA interview questions I faced

[Rachel Carmichael]

you can get the documentation online.  read it.

according to the publishers, DBA 101 has been released in India.

and it is available on the internet at any of the online book stores


--- Dharani Ravi <[EMAIL PROTECTED]> wrote:
> Dear Rachel,
> 
> Thanks for your reply and guidance.  Also thanks to
> Kirti Deshpande and Jenny Jacobson  for their replies.
>  In India Oracle DBA 101 book is not yet released. 
> Once it is released I will defently purchase the book.
>  
> 
> Regarding Question No.1, I told that Server Process is
> the background process and sysauth or objauth view is
> used to  check for username and password.  The
> employer told me that I am wrong.  Could you pl
> clarify.
> 
> 
> 1)  When you enter 'sqlplus scott/tiger'  which
> background process checks for authentication ?  From
> which table/view it checks for authentication ?  If
> password is wrong from where oracle throws the msg ? 
> 
> Regards.
> Dharan.
> 
> 
> 
> __
> Do You Yahoo!?
> Send your FREE holiday greetings online!
> http://greetings.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Dharani Ravi
>   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).


__
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  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: Help - DBA interview questions I faced

[Dharani Ravi]

Dear Ramesh D Papnoi,

Thanks for the info.  I will buy it.

Regards.
Dharan.
--- [EMAIL PROTECTED] wrote:
> Dear Ravi
> DBA 101 book - BY Gaja and kirti is available in
> India (indian edition).  I 
> already have one. Excelent book!!
> 
> Regards,
> Ramesh D Papnoi
> Oracle DBA @ Chemtex Global Engineers Pvt. Ltd.,
> Mumbai, India
> (BrainBench & Brainbuzz Certified Oracle 8/8i DBA &
> Developer)
> http://www22.Brinkster.com/rpapnoi
> 
> -- Original Text --
> 
> To: internet["Multiple recipients of list ORACLE-L"
> <[EMAIL PROTECTED]>]
> 
> Dear Rachel,
> 
> Thanks for your reply and guidance.  Also thanks to
> Kirti Deshpande and Jenny Jacobson  for their
> replies.
>  In India Oracle DBA 101 book is not yet released. 
> Once it is released I will defently purchase the
> book.
>  
> 
> Regarding Question No.1, I told that Server Process
> is
> the background process and sysauth or objauth view
> is
> used to  check for username and password.  The
> employer told me that I am wrong.  Could you pl
> clarify.
> 
> 
> 1)  When you enter 'sqlplus scott/tiger'  which
> background process checks for authentication ?  From
> which table/view it checks for authentication ?  If
> password is wrong from where oracle throws the msg ?
> 
> 
> Regards.
> Dharan.
> 
> 
> 
> __
> Do You Yahoo!?
> Send your FREE holiday greetings online!
> http://greetings.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Dharani Ravi
>   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).


__
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dharani Ravi
  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] Re: Help - DBA interview questions I faced

[lembark]

-- Robert Chin <[EMAIL PROTECTED]> on 12/25/01 22:30:20 -0800

> 
>> I told them how I could contribute - strengths and weaknesses.
>> I'm great at *.  I don't know much about YYY, but I'm willing to
>> learn..We cannot know everything.
> 
> That worked in the "good old days" (pre-2001), not any more, not by a long
> shot These days one is expected to be EXPERT of everything the employers list

Well, at least you have to know more than the person
asking the questions :-). As a consultant I regularly
run across people who have taken the 20-minute-online-CD
prep and gotten mid-level DBA jobs. Once in they're a 
rather inoperable form of cancer.

I've actually had better luck in most cases by explicitly 
knowing what I don't know. e.g., for Oracle [at least 
slightly on topic] I don't claim to understand all of the
memory managlement and trigger changes from 8.1.X to 9.0.
I also don't claim to know all the foibles of their 
new substitute construction system. This beats not knowing
about it at all.

--
Steven Lembark  2930 W. Palmer
Workhorse Computing  Chicago, IL 60647
   +1 800 762 1582
-- 
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: Help - DBA interview questions I faced

[Robert Chin]

> I liked the interviews where they told me about their project, and
> I told them how I could contribute - strengths and weaknesses.
> I'm great at *.  I don't know much about YYY, but I'm willing to
> learn..We cannot know everything.

That worked in the "good old days" (pre-2001), not any more, not by a long shot
These days one is expected to be EXPERT of everything the employers list
explicitly and implicitly (which seems to be getting longer...)  plus this and
that

Oracle guru ? you'd wish it's so simple...so Mr Xyz, do you know SQL Server ?
Sybase ?
MQ ? Java ? EJB? ASP? Data Warehousing ? data modeling ? Oracle Apps ?
SAP? Essbase ?  Cognos ? Informatica ?

That's what's so freaky and hedious the job market for hands-on techies is.
You ARE expected to know everything !

Robert Chin

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Robert Chin
  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: Help - DBA interview questions I faced

[rpapnoi]

Dear Ravi
DBA 101 book - BY Gaja and kirti is available in India (indian edition).  I 
already have one. Excelent book!!

Regards,
Ramesh D Papnoi
Oracle DBA @ Chemtex Global Engineers Pvt. Ltd., Mumbai, India
(BrainBench & Brainbuzz Certified Oracle 8/8i DBA & Developer)
http://www22.Brinkster.com/rpapnoi

-- Original Text --

To: internet["Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>]

Dear Rachel,

Thanks for your reply and guidance.  Also thanks to
Kirti Deshpande and Jenny Jacobson  for their replies.
 In India Oracle DBA 101 book is not yet released. 
Once it is released I will defently purchase the book.
 

Regarding Question No.1, I told that Server Process is
the background process and sysauth or objauth view is
used to  check for username and password.  The
employer told me that I am wrong.  Could you pl
clarify.


1)  When you enter 'sqlplus scott/tiger'  which
background process checks for authentication ?  From
which table/view it checks for authentication ?  If
password is wrong from where oracle throws the msg ? 

Regards.
Dharan.



__
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dharani Ravi
  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).

Re: Help - DBA interview questions I faced

[Dharani Ravi]

Dear Rachel,

Thanks for your reply and guidance.  Also thanks to
Kirti Deshpande and Jenny Jacobson  for their replies.
 In India Oracle DBA 101 book is not yet released. 
Once it is released I will defently purchase the book.
 

Regarding Question No.1, I told that Server Process is
the background process and sysauth or objauth view is
used to  check for username and password.  The
employer told me that I am wrong.  Could you pl
clarify.


1)  When you enter 'sqlplus scott/tiger'  which
background process checks for authentication ?  From
which table/view it checks for authentication ?  If
password is wrong from where oracle throws the msg ? 

Regards.
Dharan.



__
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dharani Ravi
  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: Help - DBA interview questions I faced

[Jenny Jacobson]

What I have found is that interviewing for an Oracle DBA job is quite
different from doing the actual job.  I've been a contractor - and had to
interview after each gig was over.  

My job consisted of "action" -
entering the commands, people skills, collecting useful scripts "just in
case" - and using them shortly afterwards.  
When a situation came up, it meant going through my spreadsheet of
resources collected over the years.

For interviewing,   it can be more theoretical "bookish" - 
1. What are the four essential background processes and how are they used.
2. How is an "outer join" different from an "inner join".

I liked the interviews where they told me about their project, and
I told them how I could contribute - strengths and weaknesses.
I'm great at *.  I don't know much about YYY, but I'm willing to
learn.

We cannot know everything.  On my last project, we had seven Oracle DBAs.
Each one had something to contribute.  Sometimes I'd know something that
the most seasoned, knowledgeable DBA would not know - because they had
not learned new extensions to existing commands.  

What I do with difficult interviews - when I haven't done well, is to
write down the questions as they are being asked.  Research the answers,
and be better prepared for the next interview.  That's how I got my
start in DBA-land.  I eventually knew most of the answers to most
questions.  I even discovered DBAs who had the wrong answers to their own
interview questions.  What can you do - just keep in mind you're dealing
with human beings.  

You will end up at the job that is best for you - and the client. 

Jenny Jacobson
www.oracle-dba-consulting.com

On Tue, 25 Dec 2001, Dharani Ravi wrote:

> Thanks for your reply.  Initially I felt demoralised
> after reading your  reply.  Truth is always bitter. 
> You are correct.  My Oracle concepts knowledge needs
> to be improved.  I read Oracle 8 concepts manual two

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jenny Jacobson
  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: Help - DBA interview questions I faced

[Rachel Carmichael]

I didn't mean to demoralize you but if you read the manual two years
ago, you need to re-read it. And I do suggest that you play with things
in Oracle and read the manuals to understand what is going on.

I still think you need to do research to get the answers to your
questions but here are some of the answers. And you HAVE to read, we
can't teach you everything you would need to know:

1)  username and password can be found in the dba_users view. The
password is stored encrypted and cannot be manually verified.  Error
messages displayed by the database processes are stored in the files in
the ORACLE_HOME/rdbms/mesg directory

2) The question is misleading as extents are not automatically
allocated to a user when they are assigned to a tablespace. When the
users who have that tablespace as their temporary tablespace need temp
segments, the allocation of extents will be based on the default
storage parameters of the tablespace. If they wanted to know the
maximum space a user could use in that tablespace, you would need to
know the quota that was assigned to them -- in dba_ts_quotas.

3) Redo logs and rollback segments serve two different purposes.
rollback segments are used within the database, to provide a consistent
picture of a changing table to other users or to allow the user making
changes to "rollback" their changes from the database. Redo logs are
used when the database needs to do recovery. Oracle does NOT read the
redo logs while the database is up and open, it only writes to them.

4) of course the rollback segment has something to do with inserts and
imports as long as you are not doing them in nologging mode (even
then, the rbs is written to for system metadata). The only time you
don't write to a rollback segment is when you are doing a select -- and
you might need to read them at that point.

Rollback segments don't have autoextend -- I presume you mean the
tablespace datafiles do not have autoextend. If you cannot get enough
rollback space for the entire insert/import, and you are not doing an
interim commit, you will lose the transaction and the changes you have
made so far will be removed from the database when you fail to extend
the rollback segment. If you have interim commits, you will a) need
less rollback space and b) retain the data that has been committed.

5)  deferred rollback segments are used for transactions in tablespaces
that were taken offline while the transaction was in flight.

6) You cannot change the ownership of the process to the user who
logged into the database because the user is not actually in the
database, but is interfacing with an executing shared program which is
owned by Oracle and therefore the process in the database is owned by
oracle.

7) infrequent commits in a long-running transaction can be the cause of
an 0ra-1555. Most of the time the problem is not that the rollback
segment is too small. You can also have too few rollback segments. In
general though, the problem is in the way the application(s) are coded
and not within the database.

8) the tables are in both memory and the datafiles. 

9) freelists are stored in the segment data block headers, NOT in the
datafile headers


--- Dharani Ravi <[EMAIL PROTECTED]> wrote:
> Dear Rachel,
> 
> Thanks for your reply.  Initially I felt demoralised
> after reading your  reply.  Truth is always bitter. 
> You are correct.  My Oracle concepts knowledge needs
> to be improved.  I read Oracle 8 concepts manual two
> years ago.  I am working for a small company where
> there are no seperate DBAs, System Administrators and
> Network Admins.  Only three staff are identified to
> look after the abovementioned jobs in addition to
> development job.  Most of our time goes for report
> generation, foxpro programs and other  activities.  I
> do not have a senior person from whom I can learn the
> job. Jobs like DB creation, maintanence, backup and
> recovery are done by me and I learned the job from
> manuals and by experience.  I wanted to work in a
> production env where I can learn more about DBA job. 
> I need your guidance and seniors guidance from this
> group.  Hope you will appreciate my position and I
> sincerely request you to clarify my doubts.  I will be
> grateful to you If you can clarify my mistakes made by
> me in the interview.  I seek the support from this
> group to develop myself as a DBA.
> 
> Merry Christmas.
> 
> Regards.
> Dharan.
> --- Rachel Carmichael <[EMAIL PROTECTED]> wrote:
> > Dharan,
> > 
> > Answering just those questions will not give you
> > enough knowledge to
> > truly be able to answer Oracle questions in an
> > interview.
> > 
> > Based on the answers you gave, it seems to me that
> > you do not
> > understand the concepts behind how Oracle works at
> > all.  I would
> > suggest you read the documentation (specifically the
> > Concepts and
> > Administrator's manuals to start) to get a better
> > understanding of
> > Oracle.
> > 
> > I would also suggest you talk to the seni

Re: Help - DBA interview questions I faced

[Dharani Ravi]

Dear Rachel,

Thanks for your reply.  Initially I felt demoralised
after reading your  reply.  Truth is always bitter. 
You are correct.  My Oracle concepts knowledge needs
to be improved.  I read Oracle 8 concepts manual two
years ago.  I am working for a small company where
there are no seperate DBAs, System Administrators and
Network Admins.  Only three staff are identified to
look after the abovementioned jobs in addition to
development job.  Most of our time goes for report
generation, foxpro programs and other  activities.  I
do not have a senior person from whom I can learn the
job. Jobs like DB creation, maintanence, backup and
recovery are done by me and I learned the job from
manuals and by experience.  I wanted to work in a
production env where I can learn more about DBA job. 
I need your guidance and seniors guidance from this
group.  Hope you will appreciate my position and I
sincerely request you to clarify my doubts.  I will be
grateful to you If you can clarify my mistakes made by
me in the interview.  I seek the support from this
group to develop myself as a DBA.

Merry Christmas.

Regards.
Dharan.
--- Rachel Carmichael <[EMAIL PROTECTED]> wrote:
> Dharan,
> 
> Answering just those questions will not give you
> enough knowledge to
> truly be able to answer Oracle questions in an
> interview.
> 
> Based on the answers you gave, it seems to me that
> you do not
> understand the concepts behind how Oracle works at
> all.  I would
> suggest you read the documentation (specifically the
> Concepts and
> Administrator's manuals to start) to get a better
> understanding of
> Oracle.
> 
> I would also suggest you talk to the senior DBA
> where you are and ask
> him or her to help you learn about the database.
> 
> Rachel
> 
> --- Dharani Ravi <[EMAIL PROTECTED]> wrote:
> > Dear Seniors,
> > 
> > I am a junior DBA and last weekend I attended a
> > interview for DBA post.  The following questions
> were
> > asked to me and I could not able to answer to the
> > employers satsifaction.  He asked me around 20
> > questions and the following are the questions
> where I
> > have not fared well.  Could Seniors help me by
> giving
> > the appropriate answers for the following
> questions :
> > 
> > 1)  When you enter 'sqlplus scott/tiger'  which
> > background process checks for authentication ? 
> From
> > which table/view it checks for authentication ? 
> If
> > password is wrong from where oracle throws the msg
> ?
> > (I told server process, but could not remember the
> > dictionary file and error msg file)
> > 
> > 2)  If you create a permanent tablespace and allot
> it
> > to 5 users as temporary tablespace, how many
> extents
> > will be allocated by oracle for each user ?  (I
> > answered that initial and next extent values will
> be
> > alloted to the user.  The employer told that my
> answer
> > is not upto the mark)
> > 
> > 3)  When redo log contains both roll forward and
> > rollback entries, why you require a separate
> rollback
> > segment ?  (I told that redo files are fixed in
> size
> > and will be overwritten for large transaction,
> whereas
> > rbs will grow to accommodate the entire
> transaction if
> > autoextend is on and space is available)
> > 
> > 4)  When you insert or import 8 GB of data and
> your
> > rollback segment is of 100 MB size (without
> > autoextend), then what will happen to the
> transaction
> > ?  During inserts or import what entries will goto
> > rollback segment ? (I told rbs has nothing to do
> with
> > insert or import)
> > 
> > 5)  When deferred rollback segment is used ? ( I
> could
> > not able to answer this question)
> > 
> > 6)  Is it possible to change ownership of Process
> IDs
> > from oracle to the user who have invoked the
> process
> > (for example all scott user processes are owned by
> > Oracle user when you check in unix ps -ef |grep
> oracle
> > command).  Why the PIDs are owned by Oracle
> instead of
> > the user who has invoked it ?  (I answered -
> because
> > the listener starts the process, the ownership is
> > showing as oralce instead of the actual user.  I
> could
> > not able to answer how to change the ownership)
> > 
> > 7)  What are the other reasons for ORA-1555 error
> > except rbs size is small ?
> > 
> > 8)  After starting database, where will the
> dictionary
> > files will reside (memory or system tablespace
> > datafile).  If your answer is memory, then whether
> all
> > the v$ and x$ and other dictionary files are
> loaded in
> > memory ? ( I answered that it depeneds upon the
> size
> > of SGA).
> > 
> > 
> > 9)  Where freelists are stored ?  (I told that it
> is
> > stored in datafile header)
> > 
> > 10)  Is 'direct_io' parameter is equal to raw
> device
> > (I answered that to some extent it is true).
> > 
> > Thanks in advance.
> > Dharan.
> > 
> > 
> > __
> > Do You Yahoo!?
> > Send your FREE holiday greetings online!
> > http://greetings.yahoo.com
> > -- 
> > Please see 

Re: Help - DBA interview questions I faced

[Dharani Ravi]

Dear Rachel,

Thanks for your reply.  Initially I felt demoralised
after reading your  reply.  Truth is always bitter. 
You are correct.  My Oracle concepts knowledge needs
to be improved.  I read Oracle 8 concepts manual two
years ago.  I am working for a small company where
there are no seperate DBAs, System Administrators and
Network Admins.  Only three staff are identified to
look after the abovementioned jobs in addition to
development job.  Most of our time goes for report
generation, foxpro programs and other  activities.  I
do not have a senior person from whom I can learn the
job. Jobs like DB creation, maintanence, backup and
recovery are done by me and I learned the job from
manuals and by experience.  I wanted to work in a
production env where I can learn more about DBA job. 
I need your guidance and seniors guidance from this
group.  Hope you will appreciate my position and I
sincerely request you to clarify my doubts.  I will be
grateful to you If you can clarify my mistakes made by
me in the interview.  I seek the support from this
group to develop myself as a DBA.

Merry Christmas.

Regards.
Dharan.
--- Rachel Carmichael <[EMAIL PROTECTED]> wrote:
> Dharan,
> 
> Answering just those questions will not give you
> enough knowledge to
> truly be able to answer Oracle questions in an
> interview.
> 
> Based on the answers you gave, it seems to me that
> you do not
> understand the concepts behind how Oracle works at
> all.  I would
> suggest you read the documentation (specifically the
> Concepts and
> Administrator's manuals to start) to get a better
> understanding of
> Oracle.
> 
> I would also suggest you talk to the senior DBA
> where you are and ask
> him or her to help you learn about the database.
> 
> Rachel
> 
> --- Dharani Ravi <[EMAIL PROTECTED]> wrote:
> > Dear Seniors,
> > 
> > I am a junior DBA and last weekend I attended a
> > interview for DBA post.  The following questions
> were
> > asked to me and I could not able to answer to the
> > employers satsifaction.  He asked me around 20
> > questions and the following are the questions
> where I
> > have not fared well.  Could Seniors help me by
> giving
> > the appropriate answers for the following
> questions :
> > 
> > 1)  When you enter 'sqlplus scott/tiger'  which
> > background process checks for authentication ? 
> From
> > which table/view it checks for authentication ? 
> If
> > password is wrong from where oracle throws the msg
> ?
> > (I told server process, but could not remember the
> > dictionary file and error msg file)
> > 
> > 2)  If you create a permanent tablespace and allot
> it
> > to 5 users as temporary tablespace, how many
> extents
> > will be allocated by oracle for each user ?  (I
> > answered that initial and next extent values will
> be
> > alloted to the user.  The employer told that my
> answer
> > is not upto the mark)
> > 
> > 3)  When redo log contains both roll forward and
> > rollback entries, why you require a separate
> rollback
> > segment ?  (I told that redo files are fixed in
> size
> > and will be overwritten for large transaction,
> whereas
> > rbs will grow to accommodate the entire
> transaction if
> > autoextend is on and space is available)
> > 
> > 4)  When you insert or import 8 GB of data and
> your
> > rollback segment is of 100 MB size (without
> > autoextend), then what will happen to the
> transaction
> > ?  During inserts or import what entries will goto
> > rollback segment ? (I told rbs has nothing to do
> with
> > insert or import)
> > 
> > 5)  When deferred rollback segment is used ? ( I
> could
> > not able to answer this question)
> > 
> > 6)  Is it possible to change ownership of Process
> IDs
> > from oracle to the user who have invoked the
> process
> > (for example all scott user processes are owned by
> > Oracle user when you check in unix ps -ef |grep
> oracle
> > command).  Why the PIDs are owned by Oracle
> instead of
> > the user who has invoked it ?  (I answered -
> because
> > the listener starts the process, the ownership is
> > showing as oralce instead of the actual user.  I
> could
> > not able to answer how to change the ownership)
> > 
> > 7)  What are the other reasons for ORA-1555 error
> > except rbs size is small ?
> > 
> > 8)  After starting database, where will the
> dictionary
> > files will reside (memory or system tablespace
> > datafile).  If your answer is memory, then whether
> all
> > the v$ and x$ and other dictionary files are
> loaded in
> > memory ? ( I answered that it depeneds upon the
> size
> > of SGA).
> > 
> > 
> > 9)  Where freelists are stored ?  (I told that it
> is
> > stored in datafile header)
> > 
> > 10)  Is 'direct_io' parameter is equal to raw
> device
> > (I answered that to some extent it is true).
> > 
> > Thanks in advance.
> > Dharan.
> > 
> > 
> > __
> > Do You Yahoo!?
> > Send your FREE holiday greetings online!
> > http://greetings.yahoo.com
> > -- 
> > Please see 

Re: Help - DBA interview questions I faced

[Dharani Ravi]

Dear Rachel,

Thanks for your reply.  Initially I felt demoralised
after reading your  reply.  Truth is always bitter. 
You are correct.  My Oracle concepts knowledge needs
to be improved.  I read Oracle 8 concepts manual two
years ago.  I am working for a small company where
there are no seperate DBAs, System Administrators and
Network Admins.  Only three staff are identified to
look after the abovementioned jobs in addition to
development job.  Most of our time goes for report
generation, foxpro programs and other  activities.  I
do not have a senior person from whom I can learn the
job. Jobs like DB creation, maintanence, backup and
recovery are done by me and I learned the job from
manuals and by experience.  I wanted to work in a
production env where I can learn more about DBA job. 
I need your guidance and seniors guidance from this
group.  Hope you will appreciate my position and I
sincerely request you to clarify my doubts.  I will be
grateful to you If you can clarify my mistakes made by
me in the interview.  I seek the support from this
group to develop myself as a DBA.

Merry Christmas.

Regards.
Dharan.
--- Rachel Carmichael <[EMAIL PROTECTED]> wrote:
> Dharan,
> 
> Answering just those questions will not give you
> enough knowledge to
> truly be able to answer Oracle questions in an
> interview.
> 
> Based on the answers you gave, it seems to me that
> you do not
> understand the concepts behind how Oracle works at
> all.  I would
> suggest you read the documentation (specifically the
> Concepts and
> Administrator's manuals to start) to get a better
> understanding of
> Oracle.
> 
> I would also suggest you talk to the senior DBA
> where you are and ask
> him or her to help you learn about the database.
> 
> Rachel
> 
> --- Dharani Ravi <[EMAIL PROTECTED]> wrote:
> > Dear Seniors,
> > 
> > I am a junior DBA and last weekend I attended a
> > interview for DBA post.  The following questions
> were
> > asked to me and I could not able to answer to the
> > employers satsifaction.  He asked me around 20
> > questions and the following are the questions
> where I
> > have not fared well.  Could Seniors help me by
> giving
> > the appropriate answers for the following
> questions :
> > 
> > 1)  When you enter 'sqlplus scott/tiger'  which
> > background process checks for authentication ? 
> From
> > which table/view it checks for authentication ? 
> If
> > password is wrong from where oracle throws the msg
> ?
> > (I told server process, but could not remember the
> > dictionary file and error msg file)
> > 
> > 2)  If you create a permanent tablespace and allot
> it
> > to 5 users as temporary tablespace, how many
> extents
> > will be allocated by oracle for each user ?  (I
> > answered that initial and next extent values will
> be
> > alloted to the user.  The employer told that my
> answer
> > is not upto the mark)
> > 
> > 3)  When redo log contains both roll forward and
> > rollback entries, why you require a separate
> rollback
> > segment ?  (I told that redo files are fixed in
> size
> > and will be overwritten for large transaction,
> whereas
> > rbs will grow to accommodate the entire
> transaction if
> > autoextend is on and space is available)
> > 
> > 4)  When you insert or import 8 GB of data and
> your
> > rollback segment is of 100 MB size (without
> > autoextend), then what will happen to the
> transaction
> > ?  During inserts or import what entries will goto
> > rollback segment ? (I told rbs has nothing to do
> with
> > insert or import)
> > 
> > 5)  When deferred rollback segment is used ? ( I
> could
> > not able to answer this question)
> > 
> > 6)  Is it possible to change ownership of Process
> IDs
> > from oracle to the user who have invoked the
> process
> > (for example all scott user processes are owned by
> > Oracle user when you check in unix ps -ef |grep
> oracle
> > command).  Why the PIDs are owned by Oracle
> instead of
> > the user who has invoked it ?  (I answered -
> because
> > the listener starts the process, the ownership is
> > showing as oralce instead of the actual user.  I
> could
> > not able to answer how to change the ownership)
> > 
> > 7)  What are the other reasons for ORA-1555 error
> > except rbs size is small ?
> > 
> > 8)  After starting database, where will the
> dictionary
> > files will reside (memory or system tablespace
> > datafile).  If your answer is memory, then whether
> all
> > the v$ and x$ and other dictionary files are
> loaded in
> > memory ? ( I answered that it depeneds upon the
> size
> > of SGA).
> > 
> > 
> > 9)  Where freelists are stored ?  (I told that it
> is
> > stored in datafile header)
> > 
> > 10)  Is 'direct_io' parameter is equal to raw
> device
> > (I answered that to some extent it is true).
> > 
> > Thanks in advance.
> > Dharan.
> > 
> > 
> > __
> > Do You Yahoo!?
> > Send your FREE holiday greetings online!
> > http://greetings.yahoo.com
> > -- 
> > Please see 

Re: Help - DBA interview questions I faced

[Rachel Carmichael]

Dharan,

Answering just those questions will not give you enough knowledge to
truly be able to answer Oracle questions in an interview.

Based on the answers you gave, it seems to me that you do not
understand the concepts behind how Oracle works at all.  I would
suggest you read the documentation (specifically the Concepts and
Administrator's manuals to start) to get a better understanding of
Oracle.

I would also suggest you talk to the senior DBA where you are and ask
him or her to help you learn about the database.

Rachel

--- Dharani Ravi <[EMAIL PROTECTED]> wrote:
> Dear Seniors,
> 
> I am a junior DBA and last weekend I attended a
> interview for DBA post.  The following questions were
> asked to me and I could not able to answer to the
> employers satsifaction.  He asked me around 20
> questions and the following are the questions where I
> have not fared well.  Could Seniors help me by giving
> the appropriate answers for the following questions :
> 
> 1)  When you enter 'sqlplus scott/tiger'  which
> background process checks for authentication ?  From
> which table/view it checks for authentication ?  If
> password is wrong from where oracle throws the msg ?
> (I told server process, but could not remember the
> dictionary file and error msg file)
> 
> 2)  If you create a permanent tablespace and allot it
> to 5 users as temporary tablespace, how many extents
> will be allocated by oracle for each user ?  (I
> answered that initial and next extent values will be
> alloted to the user.  The employer told that my answer
> is not upto the mark)
> 
> 3)  When redo log contains both roll forward and
> rollback entries, why you require a separate rollback
> segment ?  (I told that redo files are fixed in size
> and will be overwritten for large transaction, whereas
> rbs will grow to accommodate the entire transaction if
> autoextend is on and space is available)
> 
> 4)  When you insert or import 8 GB of data and your
> rollback segment is of 100 MB size (without
> autoextend), then what will happen to the transaction
> ?  During inserts or import what entries will goto
> rollback segment ? (I told rbs has nothing to do with
> insert or import)
> 
> 5)  When deferred rollback segment is used ? ( I could
> not able to answer this question)
> 
> 6)  Is it possible to change ownership of Process IDs
> from oracle to the user who have invoked the process
> (for example all scott user processes are owned by
> Oracle user when you check in unix ps -ef |grep oracle
> command).  Why the PIDs are owned by Oracle instead of
> the user who has invoked it ?  (I answered - because
> the listener starts the process, the ownership is
> showing as oralce instead of the actual user.  I could
> not able to answer how to change the ownership)
> 
> 7)  What are the other reasons for ORA-1555 error
> except rbs size is small ?
> 
> 8)  After starting database, where will the dictionary
> files will reside (memory or system tablespace
> datafile).  If your answer is memory, then whether all
> the v$ and x$ and other dictionary files are loaded in
> memory ? ( I answered that it depeneds upon the size
> of SGA).
> 
> 
> 9)  Where freelists are stored ?  (I told that it is
> stored in datafile header)
> 
> 10)  Is 'direct_io' parameter is equal to raw device
> (I answered that to some extent it is true).
> 
> Thanks in advance.
> Dharan.
> 
> 
> __
> Do You Yahoo!?
> Send your FREE holiday greetings online!
> http://greetings.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Dharani Ravi
>   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).


__
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  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 subscr