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

From: JCR <jrappa_at_hammer.net>
Date: 7 Mar 2002 17:47:46 -0800
Message-ID: <12a73e0d.0203071747.14f14fb0@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);
2. Parm mode not declared.
3. Value must be assigned to each variable.
4. Constraint for each variable must was not declared.
5. Multiple variables cannot be declared on same line.

   I think it's D ??

---

2) PL/SQL executable section contains...

1. Error handling stmts.
2. parms that are passed to subpgms.
3. 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?

1. RAISE.
2. WHEN OTHERS.
3. 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...

1. exception stage.
2. package specifications.
3. 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...

1. Variables are not enclosed.
2. The function is called without reference to package name.
3. The variable whose values to be obtained is not present in package.
4. 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?

1. after trigger
2. row level trigger
3. statement level trigger

   I am unsure !!

---

Thanks,
Joe Received on Thu Mar 07 2002 - 19:47:46 CST