Re: OCP Sample Test Questions

From: Martin Haltmayer <Martin.Haltmayer_at_0800-einwahl.de>
Date: Thu, 09 Mar 2000 16:20:20 +0200
Message-ID: <38C7B324.8D330195@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?

1. 0
2. 1
3. a PL/SQL syntax error will be generated
4. an exception will be raised
5. NULL

set serveroutput on size 1000000
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 - 08:20:20 CST