1z0-149 Exam Dumps : Oracle Database 19c: Program with PL/SQL

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.

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.

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.