Stepwise-Lab

Exam guide

Exam 1Z0-071: Oracle Database SQL

Everything about exam 1Z0-071: what it checks, how it is run, what it covers section by section, and how to prepare for it on a real Oracle Database 19c.

63

Questions

120 minutes

Time

63%

Pass mark

Oracle Database 19c

Database version

This is the format our mock exams follow. Check the current format and price with the exam provider before you book.

About the exam

Exam 1Z0-071 checks that you can write and read SQL the way Oracle Database 19c runs it: queries over several tables, single-row and group functions, subqueries and set operators, changing data in transactions, and creating and managing tables, constraints, views, indexes, sequences and user access.

The questions are multiple choice: some have one right answer, others ask you to pick two or three. Many show a statement and ask what it returns, which error it raises, or which statements give the same result, so knowing the rules is not enough: you need to have run the SQL yourself.

What the exam covers

The exam objectives, in 16 sections. Each question on the exam belongs to one of them.

  1. 1Relational Database concepts
  2. 2Retrieving Data using the SQL SELECT Statement
  3. 3Restricting and Sorting Data
  4. 4Using Single-Row Functions to Customize Output
  5. 5Using Conversion Functions and Conditional Expressions
  6. 6Reporting Aggregated Data Using Group Functions
  7. 7Displaying Data from Multiple Tables
  8. 8Using Subqueries to Solve Queries
  9. 9Using SET Operators
  10. 10Managing Tables using DML statements
  11. 11Managing Indexes Synonyms and Sequences
  12. 12Use DDL to manage tables and their relationships
  13. 13Managing Views
  14. 14Controlling User Access
  15. 15Managing Objects with Data Dictionary Views
  16. 16Managing Data in Different Time Zones

Practise by topic

The same material in 14 topics, each with its own page: what it covers and practice questions with answers.

How the app prepares you for 1Z0-071

Each part opens in the app. Start without an account; the progress you make stays with you when you create one.

How to prepare

Practise a little every day, write the SQL yourself instead of only reading it, and take full mock exams on questions you have not seen. Book the exam once your estimated score is above the pass mark in several of them.