Checking It

1:Triggers, Functions, and Procedures can also be coded in JAVA.

True/False

2:Cursors are
  1. Temporary storage area for PL/SQL

  2. Work area for SQL returning more than 1 row

  3. Work/storage space for PL/SQL

  4. Executable code modules

3:Procedures differ from Functions in that:
  1. Procedures takes no input variables but output variables

  2. Procedures take input variables but Functions cannot

  3. Functions have an output variable where Procedures do not

  4. Functions can have input variables but Procedures cannot

4:The PL/SQL variable name must be unique to the PL/SQL block.

True/False

5:What is the difference between implicit cursors and explicit cursors?
  1. Explicit processes ...

Get Oracle9i™ Development by Example now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.