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 #8

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

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

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

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

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

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

Discussion 0

Correct Answer: C,D Vote an answer

Question #9

Examine the SH.PRODUCTS table:

A row exists in SH.PRODUCTS with PDT_ID = 1.
Now, examine this code and output executed by SH:

Now, examine this block of code:

Which error message(s) does it display on execution by user SH?

A. Error in inner block Error in outer block

B. Error in inner block Error in calling block

C. Error in inner block

D. Error in inner block Error in outer block Error in calling block

Discussion 0

Correct Answer: C Vote an answer

Question #10

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

Discussion 0

Correct Answer: D Vote an answer

Question #11

Which two are true about packages? (Choose two.)

A. A package definition must have a specification and body.

B. Variables and cursors defined in a package specification are visible to all subprograms in the same schema that has the package.

C. Standalone subprograms that reference a package can be compiled only after both the package specification and body are compiled.

D. Modifications to a packaged procedure's body automatically cause recompilation of subprograms that invoke the procedure.

E. Package specifications can be compiled without their bodies.

Discussion 0

Correct Answer: B,E Vote an answer

Question #12

Examine these statements:

Which two are true? (Choose two.)

A. The transaction for the bank_activity_proc is independent of the bank_transaction_proc.

B. Only one table will have a row inserted and committed.

C. Both tables will have a row inserted and committed.

D. The bank_activity_proc will not compile because of the commit.

E. Neither table will have a row inserted and committed.

Discussion 0

Correct Answer: A,B Vote an answer

Question #13

Which two are valid MODIFIER values for the PLSQL_WARNINGS parameter? (Choose two.)

A. SEVERE

B. ENABLE

C. DISABLE

D. ERROR

E. ALL

Discussion 0

Correct Answer: A,E Vote an answer

Question #14

Examine this anonymous block of code:

Which two statements are true about the results of executing it? (Choose two.)

A. It will always automatically initialize v_raise.

B. It will set all salaries to 0 if it executes successfully.

C. It will always return a compile time error because it lacks an EXCEPTION section.

D. It will set all salaries to NULL if it executes successfully.

E. It might return a run time error depending on who invokes it.

F. It will always return a run time error because v_raise is not initialized.

Discussion 0

Correct Answer: A,D 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.