As per the Oracle database SQL 1Z0-071 study guide, the key topics covered in this exam such as:

Fundamentals of Relational Databases
Data Retrieval with SQL SELECT Statements
Data Limitation and Arrangement
Customizing Output with Single-Row Functions
Utilizing Conversion Functions and Conditional Logic
Aggregate Data Reporting with Group Functions
Integrating Data from Multiple Tables
Query Resolution using Subqueries
Application of SET Operations
Table Management through DML Operations
Supervising Sequences, Synonyms, and Indexes
DDL Application for Table and Relationship Oversight
Administration of Database Views
Regulating User Permissions and Access
Handling Database Elements via Data Dictionary Insights
Data Management Across Various Time Zones