World's fourth silliest DBA test [humor]
Joel Garry
test. You have fifteen minutes.
1. The pinhitratio in v$librarycache on your production OLTP instance
is 94%.
A. According to Oracle, this is lower than a well-tuned system.
B. According to Oracle, this is well-striven towards a well-tuned
machine.
C. Damn ratios don't mean a thing, look at latches.
D. This ratio can be easily manipulated, and might be meaningful
given more information.
E. All of the above.
2. What is wrong with this listener file?
LISTENER=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) HOST=GR89C0072)
(PORT=1521)
(PROTOCOL_STACK =
(PRESENTATION = ttc)
(SESSION = NS)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = GR89C0072)
(ORACLE_HOME = C:\V8I)
(SID_NAME=DBA)
)
)
A. It is perfectly correct
B. It looks perfectly correct, but may have invisible characters that
make it unusable.
c. GLOBAL_DBNAME will mess up 9iAS, so you can't use this.
D. Windows XP will screw up the registry and you will have to
reinstall everything after installing
another operating system to get at your data first.
E. Nobody uses hostnaming with Windows servers.
F. You must use 4 characters in an SID.
3. You have tcp dispatchers with mts. Add more dispatchers if:
A. the busy rate is over 1%
B. the busy rate is over 10%
C. the busy rate is over 50%
D. get rid of MTS since you have a performance problem.
E. Don't do anything until you determine how long users are waiting.
4. A client receives the ORA-3113 error.
A. The Names Server is down.
B. The Listener is down.
C. Dammit, haven't we answered this enough in this group?
D. The Connection Manager died.
E. I thought that was just a .sig file joke.
5. Bill Gates, Larry Ellison and Scott McNealy all arrive at a rave
at the same time.
A. Steve Jobs gives them all Ecstasy and they have a big love fest.
B. They all get drunk and start a huge fight, breaking the mirror
behind
the bar.
C. Their WIFI's attempt to overpower each other, sending
commands that crash any database software attached to the net.
D. Bill Joy has mutated into a giant worm and he comes up and
swallows
the club from below.
6. You are in a toilet stall in a company restroom, and a little pull
on the
toilet paper sends the only two rolls of toilet paper carreening
around
the bathroom. You:
A. pull up your pants, exit the stall as if nothing happened.
B. make sounds so other people think you are having a wild affair so
they
get embarrassed and leave, then get the paper back.
C. start singing "Under The Boardwalk" and hope people start throwing
things.
D. adjust rollback segments to autoextend, set optimal to 32, flush,
and
wait for SMON to give you the paper back.
E. Use the first bills in your wallet, since they are ordered
smallest to
largest.
7. Why separate Index and Data tablespaces?
A. 'Cause Oracle says to.
B. 'Cause some people say it doesn't matter, and you want to prove
them
wrong.
C. It doesn't matter as long as they are not being accessed at the
same
time.
D. It does matter, since they will nearly always be accessed at the
same
time.
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 times
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.
8. The database has crashed due to too many transactions for the
number of
transaction slots. A tablespace cannot be brought online as a result.
The system rollback segment is in "needs recovery" mode. What do you
do?
A. Lock 'n load, this puppy needs to be put out of my misery.
B. Bring the db up with no rbs in the init.ora, be sure the system
tablespace has enough room for a deffered rollback segment, leave the
db
open for a few hours while SMON changes the rbs status.
C. Set a trace to determine which transaction last succeeded, restore
from backups and roll forward until that transaction.
D. Can't do anything because a ts was bought offline during the
original
transaction, so trying to roll forward will bring that ts online and
leave
it to mess everything up, so must restore from backups and that's it.
E. None of the above.
F. Depends on the version.
9. Your hardware person has decided to replace the RAID with a faster
device.
After doing so, he creates all the same mount points that were there
before, temporarily mounting the old RAID with all the same mount
points
with "old" prepended to them. He uses cpio to copy the files from
the
old to the new, getting an error about not being able to create files
larger than 2G.
A. Enable large files.
B. cpio can't handle more than 2G files, just use cp -pr. Carefully.
C. WTF? There's more to the universe than unix!
D. Reinstall and reconfigure Oracle.
E. You'll have to cp each file and use the alter database rename
file command.
10. You are doing an upgrade that requires several hours of data
manipulation
after cloning a database. Backups also take several hours.
A. You must backup after cloning, else you won't be able to restore.
B. You might as well backup after the data manipulation, since if
things
blow up, you can just clone again. All you care about restoring is
transactions after the manipulation.
C. You just sing "Send in, the Clones!"
D. Let the junior DBA backup unnecessarily, so they feel worth
something
and you can catch some Z's.
E. None of the above.
11. You look at the dates on your files, and see some that are very
old.
Does this mean they can be deleted?
A. Of course.
B. Well, of course, except for configuration files and executables.
C. No way, some kinds of tempfiles might be created long before they
are accessed, and don't get touched again until sort files need them.
D. They aren't _my_ files, they belong to the company.
E. Anything deleted becomes necessary.
12. You check v$session before shutting down your production instance
to
be sure everyone is off. You see there is a machine logged on, and
open a streaming video channel to see if there is anyone actually
there.
There are several people doing compromising things, apparently not
realizing they are on camera. Do you:
A. Alter database kill session, shutdown, then watch the video.
B. Watch the video.
C. Record the video and start polishing your raise speech.
D. Go to the office, act surprised, then join in.
E. Redirect video to the web and announce on IRC.
F. Ring the phone and say "We know what you're doing!" in your best
"reality TV show announcer" impression.
G. E and D.
13. If you could be any tree, which would it be?
A. A towering oak.
B. A majestic palm.
C. A Bee tree.
D. A Pineapple.
E. A Weeping Willow.
14. You are interviewing for a DBA job, and the interviewer seems to
be
interested in everything except you. You:
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
mule's
attention.
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 the
CEO about becoming the interviewer's boss.
15. You are in a restaurant, and overhear the people at the next
table
talking about rollback segments. You:
A. Pointedly ignore them.
B. Walk over, introduce yourself, and join in the conversation.
C. Walk over, acuse them of posting misinformation on cdoserver,
then eat their food after they run off scared.
D. Yell "Hey, is there a nerd in the house?"
E. Yell "Hey, you guys need a real DBA over there?"
16. You are in a high-powered DBA conference session given by a
famous
lecturer, mumbling the answers to each question as he asks them. The
person next to you seems to be more and more impressed by this, and
finally leans over and offers you a job at a dot.com. You say:
A. [Loud Curly voice] "Why, Soitenly! Nyuk Nyuk!"
B. "Mr. Feynman, you must be joking."
C. Nothing, stare curiously, and keep mumbling the answers.
D. "Points, options, 250K, no dress code, own hours, T1, Porsche,
expenses."
E. A few pleasantries, exchange cards, wait a few months, swoop in
on bankruptcy for your own personal Superdome.
17. Your 9iR2 production database crashes at 4:00PM on Friday. It
tries to
come up but seems to be stuck. You:
A. Wait and wait and wait and hope. Go to happy hour for the free
food,
come back and wait and hope some more.
B. Wait till after 5, then call Oracle support in the hope you'll
get someone fresh in another time zone.
C. CTRL-C, shutdown, startup mount, drop sort ts, then open.
D. Post a HELP!!!!!! message on usenet.
E. Restore last backup and fast roll forward.
F. None of the above.
18. You are perusing usenet, and you see a post from a respected
source that
is at odds with your own production db. You:
A. Immediately scour metalink and numerous other sites for more
information.
B. Post off-the-cuff rant on why the respected source is wrong.
C. Look it up on your OCP cd.
D. Attempt to replicate issue on your test db.
E. All of the above.
F. Some of the above.
19. You are the new, sole DBA at a site. The first thing you do is:
A. Get the OCP.
B. Get the CSI.
C. Get the SYS password.
D. Meet the SA.
E. Establish the pecking order.
20. A user calls up and asks for his password. You:
A. Tell him to go through channels, put him on hold and call
security.
B. Check init.ora parameters.
C. Tell him to look on his terminal.
D. Tell him to tell you what it he wants it to be, and that you will
change it.
E. Give him the password to an account with OPS$ sysdba and tell him
to change it himself.
F. Set the account to ask for the password next time he logs in.
21. A programmer gives you a package to install. You install it in a
test
system, and see that it has a really strange set of grants back and
forth between two schemata.
A. Give it back and say "Do it over."
B. Fix it without telling him.
C. Grant them all to public.
D. Use OEM to shuffle things around until they work, then do it again
in production.
E. None of the above.
22. A user complains that he is getting ORA-1555. There is nothing
in the
alert log about it.
A. Yeah, so?
B. Make bigger rollback segments.
C. Make more rollback segments.
D. Make smaller rollback segments.
E. Get rid of Optimal.
F. Figure out why transactions are lasting so long.
G. A, B, C, E and F.
23. A female DBA takes 9 months to do a project. How long will 2
DBA's take?
A. That's NOT FUNNY!
B. 18 months.
C. 6.5 weeks if they are both female. DNF if both male. 22 months
if one
male and one female.
D. 2 DBA's is a double oxymoron.
E. It's STILL NOT FUNNY!
24. What is a DBA?
A. Someone to blame.
B. It varies by organization.
C. An all-powerful, all-knowing, all-ominiscient 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.
25. You are about to have intimate relations in the middle of the
night. All
of a sudden, you realize the answer to the complicated PL/SQL
conundrum
you worked on most of the day. You:
A. say "Just a moment dear" and fetch your laptop.
B. mentally ask forgiveness of St. Kyte and get on with it.
C. repeat the answer over and over in your head, forget the answer,
and
give a lame excuse about the faraway look in your eyes.
D. apologize that you have a headache and lock yourself in the closet
with your pc.
E. mentally equate lovemaking sounds with the code, and then smile a
lot
as you type it in the next day.
26. You are interviewing for a DBA job. Everyone is smartly and
fashionably
dressed, but something is bothering you. Even though it is in a large
technology business park, your cell phone has no signal. Eventually,
you realize that no one is wearing socks.
A. You're in a horror movie! RUN! RUN!
B. Ask, "Why is no one wearing socks?"
C. Ask, "Why did the porridge bird lay his egg in the air?"
D. Apologize for wearing socks.
E. Act as though nothing is wrong, sneak into an unused office and
call
the government when they are not looking.
27. What will the following code do?
INSERT VALUES ('''H','E','L','L','O',',','W','O','R','L','D''') INTO
DUAL;
A. Create a string within the table DUAL that says 'HELLO,WORLD'.
B. Crash the database.
C. Crash databases all over the world as people try it.
D. Nothing, it has a syntax error.
E. Nothing, although the syntax is correct.
F. Create strange effects on much code throughout the database.
28. You walk into a grocery store, and see your banks ATM machine
being
worked on. You see there is actually an ordinary PC with an ordinary
keyboard. On the screen is a SQL prompt, and there is no one around.
A. select * from user_tables, desc an interesting one, update the
balance of the row where your name is equal, commit.
B. connect / as sysdba, spool xxx.sql, select 'alter user
'||username'
set password = blorg;' from dba_users, spool off, @xxx, continue
shopping.
C. Stare.
D. Smile and wave at the camera, then take the PC.
E. Run to the store manager and helpfully tell him there is a bank
security problem.
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.
E. Checkpoint.
30. What is wrong with this script?
setenv PIPE /tmp/bla.dmp
mknod $PIPE p
( gzip < $PIPE) | split -b 500M - exp.dmp &
exp userid=system buffer = 200000000 file=$PIPE full=y \
compress=y >>& exp.log
A. Syntax errors.
B. No such command as gzip.
C. Buffer is wrongly sized.
D. NEVER, EVER USE CSH!
E. Wrong compression.
F. Stupid filename.
31. You are being interviewed for a DBA job. The interviewer
obviously hardly
knows basic Oracle and is parrotting a DBA exam. She asks a question
that you immediately recognize as one that is generally answered
incorrectly
in nearly all books and official Oracle training materials. You have
the
definite impression that saying that will be taken as condescending,
patronizing or wrong.
A. Give the correct answer.
B. Say in so many words that most references give the wrong answer,
and
explain why it is wrong and what the correct answer is, and hope they
think
DBA's _should_ be condescending or patronizing.
C. Give the textbook answer.
D. Denigrate the interviewers knowledge of Oracle.
E. Loudly complain about your time being wasted, announce you will be
sending them a large bill, and leave.
32. You are a new Senior DBA, surrounded by eager young smiling
faces. As you
go to personalize your phone messages, you discover voice mails to the
previous person indicating he is a child molester.
A. Say nothing, when you get home start calling for those other jobs
you
rejected.
B. Call the police.
C. Ignore the messages.
D. Hack the phone system to make it seem like the phone messages are
forwarded from someone else, then forward them to HR.
E. Call the guy up and offer to play Legos and talk about buffer
waits.
33. You receive a warning from Oracle that there is a possible breach
in 9iAS
security. You:
A. Laugh.
B. Laugh really, really hard.
C. Spray Diet Coke out of your nose.
D. Immediately install IIS.
E. Stare.
34. You are using OEM to enlarge tablespaces during the middle of the
night.
Your PC gets taken over by the help desk, who proceed to install and
reboot
before you can do anything. You call and complain, and they lamely
say
they didn't think anyone would be working in the middle of the night.
A. Your tablespaces are probably corrupt, so you kill the help desk
people.
B. Your tablespaces are fine since they just rolled back to their
original
size, so you just grumble and start over.
C. Your tablespaces are in an indeterminate state, so you have to
shutdown
then startup nomount and analyse them.
D. This is a fantasy, you would never use OEM to do anything
critical.
E. You don't know what the hell might have happened, so you run
dbverify.
35. You get an ORA-600, look up the error on metalink, 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.
For answers, send an international money order in the amount of US$15,
your
tax identification, and a certifed copy of your birth certificate to:
Ministry of Oracle Information
100 Twin Dolphin Drive
Ougadougado, Burkina Faso
Niall Litchfield
news:91884734.03041...@posting.google.com...
> This is a timed, closed-book, no-notes, no-computer, no-phone, no-pda
> test. You have fifteen minutes.
--
Niall Litchfield
Oracle DBA
Audit Commission UK