Free Oracle 1Z0-149 Practice Test & Real Exam Questions

Exam Code/Number: 1Z0-149
Exam Name/Title: Oracle Database 19c: Program with PL/SQL
Certification Provider: Oracle
Corresponding Certification: Oracle Database PL/SQL Developer Certified Professional

Exam Questions: 67
Updated On: Aug 15, 2026

Question #22

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

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

B. It is newer syntax that works the same way as 'IF , ELSEIF , ELSE, and END IF'.

C. Conditional compilation is disabled by default.

D. PL/SQL code can be compiled and executed based on different versions of Oracle.

E. The PL/SQL compiler can conditionally include selected parts of a program.

Discussion 0

Correct Answer: D,E Vote an answer

Question #23

Which is true about EXIT and CONTINUE statements?

A. They have the same effect on the execution of a loop.

B. They must have a WHEN condition.

C. They can be used in any type of loop.

D. They must use labels.

Discussion 0

Correct Answer: C Vote an answer

Question #24

Examine this statement which is submitted for compilation:

Which three are true? (Choose three.)

A. This will not compile successfully because the loan_amount variable is declared NOT NULL but lacks an initialization assignment.

B. Initialization of min_bal can be done while using this packaged constant in another program.

C. This program unit will compile successfully.

D. This is BODILESS PACKAGE. A PACKAGE BODY is not required to use this.

E. This will not compile successfully because the min_bal constant must be initialized.

F. Initialization of loan_amount can be done while using this packaged variable in another program.

G. This is a PACKAGE specification. A PACKAGE BODY is needed to use this.

Discussion 0

Correct Answer: A,D,E Vote an answer

Question #25

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

A. PACKAGES

B. DATABASE LINKS

C. VARIABLES

D. ANONYMOUS BLOCK

E. TRIGGER BODY

Discussion 0

Correct Answer: A,B Vote an answer

Question #26

Which three PL/SQL-only data types can be used in queries and native dynamic SQL issued from PL/SQL in the server? (Choose three.)

A. a record declared in a package specification

B. an associative array indexed by VARCHAR2

C. a predefined PL/SQL-only data type like BOOLEAN

D. a record declared in an anonymous block

E. a record declared in a procedure

F. an associative array indexed by PLS_INTEGER

Discussion 0

Correct Answer: A,B,F Vote an answer

Question #27

Examine this DECLARE section:

Which line will cause an error upon execution?

A. line 3

B. line 4

C. line 5

D. line 6

E. line 2

Discussion 0

Correct Answer: D Vote an answer

Question #28

Which three are true regarding code based access control (CBAC)? (Choose three.)

A. You can use CBAC to attach database roles to a PL/SQL function or procedure only.

B. CBAC roles can be granted to a program unit only if they are directly granted to its owner.

C. You can use CBAC to attach database roles to a PL/SQL function, procedure, or package.

D. CBAC cannot be used to secure definer's rights.

E. CBAC roles can be granted to a program unit only if they are the predefined roles automatically defined by the standard scripts as part of database creation.

F. In a multitenant environment, the DELEGATE option of CBAC cannot be used.

G. In CBAC, the ADMIN and DELEGATE options cannot both be granted to the same user.

Discussion 0

Correct Answer: B,C,G Vote an answer

Download Free Oracle 1Z0-149 Demo

Simply submit your e-mail address below to get started with our free demo of your Oracle 1Z0-149 exam.