Oracle Database 1z1-061

Not sure a study set is what you need? Download the free 1z1-061 demo from Getcertkey and review a sample of the Oracle Database 12c: SQL Fundamentals practice questions before you spend anything — the 2026 edition is ready to try today.

Oracle 1z1-061 Exam Overview:

Certification Vendor:	Oracle
Exam Name:	Oracle Database 12c: SQL Fundamentals
Exam Number:	1Z0-061
Real Exam Qty:	77
Exam Format:	Multiple Choice
Certificate Validity Period:	Oracle certifications do not generally expire; certification remains valid for the certified product version
Passing Score:	63%
Available Languages:	Japanese, English
Related Certifications:	Oracle Database 12c Administrator Certified Associate Oracle Database SQL Certified Associate
Exam Duration:	120 minutes
Exam Price:	USD 245
Sample Questions:
Exam Way:	Pearson VUE test center or Oracle-authorized online proctored delivery (availability depends on region and exam retirement status).
Pre Condition:	No prerequisite exam required. Basic understanding of databases and SQL recommended.
Official Syllabus URL:	https://education.oracle.com/oracle-database-sql/pexam_1Z0-071

Oracle 1z1-061 Exam Syllabus Topics:

1z1-061 Exam FAQs for 2026 Candidates

Which certification does the 1z1-061 exam lead to?

The 1z1-061 exam is the official Oracle exam behind the Oracle Database certification, validating the skills measured by the Oracle Database 12c: SQL Fundamentals credential. It sits at the Associate level of the Oracle certification program. It also connects to Oracle Database 12c Administrator Certified Associate, Oracle Database SQL Certified Associate, so the knowledge you build here carries over to those tracks as well.

How many questions are on the 1z1-061 exam, and how much time do I get?

The 1z1-061 exam contains 77 questions to be completed within 120 minutes. Before exam day, divide the available time by the question count to work out a comfortable per-question pace, and mark any item that eats into it so you can return later instead of getting stuck. Timed sessions in the Getcertkey test engines make that pacing automatic — run at least two full-length mock exams under the clock so time pressure never becomes the reason you drop points.

What score do I need to pass the 1z1-061 exam, and what does it cost?

The passing score for the 1z1-061 exam is 63%, and the official registration fee is USD 245. Retakes are not discounted — every new attempt means paying the full fee again — so it pays to measure yourself before you book. Work through the 340 practice questions on Getcertkey, sit a timed practice test, and schedule your exam only when your scores are consistently comfortable. That simple habit is the cheapest exam strategy there is.

Are there any prerequisites for the 1z1-061 exam?

No prerequisite exam required. Basic understanding of databases and SQL recommended. Requirements can change when Oracle revises its certification program, so confirm the current eligibility rules on the official exam page before you register.

Can I try the 1z1-061 practice questions before I buy?

Yes. Getcertkey provides a free 1z1-061 PDF demo so you can review the question style and answer quality before purchasing. Every purchase also includes 365 days of free updates — if Oracle revises the exam during that period, the updated material reaches you at no cost. Once the free-update year ends, you can extend your update service at a 50% discount.

What if I fail the 1z1-061 exam, and how is my order delivered?

Every Oracle Database 12c: SQL Fundamentals purchase on Getcertkey is covered by a 100% money-back guarantee with clear conditions: if you take the corresponding exam within 60 days of your purchase and do not pass, you can claim a full refund by submitting a scanned copy of your exam enrollment slip and your official score report as a PDF within two days of the exam date; claims are processed within seven days of submission. The guarantee does not apply to exams taken within three days of purchase, to material that was downloaded but never used in an exam attempt, or to free products and expired orders, and the candidate name must match the payer name. If you would rather not take a refund, you can instead exchange your purchase for two free exam preparation products of equal value and keep the update service on your original product.

Delivery is instant: your download is sent to your email within one minute of payment, with no limit on how many computers you may install the material on. If nothing arrives within two hours, check your spam folder and contact customer service for help.

What topics are covered in the 1z1-061 exam?

The Oracle Database 12c: SQL Fundamentals exam blueprint is organized into 11 domains. The first three are:

• Using Single-Row Functions
• Restricting and Sorting Data
• Managing Schema Objects

For the complete domain-by-domain breakdown, scroll up to the full exam topics outline above and use it to plan how you distribute your study time.

Oracle Database 12c: SQL Fundamentals Sample Questions:

Question #1
View the Exhibit and examine the structure of the SALES and PRODUCTS tables.

In the SALES table, PROD_ID is the foreign key referencing PROD_ID in the PRODUCTS table.
You want to list each product ID and the number of times it has been sold.
Evaluate the following query:
SQL>SELECT p.prod_id, COUNT(s.prod_id)
FROM products p _____________ sales s
ON p.prod_id = s.prod_id
GROUP BY p.prod_id;
Which two JOIN options can be used in the blank in the above query to get the required output? (Choose two.)

A. FULL OUTER JOIN
B. LEFT OUTER JOIN
C. JOIN
D. RIGHT OUTER JOIN

Question #2
Evaluate the following SQL statement:
SQL> SELECT cust_id, cust_last_name "Last Name"
FROM customers
WHERE country_id = 10
UNION
SELECT cust_id CUST_NO, cust_last_name
FROM customers
WHERE country_id = 30;
Which ORDER BY clause are valid for the above query? (Choose all that apply.)

A. ORDER BY 2, cust_id
B. ORDER BY "CUST_NO"
C. ORDER BY CUST_NO
D. ORDER BY "Last Name"
E. ORDER BY 2, 1

Question #3
Evaluate the following SQL statement:

Which statement is true regarding the above query if one of the values generated by the subquery is null?

A. It produces an error.
B. It generates output for null as well as the other values produced by the subquery.
C. It executes but returns no rows.
D. It ignores the null value and generates output for the other values produced by the subquery.

Question #4
Which three statements are true about multiple-row sub queries? (Choose three.)

A. They can contain group functions and the GROUP BY clause, but not the HAVING clause.
B. They cannot contain a subquery within a subquery.
C. They can contain a subquery within a sub query.
D. They can return multiple columns as well as rows.
E. They can contain group functions and GROUP BY and HAVING clauses.
F. They can return only one column but multiple rows.

Question #5
Which statements are true regarding the WHERE and HAVING clauses in a SELECT statement? (Choose two.)

A. The aggregate functions and columns used in the HAVING clause must be specified in the SELECT list of the query.
B. The WHERE clause can be used to exclude rows before dividing them into groups.
C. The WHERE clause can be used to exclude rows after dividing them into groups.
D. The HAVING clause can be used with aggregate functions in subqueries.
E. The WHERE and HAVING clauses can be used in the same statement only if they are applied to different columns in the table.

Solutions: