| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_hotmail.com'
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Stig Hornuff
Sent: Wednesday, June 07, 2006 9:58 AM
To: hkchital_at_singnet.com.sg; msoyer_at_gmail.com; oracle-l_at_freelists.org
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.... ;)
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-lReceived on Wed Jun 07 2006 - 11:25:21 CDT
 |
 |