Oracle
Exam Blueprint
1Z0-171
Oracle AI Database SQL AssociateExam Objectives
Master all 5 exam domains for the 1Z0-171 certification. Understanding the exam objectives and their weightings is crucial for focused, efficient preparation.
Exam Overview
Total Domains5
Difficulty
ASSOCIATE
Questions60
Passing Score63%
Exam Domains
All Exam Objectives
5 domains covering 100% of the exam
1
Relational Database Concepts and SQL Fundamentals
25% of exam25%
~15 questions
2
Retrieving Data Using SELECT Statements
30% of exam30%
~18 questions
3
Data Manipulation and Transaction Control
20% of exam20%
~12 questions
4
SQL Functions and Data Processing
15% of exam15%
~9 questions
5
Schema Objects and Advanced SQL Techniques
10% of exam10%
~6 questions
Strategy
Study Strategy by Domain Weight
Prioritize your study time based on exam weightings
Highest Priority
Retrieving Data Using SELECT Statements
30%
Allocate approximately 24 hours of study time
Relational Database Concepts and SQL Fundamentals
25%
Allocate approximately 20 hours of study time
Data Manipulation and Transaction Control
20%
Allocate approximately 16 hours of study time
SQL Functions and Data Processing
15%
Allocate approximately 12 hours of study time
Schema Objects and Advanced SQL Techniques
10%
Allocate approximately 8 hours of study time