Free 1z1-149 Questions for Oracle Database 19c: Program with PL/SQL 1z1-149 Exam as PDF & Practice Test Engine

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 26, 2026

Question #1

In which type of trigger can :OLD and :NEW identifiers be used?

A. BEFORE STATEMENT

B. AFTER STATEMENT

C. ROW

D. AFTER SUSPEND

Discussion 0

Correct Answer: C Vote an answer

Question #2

Which is true about the PLSCOPE_SETTINGS parameter?

A. It can be used to control a user's privileges on PL/SQL objects at run time.

B. It is deprecated in Oracle 12c.

C. It can be used to obtain information about all identifiers when compiling a procedure.

D. It can be used to control execution of specific portions of the PL/SQL code conditionally.

Discussion 0

Correct Answer: C Vote an answer

Question #3

Which code will successfully create a BODILESS PACKAGE to standardize CONSTANTS and EXCEPTIONS declarations?

Discussion 0

Correct Answer: C Vote an answer

Question #4

Which two statements are true about the RETURNING clause when used with DML? (Choose two.)

A. The RETURNING clause can be used for remote or parallel deletes.

B. The RETURNING INTO clause returns column values for rows affected by DML statements.

C. When using the RETURNING INTO clause, the data returned can be only single column or expression.

D. The RETURNING INTO clause can be used with DML that affects multiple rows, if the BULK COLLECT clause is used.

E. The RETURNING INTO clause and bulk binds may not be used together.

Discussion 0

Correct Answer: A,D Vote an answer

Question #5

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.

Discussion 0

Correct Answer: B Vote an answer

Question #6

Which two are true about named notations in a PL/SQL subprogram? (Choose two.)

A. The actual parameters must be specified in the same order as the formal parameters are declared.

B. Specifying actual parameters in the wrong order results in the subprogram terminating with an exception.

C. Any optional parameters can be omitted in the invocation call.

D. Only trailing optional parameters can be omitted in the invocation call.

E. The subprogram invocations must be changed when the formal parameter list acquires new required parameters.

Discussion 0

Correct Answer: A,C Vote an answer

Question #7

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

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

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

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

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

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

Discussion 0

Correct Answer: A,D Vote an answer

Free 1z1-149 Questions for Oracle Database 19c: Program with PL/SQL 1z1-149 Exam as PDF & Practice Test Engine

Download Free Oracle 1z1-149 Demo