- The Short Answer: What a "Database Foundations" Actually Is
- Who Issues It and What the Exam Code Is
- The Six Curriculum Areas Behind the Exam
- What You Actually Learn: Concepts Before Code
- Exam Format: What Is and Isn't Verified
- Fee and Registration Mechanics
- Who Should Take It and Who Hires for It
- Sequencing Your Preparation by Curriculum Area
- Common Confusions to Avoid
- Frequently Asked Questions
- Oracle Database Foundations is an Oracle Corporation credential, delivered through exam 1Z0-006.
- Oracle Academy maps its Database Foundations preparation course directly to 1Z0-006.
- The six curriculum areas run from Introduction through Introduction to SQL, with data modeling in the middle.
- The US Oracle Store lists a US$95 Foundations Exam Subscription with one attempt and a six-month term.
The Short Answer: What a "Database Foundations" Actually Is
When people ask "what is a Database Foundations?", they are almost always asking about an entry-level Oracle certification: Oracle Database Foundations, tested by exam 1Z0-006. It validates that you understand how relational databases are conceived, modeled, designed, and queried, before you ever touch advanced administration or performance tuning.
Think of it as the grammar of database work. Before you can write a clean query or design a schema that survives real business requirements, you need to understand entities, attributes, relationships, normalization, and how a logical design becomes tables and constraints. That conceptual layer is what this credential is built around.
It is not a developer exam, a DBA exam, or a cloud exam. It is a foundations-level credential aimed at people at the very start of a data career, or people from adjacent fields who need a defensible baseline in relational thinking. For a broader orientation, our overview What Is Database Foundations? covers the basics from a slightly different angle.
Who Issues It and What the Exam Code Is
The issuer is Oracle Corporation, and the exam identity is 1Z0-006, Oracle Database Foundations. That precision matters because the phrase "Database Foundations" is used loosely in the industry, and several unrelated credentials and courses share similar wording. On this site, the term refers only to the Oracle exam.
Two adjacent names are easy to confuse with it, so keep them separate:
- 1Z0-071 is a different Oracle exam (SQL-focused). It is not a substitute for 1Z0-006.
- Oracle AI Database Foundations is a different title. The credential discussed here carries no new AI certification and is not tied to a specific database release year.
The Oracle certification catalog continues to list Database Foundations, and Oracle Academy explicitly maps its Database Foundations preparation course to 1Z0-006. That mapping is the strongest official signal about what the exam expects you to know, which is why this article leans on the Oracle Academy course structure.
The Six Curriculum Areas Behind the Exam
The Oracle Academy Database Foundations course description (copyright 2020) organizes its lessons into six groups. These headings are the most reliable roadmap available for preparation. One caution up front: they are unweighted preparation-curriculum headings, not six official exam domains with published percentages, and they are not an exhaustive current exam blueprint. Treat them as the territory you should be fluent in, not as a scoring formula.
| Area | Heading | What it establishes |
|---|---|---|
| 1 | Introduction | What databases are, why organizations use them, core vocabulary |
| 2 | Databases and Data Modeling | Entities, attributes, relationships, and entity relationship diagrams |
| 3 | Refining the Data Model | Improving the design: normalization thinking, resolving problem relationships |
| 4 | Oracle SQL Developer Data Modeler | Using Oracle's modeling tool to build and manage the design |
| 5 | Mapping to the Physical Model | Turning a logical design into tables, columns, keys, and constraints |
| 6 | Introduction to SQL | Writing foundational queries against the resulting structures |
Notice the shape of the progression. The first five areas are about design; only the last is about writing SQL. That is the single most important insight for a newcomer: this is a design-first credential. If you expect a pure SQL syntax drill, you will be surprised by how much of the preparation is about modeling decisions. A deeper walkthrough of each area is available in our complete guide to all six content areas.
What You Actually Learn: Concepts Before Code
Introduction and Databases and Data Modeling
Domain 1: Introduction / Domain 2: Databases and Data Modeling
You build the mental model of a relational database and learn to describe a business in terms a database can store.
- Distinguishing entities from attributes and identifying unique identifiers
- Reading and drawing relationships, including cardinality and optionality
- Recognizing how a business scenario translates into an entity relationship diagram
- Understanding why modeling comes before building tables
Candidates tend to underestimate this stage. A business statement such as "each customer may place many orders, and every order must belong to exactly one customer" contains a relationship, a cardinality, and a mandatory-versus-optional rule. The ability to extract those three things quickly is worth more than memorizing definitions.
Refining the Data Model
Domain 3: Refining the Data Model
First-draft models almost always contain flaws. This area teaches you to find and fix them.
- Spotting redundancy and why it causes update problems
- Resolving many-to-many relationships into workable structures
- Thinking in normalization terms: each fact stored in the right place
- Recognizing when a model is ready to be implemented
Oracle SQL Developer Data Modeler
Domain 4: Oracle SQL Developer Data Modeler
This is the tool-specific area, and it is what makes the credential distinctly Oracle rather than generic relational theory.
- Navigating the Data Modeler environment and its logical and relational views
- Building entities and relationships inside the tool
- Understanding how the tool represents the same design at different levels
If you can, install Oracle SQL Developer Data Modeler and model a small scenario yourself. Clicking through the tool teaches the vocabulary far faster than reading about it.
Mapping to the Physical Model and Introduction to SQL
Domain 5: Mapping to the Physical Model / Domain 6: Introduction to SQL
Here the design becomes real. Logical entities turn into tables, attributes into columns, unique identifiers into primary keys, and relationships into foreign keys.
- Understanding how each logical construct maps to a physical one
- Primary keys, foreign keys, and constraints as the enforcement of your design
- Writing foundational SELECT statements with filtering and sorting
- Reading a query and predicting what it returns
Key Takeaway
Study the mapping step deliberately. Being able to say "this relationship becomes that foreign key" ties the design half of the curriculum to the SQL half, and it is where the two halves reinforce each other.
Exam Format: What Is and Isn't Verified
Many sites confidently state a question count, a time limit, and a passing percentage for this exam. We are deliberately cautious. The official exam-detail page linked from Oracle's catalog could not be retrieved for verification, which means question count, time limit, item format, and cut score cannot be confirmed from a current official source here. Conflicting third-party figures exist, and we have excluded them rather than pick one at random.
What you should do instead:
- Check the official Oracle exam page for 1Z0-006 at the moment you register, since that page governs the current details.
- Prepare for conceptual, scenario-style understanding rather than rote recall, because the curriculum is built around reasoning about designs and queries.
- Treat any specific numeric claims you read elsewhere as unverified until they match Oracle's own pages.
For discussion of how scoring works in general terms, see our piece on the Database Foundations passing score, and for realistic expectations on difficulty, the difficulty guide.
Fee and Registration Mechanics
The verified pricing path runs through Oracle's own store. The US Oracle Store explicitly includes 1Z0-006 in its US$95 Foundations Exam Subscription. The terms are specific:
- One exam attempt is included.
- The subscription has a six-month term.
- Oracle is identified as the delivery provider for the subscription.
Two clarifications prevent common misreadings. First, the six-month window is the subscription term, which governs how long you have to use your attempt. It is not the validity period of the certification itself. Second, the Oracle catalog currently links a MyLearn exam page carrying a "CHS" label, and the exam details on that page could not be retrieved. Catalog and store presence alone does not confirm that an English-language appointment is available, so confirm language and scheduling before you pay.
Who Should Take It and Who Hires for It
Oracle Academy states plainly that professional hands-on experience is not assumed. The associated 90-hour course is preparation, not a mandatory exam prerequisite, and it is not an examination timer. That makes the credential accessible to several groups:
- Students in computing, information systems, or business programs who want a recognized baseline.
- Career changers moving toward data, analytics, or development roles.
- Business analysts and project staff who work alongside database teams and need to read models and speak the language.
- Aspiring developers and DBAs who want a structured first step before more specialized Oracle exams.
On employment, be realistic. A foundations credential rarely earns a job by itself; it signals that you understand the vocabulary and design reasoning employers expect from junior candidates. Organizations running Oracle-based systems, consultancies, and teams that hire entry-level data and reporting staff are the natural audience. We discuss the landscape in Database Foundations jobs, and for the economics, the ROI analysis and salary guide. Eligibility specifics are covered in Database Foundations requirements.
Sequencing Your Preparation by Curriculum Area
Rather than a generic schedule, order your preparation to follow the dependency chain of the six areas. Each stage feeds the next, so skipping ahead tends to cost you later.
Introduction and Databases and Data Modeling
- Learn the core vocabulary until it is automatic
- Practice turning plain-English business rules into entities, attributes, and relationships
Refining the Data Model
- Take your week-one drafts and find the redundancy
- Resolve any many-to-many relationships
Data Modeler and Physical Mapping
- Rebuild your models inside Oracle SQL Developer Data Modeler
- Map each logical element to its table, column, and key
Introduction to SQL and full review
- Write queries against the structures you designed
- Run timed practice questions across all six areas
The reasoning: SQL feels most intuitive once you have designed the tables yourself, so leaving it for last is a feature, not a delay. For a fuller plan, see the Database Foundations study guide and the one-page cheat sheet for final review. When you are ready to test yourself, use our Database Foundations practice tests to find weak areas before exam day.
Common Confusions to Avoid
"Is this the same as an SQL certification?"
No. SQL appears only in the final curriculum area. A candidate who studies nothing but SELECT syntax will be underprepared for the modeling-heavy portion.
"Does passing mean I'm a certified DBA?"
No. This is a foundations credential. It establishes conceptual readiness, not administrative or performance expertise.
"Do I need the 90-hour course?"
It is preparation, not a prerequisite. Candidates who already know relational design may need far less; complete beginners may find the structured course valuable.
"Are the six areas six weighted domains?"
No. They are unweighted curriculum headings. Do not assume equal weighting, and do not skip an area because it seems small.
If you want vocabulary-level clarity before going deeper, our explainers on what Database Foundations stands for and what the certification is are good companions to this article. For the preparation path in particular, see Database Foundations training.
It is Oracle's entry-level certification, exam 1Z0-006, covering how relational databases are modeled, refined, mapped to physical tables, and queried with introductory SQL.
The US Oracle Store lists 1Z0-006 within a US$95 Foundations Exam Subscription that includes one exam attempt and a six-month subscription term. Confirm current pricing and regional availability on Oracle's site before purchasing.
No. Oracle Academy states that professional hands-on experience is not assumed. Its 90-hour course is preparation rather than a mandatory prerequisite.
No. Five of the six curriculum areas concern introduction, data modeling, refining the model, the Data Modeler tool, and physical mapping. Introduction to SQL is the final area.
Those details could not be verified from a current official Oracle source, so we do not state them. Check the official 1Z0-006 exam page at registration, and see our pass rate discussion for how to think about unverified figures.