Free Oracle 1Z0-149 Exam Dumps Questions & Answers


Exam Code/Number:	1Z0-149Join the discussion
Exam Name:	Oracle Database 19c: Program with PL/SQL
Certification:	Oracle
Free Question Number:	67
Publish Date:	Aug 15, 2026
# of views:	5998
Rating 100%

Page: 1 / 14
Total 67 questions

Question 1

Which two are true about lexical units? (Choose two.)

A.A character literal with zero characters has the BOOLEAN value NULL.
B.Spaces can be embedded in delimiters.
C.Character literals are case-sensitive.
D.Identifiers include labels.
E.All user-defined identifiers must start with an alphabet.

Question 2

Examine this table in the SH schema:

User SH executes this code:

The program must terminate with a user-defined message and no rows displayed if more than one product's price is 1000.
With which option must "---placeholder" be replaced?

Question 3

Examine these statements issued by user SH which execute successfully:

DBMS_OUTPUT.PUT_LINE(p_price(i)); END LOOP; END; END products_pkg; /
Now, examine this anonymous block executed by SH:

Which is true about the anonymous block?

A.It will execute successfully only if PriceList is defined as an associative array in the package and anonymous block.
B.It will fail at lines 6 and 7.
C.It will fail only at line 7.
D.It will execute successfully only if PriceList is removed from the DECLARE section and defined as a standalone collection type.

Question 4

Which two are true about the PLSQL_CODE_TYPE parameter? (Choose two.)

A.The default value is NATIVE.
B.If set to NATIVE, programs are stored in a PL/SQL bytecode format.
C.It can use the REUSE SETTINGS clause to recompile a program unit without changing to the current session settings.
D.Changing the parameter setting automatically changes the setting for existing PL/SQL library units.
E.If set to NATIVE, programs are stored in platform dependent machine code.

Question 5

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

A.It is newer syntax that works the same way as 'IF , ELSEIF , ELSE, and END IF'.
B.PL/SQL code can be compiled and executed based on different versions of Oracle.
C.The PL/SQL compiler can conditionally include selected parts of a program.
D.Conditional compilation is disabled by default.
E.PL/SQL code can be compiled and executed based on different versions of the operating system.