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

QUESTION: 1

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

PACKAGES
VARIABLES
ANONYMOUS BLOCK
TRIGGER BODY
DATABASE LINKS

Answer(s): A,E

Reveal Solution Next Question

QUESTION: 2

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

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.

Answer(s): B,E,F

Reveal Solution Next Question

QUESTION: 3

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

Reveal Solution Next Question

QUESTION: 4

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

Reveal Solution Next Question

QUESTION: 5

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

Reveal Solution Next Question

QUESTION: 6

Which three are true about anonymous blocks and subprograms? (Choose three.)

Named subprograms cannot be called from other packages.
PROCEDURE subprograms can accept parameters.
A FUNCTION subprogram must return one or more values.
Anonymous blocks cannot use packaged variables.
Named subprograms are stored in the database server.
Anonymous blocks must always start with the Declare keyword.
FUNCTION subprograms must be called and passed through one or more parameters.

Answer(s): B,C,E

Reveal Solution Next Question

QUESTION: 7

Which two statements are true about using the OR REPLACE clause when creating named subprograms? (Choose two.)

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.

Answer(s): D,E

Reveal Solution Next Question

Examine the SH.PRODUCTS table:

A row exists in SH.PRODUCTS with PDT_ID = 1.
Now, examine this code and output executed by SH:

Now, examine this block of code:

Which error message(s) does it display on execution by user SH?

Error in inner block
Error in inner block Error in outer block
Error in inner block Error in calling block
Error in inner block Error in outer block Error in calling block

Answer(s): A

Reveal Solution Next Question

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

Access free 1z0-149 actual exam questions, answers, explanations and user discussions.

QUESTION: 1

QUESTION: 2

QUESTION: 3

QUESTION: 4

QUESTION: 5

QUESTION: 6

QUESTION: 7

QUESTION: 8

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

Access free 1z0-149 actual exam questions, answers, explanations and user discussions.

QUESTION: 1

QUESTION: 2

QUESTION: 3

QUESTION: 4

QUESTION: 5

QUESTION: 6

QUESTION: 7

QUESTION: 8

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