"Alan" <alanshein_at_erols.com> wrote in message news:<a39jih$16hsai$1_at_ID-114862.news.dfncis.de>...
> Here is a list of questions we came up with to ask interviewees. They go
> from easy to hard, mostly. Note that for some of the answers, we expected "I
> don't know", which was an acceptable answer, so long as they could describe
> where they would go to find the answer. Unacceptable answers to the tough
> ones were guesses based on thin air. And yes, some OCPs (with little or no
> experience) could NOT ANSWER question #1!!! I put the question in there as
> an easy one to start with to make the interviewees feel comfortable (same
> with #2). I was shocked when the first interviewee couldn't answer it (#1).
> On #3, these OCPs would always answer with, "I would MONITOR...", whereas
> experienced interviewees answered with "I would DO thus and such..." When
> quizzed further about how they would actually go about SOLVING the problem,
> the OCPs answered, "I would monitor..." again.
>
> Note that the questions are heavily based on skills and knowledge acquired
> during experience, rather than from a book. BTW, can anyone here answer #20?
> (It actually happened to me, but we never expected a real answer, just an
> "I'm not sure, but I would..."). Yes, there may be one or more trick
> questions (with an answer like, "You can't do that")
Hm, that looks easy. Only few of this questions seems a problem for me
and all of them I can solve with quick look in Oracle manuals.
Is strange that you can't get a people to score in these question
well. It seems to me mostly like basic questions that capable DBA
should know answers for. Maybe bigger problem with these question for
me can be a time frame. For example, a question about slow query can
take about half hour to answer, because so many tasks can be done to
solve this problem.
Question #20 looks interesting, I've never encounter this problem.
However, If you can select data from that table you can always do
"create table good_table as select * from bad_table;", so you wouldn't
lost any data. However, after that is a good idea to check all your
datafiles, evacuating data from this one and recreate this tablespace
again. Maybe export and recreating whole database can be also a good
option, because this is looking strange and dangerous.
--
_________________________________________
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 Fri Feb 01 2002 - 09:42:29 CST
