Re: Is Sr. DBAs afraid of not be able to pass cert exam ??

We didn't necessarily expect someone to know the answer to the problem, but to demonstrate the ability to go about solving the problem, or at least to be able to admit that they didn't have a clue.

Regarding Jr. vs. Sr., etc: We don't really think of Jr. and Sr. We look for people with a certain degree of knowledge and the ability to learn quickly and creatively, and have an understanding that we are here to serve our business community. One candidate was exteremly knowledgable (easily a Sr level) but didn't get the job because when we asked the question about dealing with "difficult" users, his answers displayed a horrible attitude. The OCPs we intrerviewed could not explain how to get the system date using SQL, so OCP isn't a concern for us, either.

"Dusan Bolek" <pagesflames_at_usa.net> wrote in message news:1e8276d6.0202032340.38c36c58_at_posting.google.com...
> "Alan" <alanshein_at_erols.com> wrote in message
news:<a3etp0$17os7k$1_at_ID-114862.news.dfncis.de>...
> > The questions were designed to be able to be answered only by an
experienced
> > person. WOuldn't even necessarily take a LOT of experience.
>
> That depends what's your definition of "an experienced person". I
> think that these questions are very good, if you need a junior DBA to
> join your team.
>
> > #20: CREATE TABLE AS SELECT * did not work. I had to list out the
columns.
> > ALso, it is not necessary to export and imoprt. After the CREATE TABLE,
all
> > you need to do is drop the old table or messa round with the data files.
Any
> > bad blocks are marked as bad automatically.
>
> Hey, but you can't expect that anyone can solve this particular
> problem without some tries. I suppose that you also didn't came to
> server and immediately know that select [columns] would work, but
> select * wouldn't. :-)
> I have also one remark to second part. I'm in IT for years and I think
> that be paranoic is a survival trait in this field. Yes, you can solve
> the problem with bad data block without export and import, but you
> never know what was the origin of this problem.
> If I have a time for downtime, then recreating database, but also
> testing drives for bad blocks can be a good idea. If the problem is in
> HDD, you can be happy that you solve this problem by your way, but
> after week you can have another bad blocks and at that time you may
> not have a luck.
>
> --
> _________________________________________
>
> Dusan Bolek, Ing.
> Oracle team leader
>
> Note: pagesflames_at_usa.net has been cancelled due to changes (maybe we
> can call it an overture to bankruptcy) on that server. I'm still using
> this email to prevent SPAM. Maybe one day I will change it and have a
> proper mail even for news, but right now I can be reached by this
> email.
Received on Mon Feb 04 2002 - 09:18:20 CST