Stored Procedure, Function & Packages

A stored procedure, when specifying a string parameter should use which of these ?

• Char

• Varchar2

• Text

• Real

A Stored Procedure is a

• Sequence of SQL or PL/SQL statements to perform specific function

• Stored in compiled form in the database

• Can be called from all client environments

• All the above

Which of the following is true, Creating a procedure have compile errors?

• The line numbers reported match the line numbers you see in your text editor.

• SQL*Plus will automatically show the errors to you.

• To see the errors, enter SHOW ERRORS in SQL*Plus.

• If there are no syntax errors, you will receive the message “NO ERRORS.”

Which of the following are the advantages of PL/SQL Packages?

• Modularity

• Easier Application Design

• Information Hiding

• All the above

In the PL/SQL, the package specification contains …….. declarations.

• Public

• Private

• Friend

• Protected

Which of the following is true about PL/SQL package body?

• The package body has methods declared in package specification and private.

• It is created using the CREATE PACKAGE Statement.

• Methods and types declared in package body are not hidden from code outside

• All the above

Which of the following is not true about PL/SQL package specifications?

• The specification is the interface to the package.

• It declares the types, variables, subprograms that can be referenced from outside

• Contains all information about the content of the package and the

• None of the above.

What are internally defined exceptions?

• The Oracle ORA errors

• Exceptions which are already defined in the STANDARD package

• Exceptions defined by a user

• Any error that occurs in PL/SQL

How can a user defined exception be raised?

• Using RAISE statement only

• Using RAISE statement or RAISE_APPL_ERROR function

• Using INVOKE statement or RAISE statement

• Using RAISE statement or RAISE_APPLICATION_ERROR procedure

Which of the following function gives the error code of the recently occurred exception?

• SQLERRCODE

• SQLERROR

• ERRCODE

• SQLCODE