ORACLE MASTER Silver SQL / 2019 / Oracle AI Database 26ai

ORACLE MASTER Silver SQL Practice Questions

While studying Silver SQL 2019 (1Z0-071-JPN) and Silver SQL Oracle AI Database 26ai (1Z0-171-JPN) on the same screen, you can manage history and mock exams separately for each exam. You can practice step-by-step from the basics of SELECT statements to joins/subqueries, DML, DDL, privileges, and data dictionaries.

Start studying

These are not reprints of official questions, but study questions that I created myself based on published exam content.

Choose learning mode

Random questions

Practice with anywhere from 5 questions to the full set of 552.

Exam/Field-Specific Study

2019 version/26ai version,12Narrow down your weaknesses by category, ★1 to ★3.

Mock exam by exam

2019 version 78 questions, 26ai version 60 questions. Judgment will be based on the passing criteria for each exam.
Questions included 552 questions
Last updated October 2, 2026
Loading question data…

Features of this ORACLE MASTER Silver SQL exam dumps

Reproduce 4-choice to 6-choice questions for each question

The number of choices is maintained for each question and displayed and scored without unnecessary empty choices.

Separate 2 exams by code

You can separate the imported questions by exam code and select only the 2019 version or 26ai version for regular study and mock exams.

Production specifications by test

The 2019 version has 78 questions and 63%, and the 26ai version has 60 questions and 65%, and both are determined in 120 minutes.

Learning history and reports

You can check the results by exam including the exam name, the achievement level by field, and the most recent learning, and output it to an image or CSV.

Available study modes

  1. normal learning: Practice by specifying the exam code, set, question area, difficulty level, and number of questions.
  2. Today's review: Questions that have been scheduled for review will be posted.
  3. Overcoming weaknesses: Repeat and study only the questions you got wrong in the past.
  4. mock exam: Select the 2019 version/26ai version and challenge the number of questions and passing criteria for each exam.

How to use

  1. 1
    Choose learning mode

    Choose from regular study, review, overcoming weaknesses, and mock exams.

  2. 2
    Set the exam and scope

    Specify the exam code, problem set, SQL field, difficulty level, and number of questions.

  3. 3
    Review with explanation and history

    After grading, check the explanation and decide the next review range based on the correct answer rate for each field.

ORACLE MASTER Silver SQL exam settings (contents included on this site)

Subjects the main domains in the official exam scope
Questions 552 questions
Question format Original multiple-choice practice questions
Study modes Normal study / Today’s review / Weak-area practice / Mock exam
Question sets 1 sets
Official website Check the latest information on 2 exams on Oracle's official certification exam list

Both exams cover SELECTs, functions, joins, subqueries, set operators, DML, DDL, objects, privileges, data dictionaries, and more. As of September 5, 2026, 1Z0-071-JPN has 78 questions, but Oracle has announced that it will be changed to 63 questions from early December 2026. Please check the latest information on the official website before applying.

Question policy and updates

  • We created our own test for learning purposes based on the exam information and product documentation for Silver SQL 2019 and Oracle AI Database 26ai published by Oracle.
  • This is not a question collection that is a reprint of official questions, actual exam questions, or so-called dumps.
  • We will explain not only the correct answer, but also the reason for the incorrect answer and the SQL evaluation order, data type, and handling of NULL.
  • We check for changes in Oracle Database specifications and revisions to the test scope, and review the content from time to time.

Questions included: 552 questions · Last question update: October 2, 2026

Frequently asked questions

Can I solve ORACLE MASTER Silver SQL problems for free?

552 questionsYou can practice everything for free. There is no need to register as a member, and you can use the 2019 version or 26ai version, regular study by specifying the question area and difficulty level, today's review, overcoming weaknesses, and mock exams.

Is it an official past question?

No. These are original mock questions created for learning purposes based on exam information published by Oracle. This is not a reprint of actual exam questions or official questions.

What is the exam time, number of questions, and passing line for the 2019 and 26ai versions?

According to Oracle official information as of September 5, 2026, Silver SQL 2019 (1Z0-071-JPN) is 78 questions, 120 minutes, 63%, and Silver SQL Oracle AI Database 26ai (1Z0-171-JPN) is 60 questions, 120 minutes, 65%. Please check the latest information on the official page before applying.

Is it possible to change the number of questions on 1Z0-071-JPN?

Currently it is set to 78 questions. Oracle has announced that it will change to 63 questions from early December 2026, so please check the official information and update your plugin settings once the change takes effect.

Are the questions and grades of the 2019 and 26ai versions mixed?

Separate by registering the test code in the "range" of CSV. In regular study, you can select the exam code, and the mock exam uses only the questions of the exam you selected. The exam name is also saved in the exam results.

Does it support 4-choice, 5-choice, and 6-choice questions?

Yes. You can set a 4-choice, 5-choice, or 6-choice format for each question, and the same number of choices is maintained for the study screen, scoring, CSV input/output, and problem report.

What areas can I study?

SELECT statements, single row functions/group functions, joins, subqueries, set operators, DML, DDL, indexes/synonyms/sequences, privileges, data dictionaries, time zones, etc. can be registered by field.

Where is my learning history saved?

It will be saved in the browser you are using (LocalStorage). It will not be automatically synced to another device, and if you delete your browser data, your history will also be deleted.

Disclaimer

This tool is not affiliated with Oracle Corporation, Oracle University, or any testing organization. We do not guarantee the accuracy or comprehensiveness of questions, options, and explanations, nor do we guarantee that you will pass the actual exam. Please be sure to check the Oracle official website for the latest information on exam fees, exam dates, question ranges, and exam formats.

This site is an unofficial collection of exam preparation questions. Oracle and Java are registered trademarks of Oracle Corporation and its subsidiaries and affiliates.