Oracle Database SQL Certified Associate (1Z0-071) (1Z0-071) Exam Blueprint

1Z0-071

73Questions
90 minDuration
63Passing Score
$245Price
6Languages
Practice Oracle Database SQL Certified Associate (1Z0-071) on QuizForge

Exam Domains

1 Relational Database Concepts 9%
2 Retrieving Data Using the SQL SELECT Statement 17%
3 Restricting and Sorting Data 11%
4 Using Single-Row Functions 9%
5 Using Conversion Functions and Conditional Expressions 9%
6 Reporting Aggregated Data Using Group Functions 8%
7 Displaying Data from Multiple Tables 10%
8 Using Subqueries 9%
9 Using SET Operators 5%
10 Managing Tables Using DML Statements 7%
11 Introduction to Data Definition Language 6%

Exam Details

Question TypesMultiple Choice, Multiple Select
FormatLinear
Online ProctoringAvailable
ID RequirementsOne valid government-issued photo ID with full name. Name must match Pearson VUE registration exactly.
RenewalNot required -- Oracle certifications are version-specific. When Oracle releases a new database/platform version, a new exam version is typically released. Previous certifications remain valid as earned.
Retake Policy14-day waiting period after failed attempt. Maximum 3 attempts per exam in a 12-month period. Full exam fee required for each retake.
LanguagesEnglish, Brazilian Portuguese, Simplified Chinese, Japanese, Korean, Spanish

Official Study Resources