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" <BoivinP_at_mar.dfo-mpo.gc.ca>
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: boivinp_at_mar.dfo-mpo.gc.ca
> <mailto:boivinp_at_mar.dfo-mpo.gc.ca>
>
>
> -----Original Message-----
> From: Dharani Ravi [SMTP:dharan71_at_YAHOO.COM]
> 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 <wisernet100_at_yahoo.com>
> 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 <dharan71_at_yahoo.com> 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
>
=== message truncated ===
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: dharan71_at_yahoo.com
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: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Thu Dec 27 2001 - 22:14:10 CST