Learn mode
Learn as you go
Choose an answer, reveal the marked key, and move through the bank at your own pace.
238 questions open free
Start guided practiceOracle Database SQL
The SQL foundation exam for the Oracle Database track: writing and tuning queries, manipulating data, defining schema objects, and using the analytical features of Oracle SQL.
Oracle Database SQL is Oracle's associate-level databases certification, sat as exam 1Z0-071. The exam runs for 1 hour 40 minutes and presents up to 78 questions, with a pass mark of published per exam by Oracle.
The published exam guide lists 8 sections but does not assign public weightings, so plan to cover each in similar depth rather than betting on one being dominant.
Confirm these details on the official Oracle page before booking — vendors adjust format and pricing without notice.
Some forms include unscored trial questions
The published exam guide for 1Z0-071, in the vendor's own order.
01Relational Database Concepts
02Retrieving Data using the SQL SELECT Statement
03Restricting and Sorting Data
04Using Single-Row and Conversion Functions
05Using Group Functions and Joins
06Using Subqueries and Set Operators
07Managing Tables, Indexes, Views and Sequences
08Managing Data in Different Time Zones
No formal prerequisite; practical SQL experience is expected.
Associate level — Role-based credentials for practitioners with hands-on experience.
Start with 238 complete questions in the 1Z0-071 bank. Free progress and bookmarks stay in this browser.
Choose an answer, reveal the marked key, and move through the bank at your own pace.
238 questions open free
Start guided practiceKeep answers hidden on the clock and review every miss after you finish the public set.
Free timed practice
Open timed mockAll questions and practice tests are free.
No sign-up, payment or access expiry. Your progress stays in this browser.
Questions, answered
Clear answers about the exam, the study experience, and what to expect before you begin.
Oracle lists up to 78 questions, to be completed in 1 hour 40 minutes. Question counts can vary slightly between exam forms, and unscored trial questions are sometimes included.
Published per exam by Oracle. Confirm the current figure on the official exam page before booking, as vendors adjust cut scores when an exam form is refreshed.
No formal prerequisite; practical SQL experience is expected.
The exam guide covers Relational Database Concepts, Retrieving Data using the SQL SELECT Statement, Restricting and Sorting Data, Using Single-Row and Conversion Functions and Using Group Functions and Joins, plus 3 further domains. The full weighted breakdown is listed above.
Yes — this exam has 238 practice questions available here, each with the correct answer marked.