Free Exam Questions
1Z0-149 Exam Questions & Answers
Oracle Database 19c: Program with PL/SQL • Oracle
65 Questions
90 min
Updated Sep 2026
99% Pass Rate
Get Full Access
100% money-back guarantee
Sample 1Z0-149 Questions
Practice with real exam-style questions, each with the verified correct answer and explanation.
Q1
MultipleChoice
Examine the SH.PRODUCTS table:
A row exists in SH.PRODUCTS with PDT_ID = 1.
Now, examine this code and output executed by SH:
Now, examine this block of code:
Which error message(s) does it display on execution by user SH?
Correct Answer: A
Q2
MultipleChoice
Examine these statements:
Which two are true? (Choose two.)
Correct Answer: C, E
Q3
MultipleChoice
Which three are true about the procedure overloading feature? (Choose three.)
Correct Answer: B, E, F
Q4
MultipleChoice
Which three statements can process a dynamic multi-row query? (Choose three.)
Correct Answer: D, E, G
Q5
MultipleChoice
Which two are true about collections and RECORD types? (Choose two.)
Correct Answer: B, F
Get access to all 65 verified questions with detailed answers.
Unlock All 1Z0-149 QuestionsFrequently Asked Questions
The exam covers PL/SQL fundamentals, control structures, procedures, functions, packages, cursors, exception handling, and database interactions. It also includes topics on triggers, collections, and advanced PL/SQL features used in Oracle Database 19c environments.
The exam typically contains 60-70 questions that must be completed within 120 minutes. The exact passing score is not publicly disclosed by Oracle, but candidates generally need to score around 60-70% to pass, depending on the specific exam version.
Oracle recommends having at least one year of hands-on experience with PL/SQL programming and Oracle Database administration. While not strictly required, prior knowledge of SQL and database concepts is highly beneficial for exam success.
You can register for the exam through Oracle University's official website or Pearson VUE testing centers. The exam cost typically ranges from $245 to $335 USD, though pricing may vary by region and testing center.
Recommended study resources include Oracle's official PL/SQL documentation, Oracle University training courses, practice exams, and third-party study guides from reputable publishers. Hands-on practice with PL/SQL code in an actual Oracle Database 19c environment is essential for thorough preparation.