Free Oracle 1z1-071 Practice Test & Real Exam Questions

Exam Code/Number: 1z1-071
Exam Name/Title: Oracle Database SQL
Certification Provider: Oracle
Corresponding Certification: Oracle PL/SQL Developer Certified Associate

Exam Questions: 437
Updated On: Sep 12, 2026

Question #1

View the Exhibit and examine the structure of ORDERS and CUSTOMERS tables. (Choose the best answer.)

You executed this UPDATE statement:

Which statement is true regarding the execution?

A. It would not execute because two tables cannot be referenced in a single UPDATE statement.

B. It would execute and restrict modifications to the columns specified in the SELECT statement.

C. It would not execute because a subquery cannot be used in the WHERE clause of an UPDATE statement.

D. It would not execute because a SELECT statement cannot be used in place of a table name.

Discussion 0

Correct Answer: B Vote an answer

Question #2

View the Exhibits and examine the structure of the COSTSand PROMOTIONStables.
You want to display PROD_IDSwhose promotion cost is less than the highest cost PROD_IDin a promotion time interval.
Examine this SQL statements:

What will be the result?
Exhibit 1.

Exhibit 2.

A. It executes successfully but does not give the required result

B. It gives an error because the GROUP BY clause is not valid

C. It gives an error because the ALL keyword is not valid

D. It executes successfully and gives the required result

Discussion 0

Correct Answer: D Vote an answer

Question #3

The BOOKS_TRANSACTIONS table exists in your database. Examine the SQL statement:
SQL>SELECT * FROM books_transactions ORDER BY 3;
What is the outcome on execution?

A. The execution tails unless the numeral 3 in the order by clause is replaced by a column name,

B. Rows are displayed sorted in ascending order of the values in the third column in the table.

C. Rows are displayed in the order that they are stored in the table only for the three rows with the lowest values in the key column.

D. Rows are displayed in the order that they are stored in the table only for the first three rows.

Discussion 0

Correct Answer: B Vote an answer

Question #4

Examine the structure of the EMPLOYEES table.

You must display the maximum and minimum salaries of employees hired 1 year ago.
Which two statements would provide the correct output? (Choose two.)

A. SELECT minsal, maxsal
FROM (SELECT MIN(salary) minsal, MAX(salary) maxsal
FROM employees
WHERE hire_date < SYSDATE-365)
GROUP BY maxsal, minsal;

B. SELECT MIN(Salary) minsal, MAX(salary) maxsal
FROM employees
WHERE hire_date < SYSDATE-365
GROUP BY MIN(salary), MAX(salary);

C. SELECT MIN(Salary), MAX(salary)
FROM (SELECT salary FROM
employees
WHERE hire_date < SYSDATE-365);

D. SELECT minsal, maxsal
FROM (SELECT MIN(salary) minsal, MAX(salary) maxsal
FROM employees
WHERE hire_date < SYSDATE-365
GROUP BY MIN(salary), MAX(salary));

Discussion 0

Correct Answer: A,C Vote an answer

Question #5

Which two statements are true regarding roles? (Choose two.)

A. The REVOKE command can be used to remove privileges but not roles from other users.

B. A role can be granted to PUBLIC.

C. A user can be granted only one role at any point of time.

D. Roles are named groups of related privileges that can be granted to users or other roles.

E. A role can be granted to itself.

Discussion 0

Correct Answer: B,D Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #6

Examine the description of the EMPLOYEEStable:

Examine this query:

Which line produces an error?

A. Line 5

B. Line 8

C. Line 7

D. Line 3

Discussion 0

Correct Answer: D Vote an answer

Question #7

Examine the description of the ORDERStable:

Examine the description of the INVOICEStable:

Which three statements execute successfully? (Choose three.)

Discussion 0

Correct Answer: B,D,F Vote an answer

Question #8

View the Exhibit and examine the details of the PRODUCT_INFORMATION table.

You have the requirement to display PRODUCT_NAME and LIST_PRICE from the table where the CATEGORYJD column has values 12 or 13, and the SUPPLIER_ID column has the value
102088. You executed the following SQL statement:
SELECT product_name, list_price
FROM product_information
WHERE (category_id = 12 AND category_id = 13)
AND supplier_id = 102088;
Which statement is true regarding the execution of the query?

A. It would not execute because the entire WHERE clause condition is not enclosed within the parentheses.

B. It would execute and the output would display the desired result.

C. It would execute but the output would return no rows.

D. It would not execute because the same column has been used in both sides of the AND logical operator to form the condition.

Discussion 0

Correct Answer: C Vote an answer

Question #9

Which two actions can you perform with object privileges? (Choose two.)

A. Execute a procedure or function in another schema.

B. Create FOREIGN KEY constraints that reference tables in other schemas.

C. Set default and temporary tablespaces for a user.

D. Delete rows from tables in any schema except SYS.

E. Create roles.

Discussion 0

Correct Answer: A,E Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Download Free Oracle 1z1-071 Demo

Simply submit your e-mail address below to get started with our free demo of your Oracle 1z1-071 exam.