Re: ORACLE DBA questions for INTERVIEW

Hi Daniel,

Tough.

Although I should be right for the challenge providing you've got a really big whiteboard ;)

Cheers

Richard
"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 - 08:25:28 CDT