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: Mar 12, 2026

Add To Cart

Question 1

Examine the data in the INVOICES table:

Examine the data in the CURRENCIES table:

CURRENCY_CODE

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

JPY

GPB

CAD

EUR

USD

Which query returns the currencies in CURRENCIES that are not present in INVOICES?

A : SELECT currency_ code FROM currenciesMINUSSELECT currency_ code FROM invoices;

B : SELECT * FROM currenciesWHERE NOT EXISTS (SELECT NULL FROM invoices WHERE currency_ code = currency_ code);

C : SELECT currency_ code FROM currenciesINTERSECTSELECT currency_ code FROM invoices;

D : SELECT * FROM currenciesMINUSSELECT * FROM invoices;

Answer: A

Question 2

Which three statements are true about views in an Oracle database?

A : A SELECT statement cannot contain a where clause when querying a view containing a WHERE clause in its defining query

B : Rows inserted into a table using a view are retained in the table if the view is dropped

C : Views can join tables only if they belong to the same schema.

D : Views have no segment.

E : Views have no object number.

F : A view can be created that refers to a non-existent table in its defining query.

G : Inserting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error.

Answer: B,D,F,G

Question 3

Which statement is true regarding the UNION operator?

A : By default, the output is not sorted.

B : Null values are not ignored during duplicate checking.

C : Names of all columns must be identical across all select statements.

D : The number of columns selected in all select statements need not be the same.

Answer: B

Question 4

Examine the description of EMPLOYEES table:

Which three queries return all rows for which SALARY+COMMISSION is greate than 20000?

A : SELECT * FROM employees WHERE salary+NULLF(commission,0)>=20000;

B : SELECT * FROM employees WHERE salary+NVL2(commission,commission,0)>=20000;

C : SELECT * FROM employees WHERE NVL2(salary)+commission,salary+commission,

D : SELECT * FROM employees WHERE salary+NVL(commission,0)>=20000;

E : SELECT * FROM employees WHERE NVL(salary+commission,0)>=20000;

F : SELECT * FROM employees WHERE NVL(salary+commission,0)>==20000;

Answer: A,B,D

Question 5

Examine the description of the CUSTOMERS table:

Which three statements will do an implicit conversion?

A : SELECT * FROM customers WHERE TO_ CHAR (customer_ id) = '0001';

B : SELECT * FROM customers WHERE customer id = '0001';

C : SELECT * FROM customers WHERE customer_ id = 0001;

D : SELECT FROM customers WHERE insert date = '01-JAN-19';

E : SELECT. FROM customers WHERE insert_ date = DATE *2019-01-01';

F : SELECT. FRON customers WE TO DATE (Insert _ date) = DATE ‘2019-01-01’;

Answer: B,D,E

Page: 1 / 113

Total 561 Questions | Updated On: Mar 12, 2026

Add To Cart