1z0-149 Oracle Database 19c: Program with PL/SQL Questions and Answers

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

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

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

In line 1, add the default parameter DEFAULT 2000.

In line 6, replace P_PDT_PRICE parameter name with CUR_PRICE.

In line 2, add the default parameter DEFAULT 2000.

printer_name#

1to7number

yesterday's_date

leap$year

Number_of_days_between_March_and_April

#printer_name

v_fname

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.

The PARALLEL_ENABLE clause can be used only in the CREATE FUNCTION statement.

The NOCOPY hint asks the compiler to pass the actual parameters by reference.

A deterministic function's results always depend on the state of session variables.

The NOCOPY hint asks the compiler to pass the actual parameters by value.

A function is deterministic if it always returns the same result for a specific combination of input values.

The PARALLEL_ENABLE clause can be specified for a nested function.

A function defined with the PARALLEL_ENABLE clause may be executed in parallel in a SELECT statement or a subquery in a DML statement.