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

ORACLE MASTER Silver SQL 過去questions552 questions Silver SQL 26ai 練習problem・mock exam

Silver SQL 26aiの対象problemに絞って、normal learningからmock examまで一続きで学習できます。

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

All240 questionsから5 questions〜Allquestionsを選んで演習します。

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 240 questions
Last updated October 2, 2026
Loading question data…

Silver SQL 26aiの学習ポイント

このページではORACLE MASTER Silver SQL 過去questions552 questionsのうち「Silver SQL 26ai」に対応する登録problemを対象に学習できます。まずnormal learningでrangeごとの理解を確認し、間違えたproblemはExplanationとLearning historyを使って復習してください。知識が安定したらmock examで複数分野を続けて解き、時間配分と総合的な正答率を確認します。

Silver SQL 26aiで確認したいこと

用語を暗記するだけでなく、problem文の条件から必要な知識を選び、選択肢の違いを説明できる状態を目指します。誤答した論点はExplanationを確認し、関連problemを続けて解いて定着させます。

おすすめの進め方

normal learningで対象rangeを一通り解いた後、Today's reviewやOvercoming weaknessesで誤答を優先して解き直します。最後にmock examを利用し、本番を意識したペースでも正答できるか確認してください。

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)

Silver SQL 26ai 1Z0-171-JPN・60 questions・120Minute/passing line65%
Silver SQL 2019 1Z0-071-JPN・78 questions・120Minute/passing line63%
Number of questions included 240 questions (Free; no registration required)
Question format Multiple-choice questions (4-choice, 5-choice, 6-choice for each question on this site)
Recording field Retrieving, restricting, and sorting data using SQL SELECT statements, Using set operators, Controlling user access, Single-Row Functions, Data Manipulation with DML, Conversion Functions and Conditional Expressions, Subqueries, Joins and Multi-Table Queries, Group Functions and Aggregation, Data Dictionary and Time Zones, Overview of data definition language, Sequences, Synonyms, and Indexes
Learning history Signed out or sync OFF: stored on device / sync ON: cloud sync
problem set 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: 240 questions · Last question update: October 2, 2026

Frequently asked questions

Can I solve ORACLE MASTER Silver SQL problems for free?

240 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.