Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle l »

RE: A question from OCA exam

Mercadante, Thomas F

2006-06-07

Replies:

Wouldn't it be interesting if the exam tested something important rather
than ambiguous terminology?

I hate exams that throw in questions that mean nothing just to try and
catch someone on a vague recollection of something that they might have
heard in a class.

-----Original Message-----
From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)]
Sent: Wednesday, June 07, 2006 12:25 PM
To: oracle-l@(protected)
Subject: FW: A question from OCA exam

I thought I had sent this to the list.

-----Original Message-----
From: Powell, Mark D
Sent: Wednesday, June 07, 2006 11:54 AM
To: 'hornuff@(protected)'
Subject: RE: A question from OCA exam


I believe that "server side procedures" is a term related to the use of
rman scripts therefore A would be the answer. Answer B would be correct
for stored procedures.

IMHO -- Mark D Powell --

-----Original Message-----
From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)
Sent: Wednesday, June 07, 2006 9:58 AM
To: hkchital@(protected)
Subject: Re: A question from OCA exam

Hmmm... As the term is "Server side procedures" and not "Database Stored
Procedures", I would rule out B,C & D - but I might have a twisted
perception of these questions.... ;)

- yet another question where it's a matter of how to use words in
Certification.....

---------------------------
What is a "server side procedure" ?

DBAs know "stored procedures" -- the source code is visible in
USER/ALL/DBA_SOURCE to those who have EXECUTE permision on the
procedure.


At 04:35 PM Wednesday, Muhammed Soyer wrote:
>Hi,
>While I was studing to the 1z0-147 exam I see a question which I coudnt

>be sure the answer .
>Here is the question ..
>
>its written that the choice A is correct but I dont agree with this ..B

>seems to be more correct to me ..
>
>
>Which statement is true?
>A.Server side procedures are stored in script files on the server.
>B.Server side procedures are visible in the ALL_SOURCE dictionary view.
>C.Server side procedures are visible in the SERVER_SOURCE dictionary
view.
>D.Server side procedures are visible in the SERVER_PROCEDURE data
>  dictionary view.
>
>Regards


Hemant K Chitale
http://web.singnet.com.sg/~hkchital


--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l


©2008 dba.5341.com - Jax Systems, LLC, U.S.A.