100% Free 1Z0-071 Practice Exam Questions (2026)

Stay Ahead with Updated Oracle Database 12c SQL 1Z0-071 Practice Tests & Verified Answers

Oracle 1Z0-071 Dumps & Practice Test Questions 2026

Page: 1 / 113

Total 561 Questions | Updated On: Aug 02, 2026

Add To Cart

Question 1

Which two statements are true about a full outer join?

A : It includes rows that are returned by an inner join

B : It returns only unmatched rows from both tables being joined.

C : It includes rows that are returned by a Cartesian product.

D : It returns matched and unmatched rows from both tables being joined

E : The Oracle join operator (+) must be used on both sides of the join condition in the WHERE clause.

Answer: A,D

Question 2

The PRODUCTS table has the following structure.

Evaluate the following two SQL statements:

SQL>SELECT prod_id, NVL2 (prod_expiry_date, prod_expiry_date + 15, ‘ ‘) FROM products;

SQL>SELECT prod_id, NVL (prod_expiry_date, prod_expiry_date + 15) FROM products;

Which statement is true regarding the outcome?

A : Both the statements execute and give different results

B : Only the second SQL statement executes successfully

C : Both the statements execute and give the same result

D : Only the first SQL statement executes successfully

Answer: A

Question 3

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

A : Multiple columns or expressions can be compared between the main query and subquery.

B : Subqueries can contain ORDER BY but not the GROUP BY clause.

C : Main query and subquery can get data from different tables.

D : Subqueries can contain GROUP BY and ORDER BY clauses.

E : Main query and subquery must get data from the same tables.

F : Only one column or expression can be compared between the main query and subquery.

Answer: A,C,D

Question 4

View the exhibit and examine the description of SALES and PROMOTIONS tables.

You want to delete rows from the SALES table, where the PROMO_NAME column in the

PROMOTIONS table has either blowout sale or everyday low price as values.

Which three DELETE statements are valid? (Choose three.)

A : DELETEFROM salesWHERE promo_id = (SELECT promo_idFROM promo_name = ‘blowout sale’)AND promo_id = (SELECT promo_idFROM promotionsWHERE promo_name = ‘everyday low price’)FROM promotionsWHERE promo_name = ‘everyday low price’);

B : DELETEFROM salesWHERE promo_id = (SELECT promo_idFROM promotionsWHERE promo_name = ‘blowout sale’)OR promo_id = (SELECT promo_idFROM promotionsWHERE promo_name = ‘everyday low price’)

C : DELETEFROM salesWHERE promo_id = (SELECT promo_idFROM promotionsWHERE promo_name = ‘blowout sale’)OR promo_name = ‘everyday low price’);

D : DELETEFROM salesWHERE promo_id IN (SELECT promo_idFROM promotionsWHERE promo_name IN = ‘blowout sale’,‘everyday low price’));

Answer: B,C,D

Question 5

Examine these statements and results

SQL> SELECT COUNT(*) FROM emp

COUNT(*)

---------------------

sQL> CREATE GLOBAL TEMPORARY TABLE t emp As SELECT * FROM emp;

Table created

SQL> INSERT INTo temp SELECT * FROM emp;

14 rows created

SQL> COMMIT:

Commit complete*

SQL> INSERT INTo temp SELECT * EROM emp;

14. rows created

SQL> SELECT COUNT(*) FROM t emp

How many rows are retrieved by the last query?

A : 28

B : 0

C : 14

D : 42

Answer: C

Page: 1 / 113

Total 561 Questions | Updated On: Aug 02, 2026

Add To Cart