Oracle professionals continually amaze
me with their versatility and skill, and many Oracle professionals are also
7. Why separate Index and Data
A. 'Cause Oracle says to.
B. 'Cause some people say it doesn't matter, and you want to prove
C. It doesn't matter as long as they are not being accessed at the
D. It does matter, since they will nearly always be accessed at the
E. It doesn't matter, since they won't be accessed at the same time.
F. It depends. It might matter sometimes, and maybe not other
and maybe the few times it does aren't enough to make a difference, or
maybe they do.
G. This can only be determined empirically based on observed I/O
requests, so cannot be predicted ahead of time.
H. This can only be determined empirically, although it can be
mathematically approximated through queuing theory and analysis of
predicted data requests and updates. But it's just too expensive to
do so, so just spread them across logical volumes on a RAID array with
big stripes and stop worrying about it.
14. You are interviewing for a
DBA job, and the interviewer seems to be interested in everything except
A. Use a cold voice to clearly let him know you don't want your
valuable time wasted, and take control of the situation.
B. Gamely explain what great DBA experience you've had and how it can
help this company. Then quote Monty Python and see if he notices.
C. Pick a heavy personal object off the desk and throw it through a
closed window, then make a comment about first having to get the
D. Take off all your clothes, jump up on the desk and sing Ziggy
Stardust at the top of your lungs.
E. Grab your things and leave, but give a complement to and flirt
with the receptionist. Later, call and have her get you in to talk to
CEO about becoming the interviewer's boss.
24. What is a DBA?
A. Someone to blame.
B. It varies by organization.
C. An all-powerful, all-knowing, all-omniscient godlike being beyond
the ken of mortal man.
D. A legal notice required to use a fictitious name.
E. Dumb Big Assbite.
F. Someone who can code really, really well.
29. What is the most
CPU-intensive thing you can do?
A. Flush a buffer.
B. Buff a flusher.
C. Parse a Query.
D. Queer a Parsey.
35. You get an ORA-600, look up
the error on MOSC, don't quite understand it, so post a question on
UseNet. You get nasty replies about not wasting people's time with
homework questions. You:
A. Never use usenet again.
B. Flame each reply.
C. Re-ask the question with more detail.
D. Defensively question the manhood of usenet posters.
E. Spray Diet Coke out of your nose.
F. Open a support call.