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: Aug 03, 2026

Add To Cart

Question 1

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 2

Examine the types and examples of relationships that follow:

Which option indicates correctly matched relationships? (Choose the best answer.)

A : 1-d, 2-b, 3-a, and 4-c

B : 1-c, 2-d, 3-a, and 4-b

C : 1-a, 2-b, 3-c, and 4-d

D : 1-c, 2-a, 3-b, and 4-d

Answer: C

Question 3

Examine the description of the CUSTOMERS table:

Which two SELECT statements will return these results:

CUSTOMER_ NAME

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

Mandy

Mary

A : SELECT customer_ name FROM customers WHERE customer_ name LIKE ' % a % ’ ;

B : SELECT customer_ name FROM customers WHERE customer name LIKE 'Ma%' ;

C : SELECT customer_ name FROM customers WHERE customer_ name='*Ma*';

D : SELECT customer_ name FROM customers WHERE UPPER (customer_ name ) LIKE 'MA*. ;

E : SELECT customer_ name FROM customers WHERE customer name LIKE 'Ma*';

F : SELECT customer_ name FROM customers WHERE UPPER (customer name) LIKE 'MA&';

G : SELECT customer_ name FROM customers WHERE customer_ name KIKE .*Ma*';

Answer: B,D

Question 4

Examine the description of the CUSTOMERS table:

You need to display last names and credit limits of all customers whose last name starts with A or B In lower

or upper case, and whose credit limit is below 1000.

Examine this partial query:

SELECT cust_last_nare, cust_credit_limit FROM customers

Which two WHERE conditions give the required result?

A : WHERE UPPER(cust_last_name) IN ('A%', 'B%') AND cust_credit_limit < 1000:

B : WHERE (INITCAP(cust_last_name) LIKE ‘A%' OR ITITCAP(cust_last_name) LIKE ‘B%') AND cust_credit_limit < 1000

C : WHERE UPPER(cust_last_name) BETWEEN UPPER('A%' AND 'B%’) AND ROUND (cust_credit_limit) < 1000;

D : WHERE (UPPER(cust_last_name) LIKE 'A%’ OR UPPER(cust_last_name) LIKE ‘B%’) AND ROUND(cust_credit_limit) < 1000;

E : WHERE (UPPER(cust_last_name) like INITCAP ('A') OR UPPER(cust_last_name) like INITCAP ('B')) AND ROUND(cust_credit_limit) < ROUND(1000) ;

Answer: B,D

Question 5

Which statement will return the last sequence number generated by the EMP_ SEQ sequence?

A : SELECT NEXTVAL FROM emp_ seq;

B : SELECT CURRVAL FROM emp_ seq;

C : SELECT emp_ seq. CURRVAL FROM DUAL;

D : SELECT emp_ seq . NEXTVAL FROM DUAL;

Answer: D

Page: 1 / 113

Total 561 Questions | Updated On: Aug 03, 2026

Add To Cart