A bank is only as good as its last update. TestValid checks the 1Z0-149 content continuously and emails each new Oracle Database 19c: Program with PL/SQL version to you automatically — free for 365 days, so staleness never costs you a point.
Oracle 1Z0-149 Exam Overview:
| Certification Vendor: | Oracle |
|---|---|
| Exam Name: | Oracle Database 19c: Program with PL/SQL |
| Exam Number: | 1Z0-149 |
| Related Certifications: | Oracle Database SQL Certified Associate |
| Exam Price: | USD $245 |
| Real Exam Qty: | 65 |
| Available Languages: | English |
| Certificate Validity Period: | Lifetime |
| Exam Format: | Multiple Choice, Scenario-Based Questions |
| Exam Duration: | 90 minutes |
| Passing Score: | 66% |
| Recommended Training: | Oracle Database 19c: Program with PL/SQL |
| Exam Registration: | Pearson VUE Scheduling Oracle University Registration |
| Sample Questions: |  |
| Exam Way: | Online proctored or onsite at Pearson VUE testing centers |
| Pre Condition: | Recommended: Pass Oracle Database SQL Certified Associate (1Z0-071) or equivalent SQL knowledge |
| Official Syllabus URL: | https://education.oracle.com/oracle-database-19c-program-with-pl-sql/pexam_1Z0-149 |
Oracle 1Z0-149 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Declaring PL/SQL Variables | 10% | - Variables, initialization, and bind variables - Data types, %TYPE and %ROWTYPE attributes - Valid and invalid identifiers |
| Managing PL/SQL Code | 8% | - Performance optimizations: BULK COLLECT, FORALL - Dependency tracking and management - Conditional compilation - ACCESSIBLE BY clause and access control |
| Writing Executable Statements | 10% | - Implicit and explicit data type conversion - Nested blocks and variable scoping - Lexical units in PL/SQL blocks - SQL functions and sequences in PL/SQL |
| Handling Exceptions | 8% | - Exception propagation and handling - Predefined exceptions - User-defined exceptions |
| Using Explicit Cursors | 10% | - Cursor variables - Cursor attributes and FOR loops - Implicit vs explicit cursors |
| Writing Control Structures | 10% | - Sequential control - Conditional statements - Iterative and loop statements |
| Working with Packages | 12% | - Package specification and body - Package variables, constants, and cursors - Overloading subprograms |
| Writing SQL in PL/SQL | 12% | - SELECT ... INTO clause usage - Record types, %ROWTYPE, and collections - DML and transaction control statements |
| Creating Procedures and Functions | 12% | - Parameter modes: IN, OUT, IN OUT - Function return types and usage - Creation and invocation of subprograms |
| Creating Triggers | 8% | - Trigger restrictions and ordering - DML and INSTEAD OF triggers - DDL and system event triggers |
1Z0-149 Exam Facts for Busy Professionals
According to the latest exam information, the 1Z0-149 exam contains 65 questions and runs for 90 minutes minutes. Simulating that exact limit in practice builds the pacing a tough exam demands.
The Oracle Database 19c: Program with PL/SQL blueprint centers on these domains:
- Working with Packages (12%)
- Writing Control Structures (10%)
- Using Explicit Cursors (10%)
Further domains complete the official outline — the question bank covers every one.
Registration goes through the official channels below:
Pick a test center or online slot that suits your calendar, and book early — preparation goes smoother with a date in place.
Clear terms, no runaround. If you fail the corresponding exam within 60 days of purchase, send us a scanned copy of your enrollment slip and your official Score Report PDF within two days of the exam date; verified claims are refunded in full within seven days. Exclusions: exams taken within three days of purchase, candidate names that do not match the payer, and free or expired products. Prefer to switch tracks? Exchange your product for two others of equal value at no cost.
A team of IT experts and certified trainers with rich experience in the Oracle Database 19c: Program with PL/SQL field writes it — and keeps it honest. Every answer is expert-verified, the content is checked continuously for updates, and each new 1Z0-149 version is emailed to you free for 365 days. Compared with training institutions, the bank is affordable and self-paced; compared with guesswork, it is systematic. Download the free demo first, and if anything goes wrong — even a simple downloading problem — 24/7 customer assistance is one message away.
Oracle lists these official training options for candidates:
Structured training plus consistent self-practice covers both depth and exam readiness.
Oracle states the following prerequisites for the Oracle Database 19c: Program with PL/SQL: Recommended: Pass Oracle Database SQL Certified Associate (1Z0-071) or equivalent SQL knowledge.
Confirm the current requirements on the official certification page before you register.
Currently, the 1Z0-149 exam requires a passing score of 66%, with a registration fee of USD $245. Oracle sets both figures, so verify the latest on the official site before scheduling.
Upon successful payment, our system automatically sends the product to your mailbox — typically within about a minute — with an instant download link on screen. If nothing arrives within two hours, check your spam folder and contact our 24/7 customer assistance. Updates are free for 365 days: the moment a new version releases, the latest bank is sent to your email immediately, no matter when you purchased. A 50% renewal discount applies when the period ends.
Oracle Database 19c: Program with PL/SQL Sample Questions:
SERVEROUTPUT is enabled.
Which is the correct method to use a PACKAGED CONSTANT in SELECT statements?
- A.
- B.
- C.
- D.
Correct Answer: A 🗳️
In one of your databases, table HR.EMPLOYEES includes the columns FIRST_NAME and EMPLOYEE_ID.
A row exists with EMPLOYEE_ID 201.
Examine these packages created by user HR:
EXECUTE privilege is granted to user SH, on the HR.API and HR.HELPER packages.
Which two will execute successfully? (Choose two.)
- A. Call HR.API.P1 from the SH schema.
- B. Call HR.HELPER.H1 from the SH schema.
- C. Call HR.HELPER.H1 from the HR schema.
- D. Call HR.API.P1 from the HR schema.
- E. Create and call a package procedure API.H1 in the SH schema, which calls HR.HELPER.H1.
Correct Answer: A,B 🗳️
Which is true about EXIT and CONTINUE statements?
- A. They have the same effect on the execution of a loop.
- B. They can be used in any type of loop.
- C. They must use labels.
- D. They must have a WHEN condition.
Correct Answer: B 🗳️
Which three are true about DDL triggers? (Choose three.)
- A. They can be fired when a privilege is granted to a user.
- B. They cannot include the WHEN clause.
- C. They must be created in a disabled state.
- D. They fire only when a DDL statement is executed by the owner of the trigger.
- E. They can be fired either before or after a DDL statement executes.
- F. They can be fired when a table is truncated.
- G. They must be created in an enabled state.
Correct Answer: D,E,F 🗳️
Examine these statements issued by user SH which execute successfully:
DBMS_OUTPUT.PUT_LINE(p_price(i)); END LOOP; END; END products_pkg; /
Now, examine this anonymous block executed by SH:
Which is true about the anonymous block?
- A. It will fail only at line 7.
- B. It will fail at lines 6 and 7.
- C. It will execute successfully only if PriceList is defined as an associative array in the package and anonymous block.
- D. It will execute successfully only if PriceList is removed from the DECLARE section and defined as a standalone collection type.
Correct Answer: A 🗳️
Madge 
Alma 
Martina 
Gladys 
Willie 
Ralap 
Lyndon 
Otis 
Lawrence 
Elsie 
Daniel 
Lance 
Tina 
Ingram 
Tess 
Priscilla 
Herbert 
Griselda 
Salome 
Page 
Hubery 
Jo 
