1Z0-149 practice examsIn development
Oracle Database PL/SQL Developer Certified Professional
The only real PL/SQL credential, and Oracle shops still hire against it: block structure with anchored declarations, cursors and the FOR loop that closes itself, collections and the bulk operations that remove context switching, exception handling that logs and re-raises; then procedures and functions with their parameter modes, packages as the central design construct, trigger types and the mutating table error, dynamic SQL with mandatory binding, and definer against invoker rights.
What you get
Papers are cut from the bank and weighted like the real exam, and no question appears in two of them. Every wrong answer comes back on later days until you have it right.
What the exam covers
| Language fundamentals, cursors and error handling | Not published |
| Program units, triggers, dynamic SQL and tuning | Not published |
Two sample questions
1. What does a compound trigger provide?
- A trigger that fires on several tables at once
- A trigger that fires on several events at once
- Sections for statement and row timing in one object — correct
- A trigger that runs in its own transaction
Why: State can be held between the sections, which is what avoids the mutating error.
2. What does BULK COLLECT INTO populate?
- A cursor
- A single scalar
- A collection — correct
- A trigger
Why: BULK COLLECT INTO populates a collection with the fetched rows.
The real 1Z0-149 exam
| Length | 90 minutes |
|---|---|
| Questions | 65 |
| Pass mark | 61% |
| Price | Purchased per attempt through Oracle University |
| Recommended before you sit it | None enforced. SQL knowledge and PL/SQL development experience are assumed. |
| Valid for | Does not expire, though it is tied to the release examined |
Exam facts as published by Oracle; always check the vendor’s page before you book.
Study 1Z0-149 with Chiron
Chiron is invitation-only while we are in beta, and nothing is for sale yet: invited accounts use every paper, drill and course note for free.