RE: DBA assessment - slightly OT

From: Martin Kendall <Martin.Kendall_at_Rubus.com>
Date: Wed, 26 Sep 2001 10:45:01 -0700
Message-ID: <F001.00399927.20010926102532@fatcity.com>

Hi Christopher,

So, are you going to tell the list what the answers are so that those that don't know can benefit.

Martin

-----Original Message-----
Sent: 26 September 2001 16:46
To: Multiple recipients of list ORACLE-L

What is the difference between a lock and a latch?
Explain what spinning is and why is it necessary?
What is the PL/SQL catch all exception called?
Where would you "read" about a deadlock that occurred?
How would you verify your data files you just backed up are not corrupt?
Explain what two significant things that occur when you do a BEGIN BACKUP on a tablespace.
Explain the use of DECODE function.
What is a correlated sub query?
Explain the "snapshot too old" error, and when does it commonly occur.
What three powerful Oracle tuning tools require timed_statistics?

These are off the top of my head, I had a nice drawn up list I spent more time on, but it is at home I think.

HTH, "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax: (707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863

-----Original Message-----
Sent: Wednesday, September 26, 2001 10:30 AM To: Multiple recipients of list ORACLE-L

If you were to choose 10 questions to evaluate the competency of a DBA what would they be given that the result would be their competence would be rated as of the following:

TERRIBLE (I would not let them within 100 miles of a database)
FAIR (I'd show them some basic admin, but do it myself, they've a lot to learn yet)
GOOD (I'd let them do some basic admin stuff by themselves but monitor their performance regularly)
VERY GOOD (I'd let them handle practically all admin type work and mentor them as required)
EXCELLENT (Hell, they could teach me a trick or too!)

Sean :)

Data Base Administrator
Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K
[0%] OCP Oracle8i DBA ---> End 2002 deadline =:-O [0%] OCP Oracle9i DBA

-------------------------------- ------------

Organon (Ireland) Ltd.
E-mail: sean.oneill_at_organon.ie [subscribed: Digest Mode]

Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA

"Nobody loves me but my mother... and she could be jivin' too." - BB King

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: O'Neill, Sean
INET: Sean.ONeill_at_organon.ie

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Christopher Spence
INET: cspence_at_FuelSpot.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------