Do we get to share the grade? And get credit with the teacher?
"JCR" <jrappa_at_hammer.net> wrote in message
news:12a73e0d.0203071747.14f14fb0_at_posting.google.com...
> 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 Thu Mar 07 2002 - 20:20:00 CST
