This is a PACKAGE specification. A PACKAGE BODY is needed to use this.

This will not compile successfully because the loan_amount variable is declared NOT NULL but lacks an initialization assignment.

This program unit will compile successfully.

Initialization of min_bal can be done while using this packaged constant in another program.

Initialization of loan_amount can be done while using this packaged variable in another program.

This will not compile successfully because the min_bal constant must be initialized.

This is BODILESS PACKAGE. A PACKAGE BODY is not required to use this.

It will result in a compilation error for protected_proc because calling_proc does not exist.

It will result in a compilation error for protected_proc because calling_proc must be prefixed with the schema name.

It will result in a successful compilation because objects referenced in an ACCESSIBLE BY clause are not checked at compile time.

With adequate privileges, PROTECTED_PROC procedure can be called by other programs apart from CALLING_PROC.

line 1

line 6

line 8

line 2

line 3

line 7

It can be used in the declaration of object types.

It must be specified in the heading of a package specification.

The check is enforced by this clause for direct access and access through dynamic SQL.

It can be used for individual procedures and functions declared in a package specification.

It must be specified in the heading of a package body.

They can be used in ORDER BY and GROUP BY clauses.

They can be executed as standalone commands.

They must be defined with at least one parameter.

They need not return any values.

They can appear in the select list of a SELECT statement.

Functions can call only other functions.

They can be used in CONNECT BY and START WITH clauses.

Changing the parameter setting automatically changes the setting for existing PL/SQL library units.

The default value is NATIVE.

If set to NATIVE, programs are stored in platform dependent machine code.

It can use the REUSE SETTINGS clause to recompile a program unit without changing to the current session settings.

If set to NATIVE, programs are stored in a PL/SQL bytecode format.

It will execute successfully provided the salary of EMP_ID 200 does not exceed the value 99999.

It will return an error at line 2.

It will return an error at line 3.

It will return an error at line 8.

It will execute successfully by rounding up the salary of EMP_ID 200 to the appropriate value.

printer_name#

1to7number

yesterday's_date

leap$year

Number_of_days_between_March_and_April

#printer_name

v_fname

It results in an error because Authid Current_User is missing from MYPROC.

It results in an error because Authid Definer is missing from MYPROC.

It results in an error because USERB doesn't have select privilege on USERA.EMP.

It executes successfully.