Re: Please help me answer these 6 multiple choice questions...

From: Pieter J.D. Huiberts <phuiberts_at_ivwnet.com>
Date: Sat, 09 Mar 2002 09:57:19 -0500
Message-ID: <3C8A22CF.9040506@ivwnet.com>

1 D, you can only declare one var at the time.
2 C, see answer
3 C, WHEN OTHERS clause is used to trap Oracle defined errors that are 	
      not handled by your other exceptions (practically put WHEN OTHERS
      clause last in line)
4 B, package specifications. Read packages in ORACLE8 PL-SQL Programming
      chp. 8

5 A, A var must be declared before you can reference it 6 B, Row level trigger Read Trigger in ORACLE8 PL-SQL Programming chp.9

my 2 cents

JCR wrote:

> Hi all,
>
> I am studying for an EXAM and I have 6 questions here that I am unsure
> what the answers are. Can someone please help? If this is the wrong
> directory, please let me know where I should post. Thanks
>
> *************************
>
> 1) This variable line will give an error because...
> v_qty_on_hand, qty_needed number(9);
>
> a) Parm mode not declared.
> b) Value must be assigned to each variable.
> c) Constraint for each variable must was not declared.
> d) Multiple variables cannot be declared on same line.
>
> I think it's D ??
>
> *************************
>
> 2) PL/SQL executable section contains...
>
> a) Error handling stmts.
> b) parms that are passed to subpgms.
> c) sql stmts used to manipulate data in database.
>
> I think it's C ??
>
> ************************
>
> 3) Which built-in function is used to create user-defined error msgs?
>
> a) RAISE.
> b) WHEN OTHERS.
> c) raise_application_error.
>
> I think it's B ??
>
> ************************
>
> 4) When grouping procedures together in a package, a variable shared
> between packages & procedures is declared in the...
>
> a) exception stage.
> b) package specifications.
> c) procedural declare sections.
>
> I do not know !!
>
> ************************
>
> 5) On compiling a debug trigger, I receive an error msg "Identifier
> Must Be Declared". The reason is...
>
> a) Variables are not enclosed.
> b) The function is called without reference to package name.
> c) The variable whose values to be obtained is not present in
> package.
> d) Data type mismatch between variables and function used.
>
> I do not know !!
>
> ************************
>
> 6) Which trigger fires once for each row affected by the triggering
> event?
>
> a) after trigger
> b) row level trigger
> c) statement level trigger
>
> I am unsure !!
>
> ************************
>
>
> Thanks,
> Joe
>
Received on Sat Mar 09 2002 - 08:57:19 CST