Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: DBA assessment - slightly OT

RE: DBA assessment - slightly OT

From: Christopher Spence <cspence_at_FuelSpot.com>
Date: Wed, 26 Sep 2001 07:59:31 -0700
Message-ID: <F001.0039924A.20010926074611@fatcity.com>

  1. What is the difference between a lock and a latch?
  2. Explain what spinning is and why is it necessary?
  3. What is the PL/SQL catch all exception called?
  4. Where would you "read" about a deadlock that occurred?
  5. How would you verify your data files you just backed up are not corrupt?
  6. Explain what two significant things that occur when you do a BEGIN BACKUP on a tablespace.
  7. Explain the use of DECODE function.
  8. What is a correlated sub query?
  9. Explain the "snapshot too old" error, and when does it commonly occur.
  10. 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:  

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
--------------------------------------------------------------------
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).
Received on Wed Sep 26 2001 - 09:59:31 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US