Learn mode
Learn as you go
Choose an answer, reveal the key, and review available explanations, citations and candidate context.
25 questions free
Start guided practiceThe 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.
Preview 25 supported questions before unlocking the 233-question 1Z0-071 bank.
Community-contributedCompiled from publicly posted community exam discussions. Contributed by third parties rather than written here, so accuracy varies and most items carry no explanation. Progress and bookmarks stay in this browser.
Answer support: 89 explanations, 232 questions with candidate context and 51 questions with direct citations. Bank updated .
Choose an answer, reveal the key, and review available explanations, citations and candidate context.
25 questions free
Start guided practiceKeep answers hidden on the clock and review every miss only after you finish the public sample.
Free sample mock
Open timed mockWant the complete 233-question bank?
One Exam Pass unlocks this selected bank for 12 months with no renewal.
Compiled from exam discussions posted publicly by other people on ExamTopics. Copyright in each contribution rests with its original author; it is reproduced here for study. Not verified by us — most items carry no explanation. To request removal, see our content policy.
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 233 practice questions available here, each with the correct answer marked. They are community-contributed, compiled from exam discussions posted publicly by other people rather than written here, and most do not carry an explanation.