I don't think it's a fairplay. The DBA who can't answer the following
questions may know something you don't know.
Why not let the candidates brief how they work as a DBA, like how they
design the DB, how they do backup and recovery and what tuning problems
they've ever met and what's the solution etc., interviewer can judge them
based on their own knowledge and real experience first, then go on with ur
own questions.
"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message
news:3DB72B8C.440097DB_at_exesolutions.com...
> Korilu wrote:
>
> > 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
>
> Depends on whether they have an OCP.
>
> If they have an OCP I'd start with:
> 1. What is the difference between the WHERE CLAUSE and the HAVING CLAUSE
> on a SQL statement?
> 2. What is SQL.BSQ?
> 3. What is the difference between a static and a dynamic cursor and when
> would you choose one over the other?
>
> Then, likely, I'd show them to the door. But if they passed I'd continue
> with questions reserved for those with real experience on their resume.
>
> 4. Describe the most difficult crash and restore you have ever had to
> deal with in great and painful detail.
>
> If none ... out the door again or we continue with:
>
> 5. What dba_ and v$ objects should be available to developers and why?
> 6. Go to the whiteboard and demonstrate your knowledge of ALL ASPECTS of
> the Oracle Security Model.
> 7. Explain the difference between UNDO and ROLLBACK as implemented in
> Oracle 9i and explain why you would use one rather than the other.
> 8. Then I would ask about what they would do if they received a
> half-dozen or so common error messages including ORA-00600 and ORA-01555
> and make sure they understood multiversioning and other basic
> architecture matters.
> 9. A series of questions hardware platform related such as, if a Solaris
> environment, what is in /etc/system and how does it relate to Oracle.
> 10. Finally I'd ask how they feel about not having a life and carrying a
> pager 24 hours a day.
>
> Actual questions might vary widely depending on whether production,
> testing, development, datawarehouse, OLTP, etc. environments.
>
> Daniel Morgan
> http://www.extension.washington.edu/extinfo/certprog/oad/oad_crs.asp
>
Received on Thu Oct 24 2002 - 03:17:10 CDT
