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

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.

ROW

AFTER SUSPEND

AFTER STATEMENT

BEFORE STATEMENT

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.

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.

PL/SQL code can be compiled and executed based on different versions of the operating system.

PL/SQL code can be compiled and executed based on different versions of Oracle.

It is newer syntax that works the same way as 'IF , ELSEIF , ELSE, and END IF'.

Conditional compilation is disabled by default.

The PL/SQL compiler can conditionally include selected parts of a program.

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.