Re: ORACLE DBA questions for INTERVIEW

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 Wed Oct 23 2002 - 18:07:11 CDT