1Z0-149 Free Exam Questions & Answers (Updated 2026)

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

Choose the Choices:

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

Choose the Choices:

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

Choose the Choices:

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

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

Choose the Choices:

A deterministic function's results always depend on the state of session variables.

A function is deterministic if it always returns the same result for a specific combination of input values.

A function defined with the PARALLEL_ENABLE clause may be executed in parallel in a SELECT statement or a subquery in a DML statement.

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

Choose the Choices:

INDEX - BY table types can be created both with the CREATE TYPE statement and in PL/SQL blocks.

Next Question

Oracle 1Z0-149 Free Exam Questions (Updated 2026)