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: A question from OCA exam

RE: A question from OCA exam

From: Mercadante, Thomas F \(LABOR\) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Wed, 7 Jun 2006 12:49:44 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FF6812C9@EXCNYSM0A1AJ.nysemail.nyenet>


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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]
Sent: Wednesday, June 07, 2006 12:25 PM
To: oracle-l_at_freelists.org
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_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.... ;)


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
Received on Wed Jun 07 2006 - 11:49:44 CDT

Original text of this message

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