Re: Interview questions for Oracle database administrator

On Sun, 10 Dec 2006 12:12:46 +0100, Michel Cadot wrote:

> 36.. What is difference between SQL and SQL*PLUS?
> | 37.. What is difference between UNIQUE and PRIMARY KEY constraints?
> | 38.. What is difference between Rename and Alias?
> | 39.. What are various joins used while writing SUBQUERIES?
> |
>
> It is an interview questions list for developers not administrators.
> And this is not a good one.
> Nothing about bind variables.
> Nothing about array size, bulk processing.
> Nothing about performances, optimizer, statistics...
> Nothing about concepts, transaction, read consistency, transaction isolation,
> concurrency, locking...
>
> Regards
> Michel Cadot

Questions are vague an plain stupid. Person who asks questions like these when hiring a DBA deserves what they will get. Usually, they will not get a competent administrator. A question about the flight velocity of an unladen swallow would make much more sense. The correct answer would, at least, guarantee a degree of geekiness needed the DBA position. As a matter of fact, I was once asked about the answer to the question of life, universe and everything, in an interview. I was hired.

-- 
http://www.mladen-gogala.com