Oracle credentialCER0455Active

Oracle AI Database SQL Certified Associate

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

credential overview

About this credential

Validates fundamental SQL knowledge for interacting with Oracle Database tables and objects, including queries, DML, DDL, DCL, joins, subqueries, functions, database objects, ER models, and table manipulation.

Assessment

Exam details

1Z0-171

Oracle AI Database SQL Certified Associate

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

Exam blueprint

Skills measured

Skills measured11 topics
  • Relational Database Concepts5%
  • Retrieving Data using the SQL SELECT Statement and Restricting and Sorting Data15%
  • Using Functions25%
  • Displaying Data from Multiple Tables10%
  • Using Subqueries to Solve Queries5%
  • Using SET Operators5%
  • Managing Tables using DML statements5%
  • Managing Indexes Synonyms and Sequences5%
  • Use DDL to manage tables and their relationships15%
  • Controlling User Access5%
  • Managing Objects with Data Dictionary Views and Data in Different Time Zones5%

Before you certify

Requirements and recommended experience

Recommended experience

Knowledge of general computing concepts.

Recommended experience

Knowledge of command line interfaces and 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 AI Database SQL 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.