Paula - You're losing me on the connection between SQL and GUI. I can see a
connection between command-line DBA actions and GUI DBA tools. And some GUI
report writing tools create SQL for you, but usually we DBAs are called when
it creates bad SQL code and we must straighten it out.
So have you passed all 5 OCP modules?
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-----Original Message-----
Sent: Tuesday, November 05, 2002 12:29 PM
To: Multiple recipients of list ORACLE-L
I took the SQL exam first and had no problems although I have heard others
have. I think it has to do with how I learned - I forced myself to use SQL
before getting hooked into a GUI tool of any kind. In the long-run that is
a good approach as you will always have that but might not always have the
GUI.
-----Original Message-----
<mailto:DWILLIAMS@;LIFETOUCH.COM> ]
Sent: Tuesday, November 05, 2002 12:04 PM
To: Multiple recipients of list ORACLE-L
Eva - Everything I've heard says that all the exam questions come out of the
Oracle University class Student Guides. To put it bluntly, your goal is to
pass the exam. You could study the Oracle manuals, but there is a lot of
material to cover and what strikes you as important might not be covered on
the exam, and vice-versa. Essentially you are getting two levels of
filtering. Somebody read the manuals and used that to prepare student
guides, then a group of Oracle instructors read the student guide and
prepared questions. I think that most of the exam guides were prepared from
the Oracle Student Guides and the author has at least taken the exam, so
they have a general idea of how the test is approached. Everyone has their
favorite exam preparation book and I consider this a worthwhile investment,
I bought Couchman -
http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL0
<http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL
0>
H
<
http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL
<http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL
>
0H&sourceid=00400731866779927243&bfdate=11%2D05%2D2002+10%3A16%3A17&isbn=007
2133414>
&sourceid=00400731866779927243&bfdate=11%2D05%2D2002+10%3A16%3A17&isbn=00721
33414
Two issues: Which exam track are you planning to take? 9i? 8i?
The advice I received is "don't take the SQL exam as your first exam".
Take the DBA exam first. The SQL exam is reported to be quite hard because
it covers all the odd SQL functions and can really catch you unawares. As a
practicing DBA you should find the DBA exam pretty easy. I didn't personally
take that path for my own reasons, but I still consider it good advice.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-----Original Message-----
Sent: Tuesday, November 05, 2002 6:09 AM
To: Multiple recipients of list ORACLE-L
Hello Everyone,
1. I have now made the humungous decision to start studying and to write the
OCP exams.
2. Do I study out of the Oracle Manuals?
3. I do have the Sybex Study Guides, would studying these be all that is
needed?
4. Or do the questions come out of the Course material ( Which I have not
attended ).
5. I do have some of the Oreilly "Insect" Books - would these be any help?
Any views, opinions etc appreciated.
Regards
Denham Eva
Oracle DBA
"UNIX is basically a simple operating system, but you have to be a genius to
understand the simplicity."
Dennis Ritchie.
_____
DISCLAIMER
This message is for the named person's use only. It may contain
confidential, proprietary or legally privileged information. No
confidentiality or privilege is waived or lost by any mistransmission. If
you receive this message in error, please immediately delete it and all
copies of it from your system, destroy any hard copies of it and notify the
sender. You must not, directly or indirectly, use, disclose, distribute,
print, or copy any part of this message if you are not the intended
recipient. TFMC, its holding company, and any of its subsidiaries each
reserve the right to monitor and manage all e-mail communications through
its networks.
Any views expressed in this message are those of the individual sender,
except where the message states otherwise and the sender is authorized to
state them to be views of any such entity.
_____
_____
This e-mail message has been scanned for Viruses and Content and cleared by
MailMarshal - For more information please visit
< http://www.marshalsoftware.com <http://www.marshalsoftware.com> >
www.marshalsoftware.com
_____
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
<http://www.orafaq.com>
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
<http://www.fatcity.com>
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
