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, if they cannot answer these questions, likely I would show them to the door. But if they passed I would 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 inOracle 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.
No comments:
Post a Comment