Oracle Database 19c: Program with PL/SQL - 1Z0-149 Exam Questions [2026]

QUESTION NO: 1
Examine this row of data from the EMPLOYEES table:

Now, examine this block of code which executes successfully:

What is the value of v_commission?

A. 10000 B. 15000 C. 5000 D. 2500

Correct Answer: D

QUESTION NO: 2
Which is true about counter variables in a FOR loop?

A. It is accessible outside the body of the loop. B. It cannot be NULL. C. It must explicitly be declared. D. It can be modified in the body of the loop.

Correct Answer: B

QUESTION NO: 3
Which three are true about functions and procedures? (Choose three.)

A. In a procedure the RETURN statement cannot specify an expression. B. In a function every RETURN statement must specify an expression. C. In a function, every execution path must lead to a RETURN statement. D. The ACCESSIBLE BY clause can be used only for procedures. E. Both can be invoked from within SQL statements. F. Both can have only constants as actual parameters for IN mode parameters.

Correct Answer: A,B,C

QUESTION NO: 4
SERVEROUTPUT is enabled.
Which is the correct method to use a PACKAGED CONSTANT in SELECT statements?

A.

B.

C.

D.

Correct Answer: D

QUESTION NO: 5
SERVEROUTPUT is enabled.
Which code block will display the values from 1 to 10 in descending order?

A.

B.

C.

D.

Correct Answer: B

QUESTION NO: 6
Examine these statements:

Which is true?

A. It will result in a compilation error for protected_proc because calling_proc must be prefixed with the schema name. B. It will result in a successful compilation because objects referenced in an ACCESSIBLE BY clause are not checked at compile time. C. With adequate privileges, PROTECTED_PROC procedure can be called by other programs apart from CALLING_PROC. D. It will result in a compilation error for protected_proc because calling_proc does not exist.

Correct Answer: D

QUESTION NO: 7
Examine these statements:

Which two are true? (Choose two.)

A. The bank_activity_proc will not compile because of the commit. B. Only one table will have a row inserted and committed. C. Neither table will have a row inserted and committed. D. Both tables will have a row inserted and committed. E. The transaction for the bank_activity_proc is independent of the bank_transaction_proc.

Correct Answer: B,E