Why Study with PlanetCert?
The Latest Questions
Practice questions and exam topics aligned with the current exam objectives.
Detailed Explanations
Go beyond the answer. Master the material with comprehensive learning and professional explanations for every concept.
AI-Powered Insights
Personalized preparation guidance that adapts to your performance and identifies weak spots automatically.
Exam Information
Official specifications published by Oracle
Exam Format
120 min
63
63%
Associate
Registration
$245 USD
Pearson VUE, Oracle Testing Center, or online proctoring
Validity
Does not expire
Certification does not require renewal; Consider advancing to Oracle Database SQL Expert or DBA certifications
1Z0-071 Exam Topics and Domains
1Z0-071 is organized into 16 weighted domains. Expect to work with Oracle SQL, Oracle Data Modeler, Oracle Database, Oracle SQL 12c+, and more.
1
Relational Database Concepts
8%
Database Fundamentals
Theoretical and Physical Aspects of Relational DatabasesSQL and Database RelationshipEntity Relationship Diagrams (ERD)
- Explain the theoretical and physical aspects of a relational database
- Relate clauses in SQL Select Statement to Components of an ERD
- Explain the relationship between a database and SQL
2
Retrieving Data Using SQL SELECT Statement
10%
Basic SELECT Statement Components
Column AliasesSELECT Statement SyntaxString OperationsArithmetic Expressions and NULL Values
- Use Column aliases
- Use The SQL SELECT statement
- Use concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword
- Use Arithmetic expressions and NULL values in the SELECT statement
3
Restricting and Sorting Data
8%
Filtering and Ordering Results
WHERE Clause and OperatorsSubstitution VariablesSorting DataRow Limiting Clauses
- Apply Rules of precedence for operators in an expression
- Limit Rows Returned in a SQL Statement
- Use Substitution Variables
- Use the DEFINE and VERIFY commands
- Sort Data
4
Using Single-Row Functions
12%
Character Functions
String Manipulation Functions
Manipulate strings with character functions in SQL SELECT and WHERE clauses
Numeric Functions
Mathematical Functions
Manipulate numbers with the ROUND, TRUNC and MOD functions
Date Functions
Date Manipulation
- Perform arithmetic with date data
- Manipulate dates with the date function
5
Using Conversion Functions and Conditional Expressions
10%
Data Type Conversion
Implicit and Explicit ConversionConversion Functions
- Understand implicit and explicit data type conversion
- Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
Conditional Functions
NULL Handling FunctionsNested Functions
- Apply the NVL, NULLIF, and COALESCE functions to data
- Nest multiple functions
6
Reporting Aggregated Data Using Group Functions
8%
Aggregate Functions
Group FunctionsGROUP BY ClauseHAVING Clause
- Use Group Functions
- Create Groups of Data
- Restrict Group Results
7
Displaying Data from Multiple Tables
14%
Join Operations
Inner JoinsOuter JoinsSelf-JoinsNon-Equijoins and Cross Joins
- Use Various Types of Joins
- Use Self-joins
- Use Non equijoins
- Use OUTER joins
- Understand and Use Cartesian Products
8
Using Subqueries
8%
Subquery Types
Single-Row SubqueriesMultiple-Row SubqueriesCorrelated Subqueries
- Use Single Row Subqueries
- Use Multiple Row Subqueries
- Update and delete rows using correlated subqueries
9
Using SET Operators
6%
Set Operations
UNION and UNION ALLINTERSECT and MINUSSet Operator Guidelines
- Use The UNION and UNION ALL operators
- Use The INTERSECT operator
- Use The MINUS operator
- Match the SELECT statements
- Use the ORDER BY clause in set operations
10
Managing Tables Using DML Statements
8%
Data Manipulation
INSERT StatementUPDATE StatementDELETE StatementMERGE Statement
- Perform Insert, Update and Delete operations
- Perform multi table Inserts
- Perform Merge statements
Transaction Control
Transaction Management
- Manage Database Transactions
- Control transactions
11
Managing Indexes, Synonyms, and Sequences
4%
Database Objects
IndexesSequencesSynonyms
- Manage Indexes
- Manage Sequences
- Manage Synonyms
12
Using DDL to Manage Tables and Relationships
10%
Table Management
Creating TablesModifying TablesTemporary and External TablesTable Removal
- Describe and Work with Tables
- Describe and Work with Columns and Data Types
- Create tables
- Drop columns and set column UNUSED
- Truncate tables
- Create and use Temporary Tables
- Create and use external tables
Constraints
Constraint Types
Manage Constraints
13
Managing Views
4%
Views
View Management
Manage Views
14
Controlling User Access
4%
Privileges and Roles
System PrivilegesRolesObject Privileges on Tables
- Differentiate system privileges from object privileges
- Grant privileges on tables
- Distinguish between granting privileges and roles
15
Managing Objects with Data Dictionary Views
2%
Data Dictionary
Data Dictionary Views
Use data dictionary views
16
Managing Data in Different Time Zones
4%
Time Zone Management
Time Zone FunctionsInterval Data Types
- Work with CURRENT_DATE, CURRENT_TIMESTAMP, and LOCALTIMESTAMP
- Work with INTERVAL data types
How do I earn this certification?
Passing 1Z0-071 earns the Oracle Database SQL Certified Associate certification. It sits in the Database track.
Next Level Options
- 1Z0-082 - Oracle Database Administration I
- 1Z0-083 - Oracle Database Administration II
- 1Z0-144 - Oracle Database 11g: Program with PL/SQL
- 1Z0-149 - Oracle Database Program with PL/SQL
Alternative Paths
- 1Z0-900 - Java EE 7 Application DeveloperApplication developers working with Oracle databases
- 1Z0-1085-24 - Oracle Cloud Infrastructure 2024 Foundations Associate Cloud database administrators and architects
Practice with Precision
The PlanetCert Simulator mirrors the real exam environment with authentic questions and timed pressure.
How to study for this exam?
The most effective way to prepare for 1Z0-071 is by using the PlanetCert Simulator to practice questions and review detailed explanations.
What's changed on this exam?
Current Status
- ACTIVE
- Last content update: 2025
Updates
- Oracle Database 19c 19c Long-term support release, fully covered in 1Z0-071 • Release date: 2019
- Oracle Live SQL Current Free hands-on practice environment for exam preparation • Release date: Ongoing
Who should take this exam?
This exam is typically taken by Database administrators and Database developers.
- Basic understanding of relational database concepts
- Familiarity with command-line interfaces
- Experience working with databases (recommended but not mandatory)