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

You know when I was in school, Id go straight to the teachers office and get the answers... Its not that hard to coax them into giving them to you...

1. D
2. B
3. C
4. B This is very poorly written. Hard to tell exactly what he wants. Its definitely not A
5. C Another one that is poorly worded. This error(if I can remember right) means you did not declare your variable. So it could technically be in another part of the package... just not declared in the part you are using.
6. B

PS-- Has your teacher ever had a real job? These are extremely worded questions. #5 is terrible. If he just gave you the number you could go to otn.oracle.com and looked it up... No guarantee all these are correct. His wording is atrocious.

BTW, what the hell is a debug trigger? Anyone? Never heard that term? And dont say "A trigger used to debug"

"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 - 19:44:36 CST