Re: OCP Sample Test Questions
Date: Thu, 09 Mar 2000 16:20:20 +0200
Message-ID: <38C7B324.8D330195_at_0800-einwahl.de>
Interesting, but there you can see some examples that are plainly wrong:
A variable is declared in a PL/SQL block as NUMBER without being initialized. What value will be used when it is first accessed in the EXECUTABLE section?
- 0
- 1
- a PL/SQL syntax error will be generated
- an exception will be raised
- NULL
declare n number; begin dbms_output.put_line ('n = ' || nvl (n, 5)); end; /
proves that the suggested answer a) is wrong. e) is correct.
Martin
John Claxton wrote:
>
> We're just getting started with sample questions for the Oracle Certified
> Professional (OCP) tests.
> You can test your skill and knowledge at
>
> http://www.networkessentials.com/certified/ocp
>
> where the questions are presented in random order with pop-up answers and
> cumulative scoring.
> You can enter comments/questions about each individual question.
> There's even a form for you to add questions of your own.
>
> jc
Received on Thu Mar 09 2000 - 15:20:20 CET