1Z0-149 exam-day guide
1Z0-149 · Prepare for the day ahead.
Your checklist
Government-issued photo ID
Bring the exact ID form the provider requires (typically a passport or national ID). The name on the ID must match the name on your registration exactly. Confirm accepted ID types and name-matching rules with the provider before exam day; do not assume a driver's license or expired document is accepted.
Appointment confirmation and candidate ID number
Have your registration confirmation, appointment time, and any candidate/eligibility number accessible (printed or on your phone). You may need the Oracle Testing ID or registration number at check-in. Confirm with the provider whether printed copies are required.
Know your delivery mode and test-center logistics
Determine whether you are testing at a physical center or online with a remote proctor. For a center, confirm the address, parking, and arrival buffer. For online, confirm the system test, room requirements, and check-in window. These details vary by provider, so confirm with the provider.
Run the system or equipment check in advance
If testing online, complete any required system test (webcam, microphone, browser lock, bandwidth) at least a day early and again on the morning of the exam. Fix issues before the appointment window rather than during check-in.
Review the exam structure and time budget
Know the number of questions, time limit, and whether question review or back-navigation is allowed. For 1Z0-149 (Oracle Database 19c: Program with PL/SQL), expect scenario-style multiple-choice questions on PL/SQL fundamentals, program units, and database programming. Confirm the current blueprint and passing score with Oracle.
Prepare a one-page PL/SQL recall sheet
Condense high-yield facts onto one page for a final review: cursor attribute behavior (SQL%ROWCOUNT, %FOUND, %NOTFOUND, %ISOPEN), parameter modes (IN, OUT, IN OUT) and their defaults, exception propagation and WHEN OTHERS ordering, package specification vs body rules, and trigger timing (BEFORE/AFTER, row vs statement). Review it in the last 24 hours only; leave it outside the testing room.
Plan your scratch materials
Many providers supply an erasable notepad or allow a dry-erase board; personal paper and pens are usually prohibited. Confirm what is provided and permitted with the provider, and do not bring your own scratch paper unless explicitly allowed.
Arrange a quiet, distraction-free environment (online testing)
Clear your desk of notes, books, phones, and second screens. Inform household members of your appointment window. Proctors typically require a room scan and may ask you to show your desk; confirm the specific room rules with the provider.
Plan timing, transport, and a buffer
Arrive or log in earlier than the appointment to absorb check-in delays. Build in extra time for traffic, security screening, or identity verification. Late arrival can forfeit your seat or fee; confirm the provider's late-arrival policy.
Confirm reschedule and cancellation terms
Check the deadline and fees for rescheduling or canceling in case of illness or emergency. Terms differ by provider and region; verify in your account or with the provider rather than relying on memory.
Rest, hydration, and a light meal
A multi-hour technical exam rewards steady concentration. Sleep well the night before and eat lightly beforehand; avoid heavy meals or excess caffeine that can cause restlessness during a proctored session.
Know your score-report and retake process
Understand how and when results are delivered and what the retake policy is. Passing scores and retake waiting periods are provider-specific; confirm with Oracle or the testing provider rather than assuming.
Plan the day
Shift from learning to consolidation. Re-read your own summary notes on PL/SQL blocks, cursors, procedures/functions, packages, triggers, and exception handling. Do timed practice sets to build pacing, then review every wrong answer for the underlying concept, not just the correct letter. Stop introducing new topics you have not studied; instead, close gaps in areas you already know. Confirm your appointment details, ID requirements, and delivery mode with the provider.
Do a light review of your one-page recall sheet and high-yield syntax, then stop studying early enough to sleep well. Prepare your ID, confirmation, and any permitted items in one place. Run the online system test if applicable. Avoid cramming new material late at night; fatigue costs more than a few extra facts gain.
Eat a light meal and hydrate moderately. Do a short, calm review of the recall sheet only. For online testing, complete the system check, clear your workspace, and close all other applications. For a test center, leave with a generous buffer. Log in or arrive early to absorb check-in and identity verification.
Read each question fully and identify what is actually being asked (behavior of a cursor attribute, validity of a package construct, trigger firing order). Answer confident questions first and flag uncertain ones if review is permitted. Eliminate clearly wrong options before choosing. Watch the clock and allocate roughly even time per question, leaving a few minutes to revisit flagged items. For PL/SQL code questions, mentally trace execution or consider compiling the snippet in your head: check declarations, parameter modes, and exception scope. Do not leave answers blank if there is no penalty for guessing; confirm the scoring rules with the provider.
Rules to check
Present valid, unexpired identification matching your registration name. Accepted ID types and name-matching rules vary; confirm with the provider before exam day.
Follow all proctor instructions. For online testing, expect identity verification, a room scan, and monitoring of your screen and webcam. Refusal to comply can result in termination of the session.
Do not bring unauthorized materials into the testing environment: notes, books, phones, smartwatches, and second screens are typically prohibited. Confirm permitted items (for example, scratch materials) with the provider.
Breaks are generally limited and may be unavailable during a timed exam; leaving the view of the camera or the testing room without permission can end your session. Confirm the break policy with the provider.
Scoring is based on correctly answered questions against a passing standard set by the exam owner. The passing score and any item-scoring details are provider-specific; confirm them with Oracle rather than assuming a simple percentage.
Results and any score report are delivered according to the provider's process. Do not expect immediate detailed feedback, and confirm timing and delivery method with the provider.
Retake eligibility, waiting periods, and fees are governed by the provider's policy. Confirm the current terms before scheduling a retake.
Maintain academic integrity: do not share, record, or reproduce exam content. Attempting to capture questions or use unauthorized assistance can void your result and affect eligibility.