A.  

Named subprograms cannot be called from other packages.

B.  

PROCEDURE subprograms can accept parameters.

C.  

A FUNCTION subprogram must return one or more values.

D.  

Anonymous blocks cannot use packaged variables.

E.  

Named subprograms are stored in the database server.

F.  

Anonymous blocks must always start with the Declare keyword.

G.  

FUNCTION subprograms must be called and passed through one or more parameters.

A.  

In line 1, change IN OUT mode to IN mode.

B.  

In line 2, change IN OUT mode to IN mode.

C.  

In line 3, replace CUR_PRICE with P_PDT_PRICE in the query condition.

D.  

In line 1, add the default parameter DEFAULT 2000.

E.  

In line 6, replace P_PDT_PRICE parameter name with CUR_PRIC

E.  

F.  

In line 2, add the default parameter DEFAULT 2000.

A.  

The actual parameters must be specified in the same order as the formal parameters are declared.

B.  

Specifying actual parameters in the wrong order results in the subprogram terminating with an exception.

C.  

Only trailing optional parameters can be omitted in the invocation call.

D.  

The subprogram invocations must be changed when the formal parameter list acquires new required parameters.

E.  

Any optional parameters can be omitted in the invocation call.

A.  

printer_name#

B.  

1to7number

C.  

yesterday's_date

D.  

leap$year

E.  

Number_of_days_between_March_and_April

F.  

#printer_name

G.  

v_fname

A.  

They can be returned from a function.

B.  

Field types must match column types.

C.  

The number of fields must match the number of columns in a table.

D.  

Field names must match selected column names.

A.  

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

B.  

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

C.  

This program unit will compile successfully.

D.  

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

E.  

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

F.  

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

G.  

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

A.  

It is deprecated in Oracle 12c.

B.  

It can be used to obtain information about all identifiers when compiling a procedure.

C.  

It can be used to control execution of specific portions of the PL/SQL code conditionally.

D.  

It can be used to control a user's privileges on PL/SQL objects at run time.

A.  

B.  

C.  

D.  

A.  

It will set all salaries to 0 if it executes successfully.

B.  

It will always return a compile time error because it lacks an EXCEPTION section.

C.  

It might return a run time error depending on who invokes it.

D.  

It will always automatically initialize v_raise.

E.  

It will set all salaries to NULL if it executes successfully.

F.  

It will always return a run time error because v_raise is not initialized.