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
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:
- 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: [EMAIL PROTECTED] [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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Martin Kendall
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).