- What This Credential Actually Is
- Exam 1Z0-006 and How Oracle Academy Maps to It
- The Six Curriculum Areas, Walked Through
- Fees, Subscription Mechanics, and Registration
- What You Should Not Assume About the Exam
- Who Benefits From This Certification
- Sequencing the Domains in Your Preparation
- Frequently Asked Questions
- The certification is Oracle Database Foundations, exam code 1Z0-006, issued by Oracle Corporation.
- Oracle Academy maps its Database Foundations preparation course directly to exam 1Z0-006.
- Six curriculum headings run from Introduction through Introduction to SQL; they are unweighted, not official exam domains.
- The US Oracle Store lists 1Z0-006 in a US$95 Foundations Exam Subscription: one attempt, six-month term.
What This Credential Actually Is
Oracle Database Foundations is an entry-level certification from Oracle Corporation that tests whether a candidate understands how relational databases are conceived, modeled, and queried. It is not an administration exam and it is not a developer exam. It sits at the conceptual front door of the Oracle ecosystem: what a database is, how business information becomes entities and relationships, how a logical design becomes tables and columns, and how basic SQL retrieves the result.
If you are new to the term itself, our explainers on what Database Foundations certification is and what Database Foundations stands for cover the naming and positioning in more depth. This article focuses on the practical anatomy of the credential: which exam, which topics, which purchase route, and what remains unconfirmed.
Exam 1Z0-006 and How Oracle Academy Maps to It
The exam code to remember is 1Z0-006, titled Oracle Database Foundations. It is easy to confuse with neighboring Oracle exams, so keep the distinctions clear:
- 1Z0-006 is Oracle Database Foundations, the subject of this site.
- 1Z0-071 is a different Oracle exam and should not be substituted when you search for study materials or register.
- Oracle's newer "AI Database Foundations" branding is likewise a separate matter and is not the identity covered here.
The strongest official link between preparation and the exam comes from Oracle Academy, which explicitly maps its Database Foundations course to 1Z0-006 on its certification resources page. The course is described as a 90-hour curriculum. That figure describes the length of the preparation course, not an exam timer and not a mandatory prerequisite. Oracle Academy also states that professional hands-on experience is not assumed, which is consistent with the credential's entry-level purpose. For a fuller treatment of who can sit the exam, see our guide to Database Foundations requirements and eligibility.
Oracle's current certification catalog still lists Database Foundations, and the Oracle Academy course description PDF remains linked from its current Database Curriculum page, so the preparation path has not been retired.
The Six Curriculum Areas, Walked Through
The six headings below come from the lesson-group headings in the Oracle Academy Database Foundations course description (copyright 2020). They are best read as a preparation curriculum map. They are not weighted, and Oracle has not published them here as six official exam domains, so do not treat any heading as worth a fixed share of the exam. For a deeper breakdown, see our complete guide to all six content areas.
Domain 1: Introduction
This opening area establishes vocabulary and context. Expect to be comfortable with what a database is, why organizations use one rather than scattered files, and how data, information, and business requirements relate.
- Explain the purpose of a database in plain business terms.
- Distinguish data from information and from the system that manages them.
- Recognize where relational thinking fits among other ways of storing data.
Domain 2: Databases and Data Modeling
This is where conceptual design begins. Candidates learn to read a business scenario and extract entities, attributes, and relationships, then represent them in an entity relationship model.
- Identify entities, attributes, and unique identifiers from a written scenario.
- Describe relationships between entities, including optionality and degree.
- Read and interpret an entity relationship diagram without being told what it means.
Domain 3: Refining the Data Model
A first-draft model is rarely correct. This area covers improving it: resolving awkward relationships, handling hierarchies and recursive structures, and applying normalization thinking so data is not duplicated or contradictory.
- Recognize problems such as redundancy and repeating groups in a draft model.
- Understand why many-to-many relationships need to be resolved before implementation.
- Apply the basic idea of normal forms to judge whether a design is sound.
Domain 4: Oracle SQL Developer Data Modeler
This is the most tool-specific heading. It concerns Oracle's own modeling tool, used to build and manage models visually. Even if your exam is conceptual, familiarity with what the tool does and how a model moves through it helps the earlier areas make sense.
- Know what the Data Modeler is for and where it fits in the design workflow.
- Understand how logical and relational models are represented inside the tool.
- Practice building a small model so the interface is not unfamiliar.
Domain 5: Mapping to the Physical Model
Here the logical design becomes something a database can actually hold. Entities become tables, attributes become columns, unique identifiers become keys, and relationships become foreign key constraints.
- Translate each element of a logical model into its relational counterpart.
- Explain primary keys, foreign keys, and the integrity they enforce.
- Understand how a relationship's characteristics influence the resulting table structure.
Domain 6: Introduction to SQL
The closing area moves from design to retrieval. Candidates should be able to read and reason about basic queries against relational tables, which is the point where the modeling work pays off.
- Read simple SELECT statements and predict what they return.
- Understand projection, selection, and the role of a WHERE clause.
- Appreciate how table design from earlier areas determines what queries are possible.
Notice the arc: concepts, then modeling, then refinement, then tooling, then implementation, then querying. It mirrors how a real project proceeds, and thinking of it as one continuous story is easier than memorizing six isolated lists. Our one-page Database Foundations cheat sheet compresses these ideas for last-minute review.
Fees, Subscription Mechanics, and Registration
The clearest purchasing route identified is the Oracle Store's Foundations Exam Subscription, which explicitly includes 1Z0-006. In the US store it is priced at US$95 and provides one exam attempt within a six-month subscription term. Oracle is identified as the delivery provider for the subscription.
| Item | What the Oracle Store lists |
|---|---|
| Product | Foundations Exam Subscription (includes 1Z0-006) |
| US price | US$95 |
| Exam attempts included | One |
| Subscription term | Six months |
| Delivery provider | Oracle |
Because the subscription includes only one attempt, it rewards being prepared before you activate it. For the broader financial picture, including what else you might spend on preparation, see our Database Foundations certification cost breakdown, and for timing questions consult the page on exam dates and scheduling.
What You Should Not Assume About the Exam
Honest preparation requires knowing where public information runs out. The Oracle catalog currently links a MyLearn route labelled with a CHS suffix for 1Z0-006, but its exam-detail page could not be retrieved for verification. That has several consequences worth stating plainly:
- Question count, time limit, item format, and cut score could not be confirmed from an accessible official page. Third-party sites quote conflicting numbers, and those figures are deliberately not repeated here.
- English-language availability is not confirmed merely because the exam appears in the catalog or the store. Check the language options at the moment you register.
- The six curriculum headings are not a blueprint. They organize preparation; they do not tell you how many questions each topic receives.
Key Takeaway
Before paying, open Oracle's current exam page and record the question count, duration, format, and passing score from the source. Distrust any site, including ours, that states these figures without a verifiable Oracle citation. Our article on the Database Foundations passing score explains how to interpret what you find.
The same caution applies to difficulty and pass-rate claims. No verified public pass-rate figure is relied upon here; our pieces on how hard the exam is and on the pass rate discuss what can and cannot be said responsibly.
Who Benefits From This Certification
Oracle designed the course for people who do not yet have hands-on database experience, so the natural audience is students, career changers, and early-career staff who need a credible first credential. It is also useful for people adjacent to databases who must communicate with technical teams without building the systems themselves.
- Students in IT, computer science, or business programs who want a recognized Oracle credential alongside coursework.
- Career changers moving toward data, analytics, or development roles who need proof of foundational literacy.
- Business analysts and project coordinators who translate requirements into data models and need the modeling vocabulary.
- Aspiring Oracle professionals who plan to continue into SQL, development, or administration certifications and want the conceptual base first.
Be realistic about hiring. A foundations-level credential demonstrates literacy and initiative; it rarely substitutes for experience, but it can help an application stand out at the entry level, particularly in organizations that run Oracle technology. We do not quote salary figures here because none can be tied reliably to this specific exam; our salary guide, jobs overview, and worth-it analysis take a measured view of the career side.
Sequencing the Domains in Your Preparation
The one place where a schedule genuinely helps is ordering the six areas so each builds on the last. Because the curriculum is cumulative, front-load the modeling material and leave SQL for when you can already picture the tables you are querying. The 90-hour Oracle Academy course is a useful reference for pacing, though it is not a requirement, and a candidate with prior exposure can move faster.
Introduction and Databases and Data Modeling
- Learn the vocabulary of entities, attributes, and relationships.
- Draw entity relationship diagrams from short written scenarios.
Refining the Data Model
- Practice spotting redundancy and resolving many-to-many relationships.
- Rework your Week 1 diagrams using normalization reasoning.
Oracle SQL Developer Data Modeler and Mapping to the Physical Model
- Rebuild a small model in the tool, then map it to tables, columns, and keys.
- Explain each mapping rule aloud: why this entity became that table.
Introduction to SQL and full review
- Write and read basic queries against tables you designed yourself.
- Finish with timed practice questions and revisit your weakest area.
Adjust the pace to your background, and consult the Database Foundations study guide and the training resources overview for deeper material. When you are ready to test yourself, the Database Foundations practice tests on our main site let you check each curriculum area under exam-style conditions.
Frequently Asked Questions
The exam is 1Z0-006, Oracle Database Foundations, issued by Oracle Corporation. It should not be confused with 1Z0-071 or with Oracle's separate AI Database Foundations branding, which are different credentials.
The US Oracle Store lists 1Z0-006 within a US$95 Foundations Exam Subscription that provides one exam attempt over a six-month term. Prices can vary by region and change over time, so confirm on the Oracle Store at purchase.
No. Oracle Academy states that professional hands-on experience is not assumed, and its 90-hour course is preparation rather than a mandatory prerequisite. It is a useful way to cover the material, but it is not a gate to sitting the exam.
No. The six headings come from the Oracle Academy course lesson groups and are unweighted preparation headings. They show what to study but do not state how many questions each area receives on the exam.
That could not be verified from an accessible official Oracle page, and conflicting third-party figures are not repeated here. Check Oracle's current exam detail page for the question count, time limit, format, and cut score before you register.