Oracle Database 12c SQL Fundamentals

Here you have the best Oracle 1z0-061 practice exam questions

You have 339 total questions to study from
Each page has 5 questions, making a total of 68 pages
You can navigate through the pages using the buttons at the bottom
This questions were last updated on October 25, 2025
This site is not affiliated with or endorsed by Oracle.

Question 1 of 339

Evaluate the following SQL statement:
Exam 1z0-061: Question 1 - Image 1

Which statement is true regarding the outcome of the above query?

It executes successfully and displays rows in the descending order of PROMO_CATEGORY.

It produces an error because positional notation cannot be used in the order by clause with set operators.

It executes successfully but ignores the order by clause because it is not located at the end of the compound statement.

It produces an error because the order by clause should appear only at the end of a compound query-that is, with the last select statement.

Correct Answer: D

The SQL query will produce an error because the ORDER BY clause should appear only at the end of a compound query, that is, with the last SELECT statement. In a UNION operation, the combined result set can be ordered only once, and the ORDER BY clause should be applied after the final SELECT statement to sort the entire result set.

Question 2 of 339

View the Exhibit and examine the structure of the product, component, and PDT_COMP tables.
In product table, PDTNO is the primary key.
In component table, COMPNO is the primary key.
In PDT_COMP table, <PDTNO, COMPNO) is the primary key, PDTNO is the foreign key referencing PDTNO in product table and COMPNO is the foreign key referencing the COMPNO in component table.
You want to generate a report listing the product names and their corresponding component names, if the component names and product names exist.
Evaluate the following query:
SQL>SELECT pdtno, pdtname, compno, compname
FROM product _____________ pdt_comp
USING (pdtno) ____________ component USING (compno)
WHERE compname IS NOT NULL;
Which combination of joins used in the blanks in the above query gives the correct output?
Exam 1z0-061: Question 2 - Image 1

JOIN; JOIN

FULL OUTER JOIN; FULL OUTER JOIN

RIGHT OUTER JOIN; LEFT OUTER JOIN

LEFT OUTER JOIN; RIGHT OUTER JOIN

Correct Answer: A

To generate a report listing the product names and their corresponding component names where both names exist, inner joins are suitable. Inner joins ensure that only rows with matching keys in both tables are selected, which aligns with the requirement that both product and component names must exist.

Question 3 of 339

View the Exhibit for the structure of the student and faculty tables.
Exam 1z0-061: Question 3 - Image 1

You need to display the faculty name followed by the number of students handled by the faculty at the base location.
Examine the following two SQL statements:
Exam 1z0-061: Question 3 - Image 2

Which statement is true regarding the outcome?

Only statement 1 executes successfully and gives the required result.

Only statement 2 executes successfully and gives the required result.

Both statements 1 and 2 execute successfully and give different results.

Both statements 1 and 2 execute successfully and give the same required result.

Correct Answer: D

Question 4 of 339

View the Exhibits and examine products and sales tables.
Exam 1z0-061: Question 4 - Image 1

You issue the following query to display product name and the number of times the product has been sold:
Exam 1z0-061: Question 4 - Image 3

What happens when the above statement is executed?

The statement executes successfully and produces the required output.

The statement produces an error because item_cnt cannot be displayed in the outer query.

The statement produces an error because a subquery in the from clause and outer-joins cannot be used together.

The statement produces an error because the group by clause cannot be used in a subquery in the from clause.

Correct Answer: A

Question 5 of 339

You want to create a table employees in which the values of columns EMPLOYEES_ID and LOGIN_ID must be unique and not null. Which two SQL statements would create the required table?
Exam 1z0-061: Question 5 - Image 1

Option A

Option B

Option C

Option D

Option E

Option F

Correct Answer: A, E

To create the required table where both EMPLOYEE_ID and LOGIN_ID are unique and not null, we need to ensure that these columns are explicitly set as UNIQUE and NOT NULL. Option A specifies a PRIMARY KEY on the combination of EMPLOYEE_ID and LOGIN_ID, which inherently means these columns will be unique and cannot be null. Option E declares the EMPLOYEE_ID and LOGIN_ID columns with NOT NULL constraints separately and also creates a UNIQUE constraint on them. These two options ensure the constraints required for the table are properly enforced.