Oracle 1z1-149 Actual Free Exam Questions & Community Discussion

Exam Code/Number: 1z1-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 29, 2026

Question #8

Examine these statements and output:

The procedure is created successfully.

User ora2 has password ora2 in pdb1.
Which script will execute successfully?

Discussion 0

Correct Answer: C Vote an answer

Question #9

Which is the correct method to implement a local subprogram in an anonymous block?

Discussion 0

Correct Answer: B Vote an answer

Question #10

Which is true about EXIT and CONTINUE statements?

A. They must have a WHEN condition.

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

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

D. They must use labels.

Discussion 0

Correct Answer: B Vote an answer

Question #11

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

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

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

C. The PARALLEL_ENABLE clause can be specified for a nested function.

D. The NOCOPY hint asks the compiler to pass the actual parameters by reference.

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

F. The PARALLEL_ENABLE clause can be used only in the CREATE FUNCTION statement.

G. The NOCOPY hint asks the compiler to pass the actual parameters by value.

Discussion 0

Correct Answer: A,B,D Vote an answer

Question #12

Examine this code:

What will be the outcome?

A. It will result in an error as the range of the error code can only be from "-1000 to -2000."

B. It will result in an error as the range of the error code can only be from "-20000 to -20999."

C. It will execute successfully and will display the user-defined error message.

D. It will result in an error as the range of the error code can only be from "-2000 to -2999."

Discussion 0

Correct Answer: B Vote an answer

Question #13

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

A. Named subprograms cannot be called from other packages.

B. FUNCTION subprograms must be called and passed through one or more parameters.

C. PROCEDURE subprograms can accept parameters.

D. A FUNCTION subprogram must return one or more values.

E. Anonymous blocks must always start with the Declare keyword.

F. Anonymous blocks cannot use packaged variables.

G. Named subprograms are stored in the database server.

Discussion 0

Correct Answer: C,D,G Vote an answer

Question #14

Which two are true about exception handling? (Choose two.)

A. User-defined exceptions can be defined in the declarative part of any PL/SQL anonymous block, subprogram, or package.

B. Only predefined exceptions and user-defined exceptions can have a user-declared name associated with them.

C. Internally defined exceptions can be handled only by the OTHERS exception handler.

D. All declared exceptions are raised implicitly by the runtime system.

E. Predefined exceptions are globally declared in the standard package.

Discussion 0

Correct Answer: A,E Vote an answer

Download Free Oracle 1z1-149 Demo

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