Re: ORACLE DBA questions for INTERVIEW

I liked your idea. You should asked the guy what he have done and ask him what he is familar, and see how much he understands the topic he said he has experience. Database is such a huge object, each person has different experience, it is very unfair to judge people just by a few questions. He does not have to know anything you pick ramdomly from a DBA manual. But he should know the things that he has been working.

We interviewed a guy recently.
First I asked him whether he has experience with transportable tablespace. He said he does not. I stopped ask him.

Then I asked him does he use local managed tablespace. he said yes, then I asked him when you created LMT, there is two options, AutoAllocate and uniform size, what is the difference between them?

Then I asked him whether he has done transfering a regular table into a partitioned table, he said yes. In 9i, he said, you can use dbms_redef. Describe the steps you did it, what did you change your indexes script so that it can be created on a partitioned table? Sometime the indexes creation is so slow, how do you speed it up? Do you know what is happening behind scence when you are using dbms_redef? What will you do if the process failed in the middle of redef?

I asked him whether he has done some performance tuning? He said yes, where would you start if somebody complains the database is slow?

"D.Y." <dyou98_at_aol.com> wrote in message news:f369a0eb.0210241302.24b9e1ba_at_posting.google.com...
> If you are trying to fill a junior level position, it's perfectly
> OK to bring a list of SQLPLUS, SQL, PL/SQL, and basic DBA questions
> to the interview and ask the candidate to answer them. You just want
> to make sure the person you bring in can start doing some work. For
> this purpose you can just take some examples from the Oracle manuals.
>
> If you are filling a senior level position you don't want to waste
> too much time on the basic stuff. For this type of candidates I
> always start by asking them to describe a couple of the major projects
> they designed and implemented, some of the difficult problems they
> encountered, and how they solved those problems. During this process
> I would ask questions and get into some of the details to find out if
> they have a good understanding of the features, development techniques,
> performance considerations, etc. that were involved in their projects.
>
> Also consider some non-technical aspects of the candidate such as
> personality, attitude, whether you feel they can come in and learn the
> things they need to learn to become an important part of the team, or
> if you want someone who smokes or likes to go to happy hours, etc.
>
> lg510_at_aol.comnomas (Korilu) wrote in message
news:<20021023182651.19979.00004240_at_mb-fj.aol.com>...
> > What would you ask an ORACLE DBA candidate??
> > (Also send answers if possible to your questions)
> >
> > Is there a location where I can find this type of information?
> >
> > I will post all the results here.
> >
> > Thanks
Received on Thu Oct 24 2002 - 20:00:17 CDT