Free 1z0-149 Exam Questions and Answers | by Exam-Dumps.net (Page: 1)

Which two PL/SQL elements can be deprecated using the DEPRECATE pragma? (Choose two.)

Answer(s): A,E

Which three are true about functions and procedures? (Choose three.)

Answer(s): B,E,F

Which two are true about Conditional Compilation in PL/SQL using $IF, $ELSE, $END, and $ERROR? (Choose two.)

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.

Answer(s): B,E

Which three are true about the NOCOPY hint, the PARALLEL ENABLE hint, and the DETERMINISTIC clause? (Choose three.)

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.

Answer(s): B,E,G

Which two are true about INDEX-BY tables? (Choose two.)

The index can be integer or string.
The index can be integer only.
INDEX-BY table types can be created in PL/SQL blocks only.
INDEX-BY table types can be created both with the CREATE TYPE statement and in PL/SQL blocks.
INDEX-BY table types can be created with the CREATE TYPE statement.

Answer(s): A,C

Oracle 1z0-149 Exam (page: 1)
Oracle Database Program with PL/SQL
Updated on: 12-Aug-2025