Free and Premium Oracle 1z0-149 Dumps Questions Answers

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.

5000

15000

2500

10000

printer_name#

1to7number

yesterday's_date

leap$year

Number_of_days_between_March_and_April

#printer_name

v_fname

PL/SQL assigns values to actual parameters in subprograms with unhandled exceptions.

IN parameters passed to subprograms act like constants, to which values cannot be assigned by the subprogram.

IN OUT parameters pass initial values to subprograms and return values updated by subprograms to the caller.

The actual parameter must be a variable when calling a subprogram with an OUT parameter.

IN parameters passed to subprograms act like variables, to which values can be assigned by the subprogram.

OUT parameters returning values to calling subprograms act like constants in the called subprogram.

Actual parameters corresponding to IN OUT formal parameters can be constants or expressions.

They can be returned from a function.

Field types must match column types.

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

Field names must match selected column names.

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.

The ACCESSIBLE BY clause can be used only for procedures.

In a function, every execution path must lead to a RETURN statement.

Both can have only constants as actual parameters for IN mode parameters.

Both can be invoked from within SQL statements.

In a procedure the RETURN statement cannot specify an expression.

In a function every RETURN statement must specify an expression.

A variable of RECORD type can contain fields of another RECORD type or any collection type.

Only associative arrays and nested tables can have elements of RECORD type.

All collections and RECORD types can be defined in PL/SQL blocks, packages, or at the schema level.

Collections and RECORD types are always dense.

All collections and RECORD types can be stored in table columns.

VARRAYS, nested tables and each field in %ROWTYPE type variables have a default value of null.