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

"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.