1Z0-149

Oracle Database PL/SQL Developer Pro 1Z0-149 practice exams

290 questions in 5 timed practice tests. Each test has about 61 questions and a 90-minute limit. The pass mark is 65%. Results are split across the 12 exam domains.

Exam at a glance

1Z0-149 practice exam settings
Practice tests 5
Questions in total 290
Questions per test About 61
Time limit per test 90 minutes
Pass mark 65%
Question types Single answer and multiple answer (29 multiple-answer questions)
Level Professional
Category Data & Analytics

These are the settings of our practice tests. Check the official Oracle exam page for the current exam format before you book.

Domains and weights

1Z0-149 exam domains, weights and question counts
Domain Weight Weight bar Questions in our bank
Declaring Variables and Writing Executable Statements 10% 29
Writing SQL in PL/SQL and Control Structures 10% 29
Working with Composite Data Types 8% 23
Using Explicit Cursors 9% 26
Handling Exceptions 10% 29
Creating Procedures and Functions 11% 32
Creating and Working with Packages 11% 32
Using Dynamic SQL 7% 20
Design Considerations for PL/SQL Code 6% 17
Creating DML, Compound, DDL and Event Triggers 10% 29
Using the PL/SQL Compiler and Managing PL/SQL Code 5% 15
Managing Dependencies 3% 9

Sample questions

Question 1 of 3

Which statement correctly assigns the next value of the sequence ORD_SEQ to a variable in PL/SQL in Oracle Database 19c?

  1. A v_id := SEQUENCE.NEXTVAL('ord_seq');
  2. B v_id := NEXTVAL(ord_seq);
  3. C v_id := ord_seq.CURRVAL + 1;
  4. D v_id := ord_seq.NEXTVAL; (correct answer)
Why: Since Oracle Database 11g, the NEXTVAL and CURRVAL pseudocolumns can be used directly in PL/SQL expressions, so the assignment is valid without SELECT ... FROM dual. NEXTVAL is not a function taking the sequence as an argument, CURRVAL + 1 does not advance the sequence and fails if NEXTVAL has not yet been called in the session, and there is no SEQUENCE package with a NEXTVAL function.

Question 2 of 3

A block inserts an order header and then 20 lines. If any line insert fails, the header must remain but all lines must be undone, and the block should continue. Which approach meets the requirement?

  1. A Issue COMMIT after each line insert so that failed lines do not affect earlier ones
  2. B Wrap the header insert in an autonomous transaction and roll back the main transaction on error
  3. C Rely on statement-level rollback, which undoes all line inserts automatically when one fails
  4. D SAVEPOINT before the lines, and ROLLBACK TO it in a handler around the line inserts (correct answer)
Why: A savepoint marks the point after the header; rolling back to it in an exception handler removes only the line inserts while the header stays pending and processing continues. Committing each line keeps partial lines, an autonomous header would be committed independently and complicate the transaction, and statement-level rollback undoes only the single failing statement.

Question 3 of 3

A developer must load 2 million rows from a cursor and process them in chunks without running out of PGA memory. Which technique is appropriate?

  1. A Declare the collection as a VARRAY(2000000) so its memory is preallocated
  2. B Use a cursor FOR loop, which always fetches the entire result set at once
  3. C FETCH the cursor with BULK COLLECT INTO a collection LIMIT 1000 in a loop (correct answer)
  4. D SELECT ... BULK COLLECT INTO a collection once without any LIMIT clause
Why: BULK COLLECT with LIMIT fetches a bounded number of rows per round trip, keeping memory usage predictable while still minimizing context switches. Collecting everything at once can exhaust PGA, a large VARRAY does not reduce memory use, and a cursor FOR loop does not fetch the entire result set at once (it array-fetches 100 rows at a time when optimized).

What your score report looks like

Example attempt, 1Z0-149 practice test 3

77%

Passed
Pass mark 65%

Score by exam domain
DomainWeightYour score%
Declaring Variables and Writing Executable Statements 10%
88
Writing SQL in PL/SQL and Control Structures 10%
81
Working with Composite Data Types 8%
76
Using Explicit Cursors 9%
58
Handling Exceptions 10%
84
Creating Procedures and Functions 11%
72

Study next: Using Explicit Cursors. It is below the pass mark and carries 9% of the exam.

Domains and pass mark from our 1Z0-149 practice tests. Scores are an example attempt.

Study plans

Two weeks

  1. Day 1: take practice test 1 in exam mode to get a baseline.
  2. Days 2 to 5: domain mode on Creating Procedures and Functions and Creating and Working with Packages, the two most heavily weighted domains.
  3. Day 6: practice test 2 in exam mode, then the mistakes quiz.
  4. Days 7 to 12: practice tests 3 to 5, one every other day, each followed by its mistakes quiz.
  5. Days 13 and 14: final mode. Book the exam when your readiness stays above the pass mark.

Four weeks

  1. Week 1: one practice test in practice mode, reading every explanation. Note your two lowest domains.
  2. Week 2: domain mode on those two domains, then a second practice test in exam mode.
  3. Week 3: practice tests 3 and 4 in exam mode, with the mistakes and flagged quizzes after each.
  4. Week 4: practice test 5 and final mode until your readiness holds above the pass mark.

Questions about the 1Z0-149 practice exams

Are these real 1Z0-149 exam questions?
No. We write every question ourselves and map it to the published 1Z0-149 exam objectives. We do not use leaked or recalled questions.
Do the time limit and pass mark match the official exam?
They match the settings of our practice tests. Exam providers change their format from time to time, so check the official exam page before you book.
Can I try it before I pay?
Yes. The free mini exam has 15 questions with full explanations and needs no account.
How long do I keep access?
A single-exam purchase gives you 12 months of access. All-Access includes this exam for as long as your subscription runs.
What happens after I finish a test?
You get a score, a pass or fail against the pass mark, a score per domain and every answer with its explanation.

Last updated November 2026. Written and reviewed by the DevOpsCode Lab team.

DevOpsCode Lab is not affiliated with Oracle. 1Z0-149 and related names are trademarks of their owners.

Related exams
Exam Vendor Level Questions Minutes Price
1Z0-1085-26OCI Foundations 1Z0-1085-26 Oracle Foundational 200 60 $9.99
1Z0-1122-26OCI AI Foundations 1Z0-1122-26 Oracle Foundational 300 90 $9.99
DP-900Azure Data Fundamentals DP-900 Microsoft Foundational 225 45 $9.99
SPLK-1001Splunk Core Certified User (SPLK-1001) Splunk Foundational 300 60 $9.99
A00-231SAS Base Programming A00-231 SAS Associate 300 135 $12.99
COF-C03SnowPro Core COF-C03 Snowflake Associate 300 70 $12.99