| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: A question from OCA exam
The more I look at the documentation (9i and 10g) I believe the term is
not valid in relation to Oracle and because I have found "server-size
stored procedures" being mentioned that I would select B as the answer.
It is a bad question.
-----Original Message-----
From: Freeman, Donald [mailto:dofreeman_at_state.pa.us]
Sent: Wednesday, June 07, 2006 1:18 PM
To: Thomas.Mercadante_at_labor.state.ny.us; Powell, Mark D;
oracle-l_at_freelists.org
Subject: RE: A question from OCA exam
Last time I looked, there was quite a bit of information on the SelfTest software website about their test item construction. I once was a Navy instructor and worked on test banks: back then we spent a good bit of effort not to produce an English test and "trick" questions were not used. Self Test Software seems to have exactly the opposite attitude about it. When these type of items are included, considering how many people taking these tests are not native English speakers as well, leads me to believe they are not fair and don't actually test mastery of the material.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mercadante, Thomas F
(LABOR)
Sent: Wednesday, June 07, 2006 12:50 PM
To: mark.powell_at_eds.com; oracle-l_at_freelists.org
Subject: RE: A question from OCA exam
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.... ;)
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 -- http://www.freelists.org/webpage/oracle-lReceived on Wed Jun 07 2006 - 12:27:56 CDT
 |
 |