Oracle credentialCER0449Active

Oracle Database SQL Certified Associate

Exam code: 1Z0-071Oracle Database SQLOracle Database
Official provider page
Oracle
Credential
Certification
Exam duration
120 min

credential overview

About this credential

Demonstrates understanding of fundamental SQL concepts needed for database projects and fluency using SQL with Oracle Database, including queries, DML, DDL, DCL, optimizer concepts, tables and indexes, data modeling, and normalization.

Assessment

Exam details

1Z0-071

Oracle Database SQL Certified Associate

Required exam
Duration
120 min
Format
Proctored exam
Delivery
Oracle University
Passing score
63%
Proctored
Yes
View exam details

Exam blueprint

Skills measured

Skills measured16 topics
  • Relational Database concepts
  • Retrieving Data using the SQL SELECT Statement
  • Restricting and Sorting Data
  • Using Single-Row Functions to Customize Output
  • Using Conversion Functions and Conditional Expressions
  • Reporting Aggregated Data Using Group Functions
  • Displaying Data from Multiple Tables
  • Using Subqueries to Solve Queries
  • Using SET Operators
  • Managing Tables using DML statements
  • Managing Indexes Synonyms and Sequences
  • Use DDL to manage tables and their relationships
  • Managing Views
  • Controlling User Access
  • Managing Objects with Data Dictionary Views
  • Managing Data in Different Time Zones

Before you certify

Requirements and recommended experience

Recommended experience

Knowledge of general computing concepts.

Recommended experience

Knowledge of command line interfaces.

Recommended experience

Experience working in command line.

Recommended experience

A combination of Oracle training and hands-on experience attained via labs and/or field experience provides the best preparation for passing the exam.

Preparation

Official learning resources

Training course

Earn the Oracle Database SQL Certified Associate Credential

Credential lifecycle

Status, validity and renewal

Credential lifecycle

Corporate certification enablement

Turn this pathway into a team capability plan

We can align the learning path, instructor support, practice environment and delivery schedule to your team’s roles and certification target.