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: Feb 18, 2025

Add To Cart

Question 1

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

Evaluate the following SQL statements:

Statement 1:

SELECT MAX(unit_price*quantity) “Maximum Order”

FROM order_items;

Statement 2:

SELECT MAX(unit_price*quantity) “Maximum Order”

FROM order_items

GROUP BY order_id;

Which statements are true regarding the output of these SQL statements? (Choose all that apply.)

A : atement 2 would return multiple rows of output.

B : th statements would ignore NULL values for the UNIT_PRICE and QUANTITY columns.

C : atement 1 would not return give the same output.

D : th the statements would give the same output.

E : atement 1 would return only one row of output.

Answer: A,B

Question 2

Examine the description of the CUSTOMERS table:

Which three statements will do an implicit conversion?

A : LECT * FROM customers WHERE insert_date=DATE'2019-01-01';

B : LECT * FROM customers WHERE customer_id='0001';

C : LECT * FROM customers WHERE TO_DATE(insert_date)=DATE'2019-01-01';

D : LECT * FROM customers WHERE insert_date'01-JAN-19';

E : LECT * FROM customers WHERE customer_id=0001;

F : LECT * FROM customers WHERE TO_CHAR(customer_id)='0001';

Answer: B,C,D

Question 3

Which two statements are true about * _ TABLES views?

A : u must have SELECT privileges on a table to view it in ALL _TABLES.

B : u must have SELECT privileges on a table to view it in DBA TABLES.

C : ER_ TABLES displays all tables owned by the current user.

D : L TABLES displays all tables owned by the current user.

E : u must have SELECT privileges on a table to view it in USER TABLES.

F : l users can query DBA TABLES successfully.

Answer: A,C

Question 4

Examine the data in the COLORS table:Examine the data in the BRICKS table: Which two queries return all the rows from COLORS?

A : SELECT.FROM bricks bRIGHT JOIN colors cON b. color _rgb_ hex_ value = c. rgb hex_ value;

B : SELECTEROM colors CLEFT JOIN bricks #USING (rgb _ hex_ value) ;

C : SELECTFROM bricks bFULL JOIN colors CON b. color rgb _ hex_ value = c. rgb _hex_ value;

D : SELECT *EROM bricks | bJOIN colors CON b. color_ rgb_ hex_ value =c. rgb _hex value;

E : SELECTEROM colors CLEET JOIN bricks bON b. color_ rgb_ hex value = c. rgb. hex.valueWHERE b. brick_ id > 0;

Answer: A,B

Question 5

Examine the data in the PRODUCTS table:

Examine these queries:

1. SELECT prod name, prod list

FROM products

WHERE prod 1ist NOT IN(1020) AND category _id=1;

2. SELECT prod name, | prod _ list

FROM products

WHERE prod list < > ANY (1020) AND category _id= 1;

SELECT prod name, prod _ list

FROM products

WHERE prod_ list < > ALL (10 20) AND category _ id= 1;

Which queries generate the same output?

A : 1 and 3

B : 1, 2 and 3

C : 2 and 3

D : 1 and 2

Answer: A

Page: 1 / 113

Total 561 Questions | Updated On: Feb 18, 2025

Add To Cart