What is the Duration of Oracle 1z0-149 Exam?

The Oracle 1z0-149 exam has a total duration of 120 minutes.

What are the Number of Questions Asked in Oracle 1z0-149 Exam?

The number of questions asked in the Oracle 1z0-149 Exam is 80.

What is the Passing Score for Oracle 1z0-149 Exam?

The passing score for the Oracle 1z0-149 Exam is 63%.

What is the Competency Level required for Oracle 1z0-149 Exam?

The competency level required for the Oracle 1z0-149 Exam is intermediate to advanced.

What is the Question Format of Oracle 1z0-149 Exam?

The question format of the Oracle 1z0-149 Exam is multiple choice and multiple response.

How Can You Take Oracle 1z0-149 Exam?

The Oracle 1z0-149 exam can be taken either online or at a testing center. Online exams are taken remotely, allowing you to take the exam from the comfort of your own home or office. To take the exam online, you will need a reliable internet connection, a webcam, and a quiet, distraction-free environment. On the other hand, if you prefer to take the exam at a testing center, you can locate a testing center near you and schedule an appointment. Testing centers offer a secure and monitored environment for taking the exam. Whichever option you choose, you will need to register for the exam through the Oracle website and pay the exam fee.

What Language Oracle 1z0-149 Exam is Offered?

The Oracle 1z0-149 exam is offered in English only. This means that all exam materials, including the exam questions and answers, will be in English. If English is not your first language, you may want to consider taking an English language course or practice exam to prepare for the exam.

What is the Cost of Oracle 1z0-149 Exam?

The cost of the Oracle 1z0-149 exam varies depending on your location and the testing option you choose. In the United States, the cost of the exam is $245 for online exams and $245 for testing center exams. However, prices may vary in other countries. You can check the Oracle website for the most up-to-date pricing information.

What is the Target Audience of Oracle 1z0-149 Exam?

The Oracle 1z0-149 exam is designed for database administrators, developers, and architects who have experience working with Oracle Database 19c. The exam tests your knowledge and skills in areas such as database architecture, backup and recovery, performance tuning, and security. The exam is intended for professionals who want to demonstrate their expertise in these areas and earn an Oracle Database 19c certification.

What is the Average Salary of Oracle 1z0-149 Certified in the Market?

The average salary of Oracle Database 19c: Program with PL/SQL certified professionals varies widely by role, region, and experience, because it depends on the job the certification is combined with. Check current listings in your market for an up-to-date figure.

Who are the Testing Providers of Oracle 1z0-149 Exam?

Oracle University is the testing provider for the Oracle 1z0-149 exam.

What is the Recommended Experience for Oracle 1z0-149 Exam?

Oracle recommends at least 2 years of experience in developing database applications using PL/SQL.

What is the Expected Retirement Date of Oracle 1z0-149 Exam?

The Oracle 1z0-149 exam is the current version of the Oracle Database 19c: Program with PL/SQL exam, and Oracle has not announced a retirement date for it. When Oracle introduces a newer version, the retirement date for the older version is published on the Oracle certification site.

What is the Difficulty Level of Oracle 1z0-149 Exam?

The Oracle 1z0-149 Exam is considered to be of moderate to high difficulty level. It is designed for professionals who have a strong understanding of Oracle Database concepts and experience in administering Oracle databases.

What is the Roadmap / Track of Oracle 1z0-149 Exam?

The Oracle 1z0-149 exam is part of the Oracle Database PL/SQL Developer Certified Professional certification track. More information can be found on the Oracle Certification website: https://education.oracle.com/oracle-database-pl-sql-developer-certified-professional/overview/plsql-developer-certified-professional

What are the Topics Oracle 1z0-149 Exam Covers?

The Oracle 1z0-149 Exam covers topics such as Oracle Database Architecture, Multitenant Architecture, Backup and Recovery, Performance Management, Security, and SQL Tuning.

What are the Sample Questions of Oracle 1z0-149 Exam?

Sample questions for the Oracle 1z0-149 Exam are not publicly available, but there are many practice exams and study materials available online.

← Back to exam page

Free 1z0-149 – Oracle Database 19c: Program with PL/SQL Practice Test Question

Free demo downloads

Loading demo links...

Showing 1–10 of 10 questions

Question 1

The SH schema contains the PRODUCTS table with column PDT_NAME defined as VARCHAR2(10).

Which two blocks of code execute successfully when invoked by user SH? (Choose two.)

Select all that apply, then click Submit answer.

○
Option A
○
Option B
○
Option C
○
Option D
○

Ask AI for More Explanation

— your own AI account, opens inside the app

Question 2

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

Select all that apply, then click Submit answer.

○
Variables and cursors defined in a package specification are visible to all subprograms in the same schema that has the package.
○
Modifications to a packaged procedure's body automatically cause recompilation of subprograms that invoke the procedure.
○
Package specifications can be compiled without their bodies.
○
Standalone subprograms that reference a package can be compiled only after both the package specification and body are compiled.
○
A package definition must have a specification and body.

Ask AI for More Explanation

— your own AI account, opens inside the app

Question 3

Which two statements are true about using the OR REPLACE clause when creating named subprograms? (Choose two.)

Select all that apply, then click Submit answer.

○
Function based indexes remain usable when replacing the function on which the index depends.
○
Object privileges to execute a replaced function must be regranted to those users who had the privilege.
○
This clause can be used only for procedures and functions.
○
A function definition can be modified without dropping and re-creating it.
○
Object privileges to execute a replaced function are retained by those users who had the privileges.

