Oracle Oracle Database 19c: Program with PL/SQL 1z0-149 Exam Dumps: Updated Questions & Answers (October 2025)

Results of a subprogram can be cached in the SGA such that sessions connected to the same instance can reuse these results when available.

Users granted execute privilege on a procedure compiled with definer's rights require grants to access objects belonging to the definer that are referenced in the procedure.

Subprograms are cached by default and shared among users, thereby reducing memory requirements.

Reuse of parsed PL/SQL code from the shared SQL area reduces parsing overhead.

A subprogram's session state is retained even if any of the session’s instantiated subprograms are invalidated and revalidated.

Host variables can be referenced inside any PL/SQL subprogram.

A PL/SQL procedure can invoke an external code block written in a different programming language.

Variables and cursors defined in a package specification are visible to all subprograms in the same schema that has the package.

Modifications to a packaged procedure's body automatically cause recompilation of subprograms that invoke the procedure.

Package specifications can be compiled without their bodies.

Standalone subprograms that reference a package can be compiled only after both the package specification and body are compiled.

A package definition must have a specification and body.

Function based indexes remain usable when replacing the function on which the index depends.

Object privileges to execute a replaced function must be regranted to those users who had the privilege.

This clause can be used only for procedures and functions.

A function definition can be modified without dropping and re-creating it.

Object privileges to execute a replaced function are retained by those users who had the privileges.

DISABLE

ENABLE

ERROR

ALL

SEVERE

Each procedure can be a nested subprogram.

Each procedure's formal parameters can differ in data type or name.

Each procedure must use named notation to specify the corresponding actual parameters.

Each procedure's formal parameters must differ in name.

Each procedure can be a packaged subprogram.

Each procedure must use positional notation to specify the corresponding actual parameters.

Each procedure can be a standalone subprogram.

RAW data types are always implicitly converted to a CLOB when used in a query.

Collections can be implicitly converted to records.

ROWIDS are always implicitly converted to a number when used in a query.

Comparison between character value and a number value always implicitly converts the character value to the number data type.

Implicit data type conversion can negatively impact performance.

The lock acquired when executing the OPEN c1 command will be released only after a COMMIT or ROLLBACK statement is issued.

Only the PRICE column can be updated in the PRODUCTS table.

The FOR UPDATE OF clause can be used only if the WHERE CURRENT OF clause is used in the executable part of the block.

The WHERE CURRENT OF clause can be used only if the FOR UPDATE clause is used in the cursor definition.

An OPEN c1 command will acquire a lock only on the PRICE column in the PRODUCTS table.

DEP_VU must be manually recompiled to successfully run this code.

It will run successfully producing a result of 4.

It will result in an error because table depts has been altered.

It will run successfully producing a result of 5.

It will execute successfully only if PriceList is removed from the DECLARE section and defined as a standalone collection type.

It will execute successfully only if PriceList is defined as an associative array in the package and anonymous block.

It will fail at lines 6 and 7.

It will fail only at line 7.