Free Oracle 1Z0-071 Exam Questions

Become Oracle Certified with updated 1Z0-071 exam questions and correct answers

Page: 1 / 113

Total 561 Questions | Updated On: Jan 28, 2026

Add To Cart

Question 1

Examine this SQL statement:

Which two are true?

A : The subquery is executed before the UPDATE statement is executed.

B : All existing rows in the ORDERS table are updated.

C : The subquery is executed for every updated row in the ORDERS table.

D : The UPDATE statement executes successfully even if the subquery selects multiple rows.

E : The subquery is not a correlated subquery.

Answer: A,C

Question 2

Examine the structure of the MEMBERS table:

Examine the SQL statement: SQL > SELECT city, last_name LNAME FROM MEMBERS ORDER BY 1, LNAME DESC; What would be the result execution? (Choose the best answer.)

A : It displays all cities in descending order, within which the last names are further sorted in descending order.

B : It fails because a column alias cannot be used in the ORDER BY clause.

C : It fails because a column number and a column alias cannot be used together in the ORDER BY clause.

D : It displays all cities in ascending order, within which the last names are further sorted in descending order.

Answer: D

Question 3

Which two are true about transactions In the Oracle Database?

A : DDL statements automatically commit only data dictionary updates caused by executing the DDL.

B : A DDL statement issued by a session with an uncommitted transation automaticall commits that transaction.

C : An uncommitted transaction is automatically committed when the user exits SQL*PLUS

D : DML statements always start new transactions.

E : A session can see uncommitted updates made by the same user in a different session

Answer: B,D

Question 4

Which three statements are true regarding subqueries? (Choose three.)

A : The ORDER BY Clause can be used in a subquery.

B : A subquery can be used in the FROM clause of a SELECT statement.

C : If a subquery returns NULL, the main query may still return rows.

D : A subquery can be placed in a WHERE clause, a GROUP BY clause, or a HAVING clause.

E : Logical operators, such as AND, OR and NOT, cannot be used in the WHERE clause of a subquery.

Answer: A,B,C

Question 5

Examine the structure of the MEMBERS table:

You want to display details of all members who reside in states starting with the letter A followed by

exactly one character.

Which SQL statement must you execute?

A : SELECT * FROM MEMBERS WHERE state LIKE '%A_';

B : SELECT * FROM MEMBERS WHERE state LIKE 'A_';

C : SELECT * FROM MEMBERS WHERE state LIKE 'A_%';

D : SELECT * FROM MEMBERS WHERE state LIKE 'A%';

Answer: B

Page: 1 / 113

Total 561 Questions | Updated On: Jan 28, 2026

Add To Cart