Ask AI for More Explanation

— your own AI account, opens inside the app

Question 4

Which three are true about the procedure overloading feature? (Choose three.)

Select all that apply, then click Submit answer.

○
Each procedure can be a nested subprogram.
○
Each procedure's formal parameters can differ in data type or name.
○
Each procedure must use named notation to specify the corresponding actual parameters.
○
Each procedure's formal parameters must differ in name.
○
Each procedure can be a packaged subprogram.
○
Each procedure must use positional notation to specify the corresponding actual parameters.
○
Each procedure can be a standalone subprogram.

Ask AI for More Explanation

— your own AI account, opens inside the app

Question 5

Examine this DECLARE section:

Which two lines are valid? (Choose two.)

Select all that apply, then click Submit answer.

○
line 5
○
line 6
○
line 7
○
line 4
○
line 3
○
line 2

Ask AI for More Explanation

— your own AI account, opens inside the app

Question 6

Examine the EMPLOYEES table structure:

Now, examine this code:

Which statement is true about the result of executing this block?

Select an option, then click Submit answer.

○
It will execute successfully provided the salary of EMP_ID 200 does not exceed the value 99999.
○
It will return an error at line 2.
○
It will return an error at line 3.
○
It will return an error at line 8.
○
It will execute successfully by rounding up the salary of EMP_ID 200 to the appropriate value.

Ask AI for More Explanation

— your own AI account, opens inside the app

Question 7

SERVEROUTPUT is enabled.

Which is the correct method to use a PACKAGED CONSTANT in SELECT statements?

Select an option, then click Submit answer.

○
Option A
○
Option B
○
Option C
○
Option D

Ask AI for More Explanation

— your own AI account, opens inside the app

Question 8

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

Select an option, then click Submit answer.

○
Option A
○
Option B
○
Option C
○
Option D

Ask AI for More Explanation

— your own AI account, opens inside the app

Question 9

Examine these statements which execute successfully:

Which anonymous block executes successfully?

Select an option, then click Submit answer.

○
Option A
○
Option B
○
Option C
○
Option D

Ask AI for More Explanation

— your own AI account, opens inside the app

Question 10

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

Select an option, then click Submit answer.

○
Option A
○
Option B
○
Option C
○
Option D

Ask AI for More Explanation

— your own AI account, opens inside the app

About the 1z0-149 Free Practice Test

Thinking of taking the Oracle Database 19c: Program with PL/SQL (1z0-149) exam? This free Oracle practice test is the place to start. The 10 questions come free from the full 65-question Study4Pass practice set — a quick, honest check of where you stand. The free sample includes 5 single-answer and 5 multiple-answer questions — the same mix of formats you will meet in the full set. The set follows the real exam’s spread of topics: PL/SQL program structure, Control structures, Collections and Error handling. The duration of the Oracle 1z0-149 Exam is 120 minutes.

The Oracle 1z0-149 exam is designed for database administrators, developers, and architects who have experience working with Oracle Database 19c. There are no prerequisites for the Oracle 1z0-149 exam.

Certification: Oracle Database 19c: Program with PL/SQL (1z0-149)
Vendor: Oracle
Free on this page: 10 practice questions with answers and explanations
Full practice set: 65 questions

Work through the questions one at a time and read every explanation, even for the ones you get right — the reasoning behind an answer is what the real exam tests. If one area keeps costing you marks, you have found exactly what to revise before exam day.

Think of the result as a map, not a verdict. The questions you miss point straight at the topics that need work, and the explanations tell you why the correct option wins. Candidates who loop through that cycle — practise, review the reasoning, re-test — walk into the real exam having already seen their weak spots and fixed them.

Inside the full 1z0-149 practice set:

All 65 questions with answers and explanations
Timed Exam Simulation that mirrors the real exam pressure
Topic Training to drill one domain at a time
Ask AI for More Explanation on every question
Flag questions and review them before you finish

How to use this 1z0-149 free practice test

There is no clock and no account needed. Answer each question, check the result, and read the explanation before moving on. For anything that still feels unclear, Ask AI is built into this AI-Enabled practice test — it explains the concept behind the question so the next one like it gets easier. When the free sample feels comfortable, the full set of 65 questions adds timed Exam Simulation, topic-by-topic training, and flagged-question review — the closest thing to exam day you can get before the real thing.

What to study for each 1z0-149 domain

PL/SQL program structure — Use the practice questions to find your gaps in PL/SQL program structure first, then read the official Oracle documentation for anything you missed.
Control structures — For Control structures, focus on understanding why each correct answer is right; the real exam rewards reasoning over recall.
Collections — Drill Collections with the questions above, and revisit any explanation that surprises you — surprises are exactly what to fix before the exam.
Error handling — Work through the Error handling questions until the reasoning behind each answer is clear — guessing your way past this area will show up on exam day.
And more — Use the practice questions to find your gaps in And more first, then read the official Oracle documentation for anything you missed.

1z0-149 practice test — quick questions

Is this 1z0-149 practice test free?

Yes. Every question on this page — all 10 of them — is free to use, and you never need to create an account to try them.

How many questions are in the full 1z0-149 set?

The full Study4Pass set for 1z0-149 has 65 practice questions. This page gives you 10 of them free so you can judge the quality and difficulty first.

Does the free test show the answers?

Yes. Check any question to reveal the correct answer and its explanation, and use Ask AI whenever you want the underlying concept explained step by step.