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 21, 2019

Add To Cart

Question 1

The BOOKS_TRANSACTIONS table exists in your schema in this database.

You execute this SQL statement when connected to your schema in your database instance.

SQL> SELECT * FROM books_transactions ORDER BY 3;

What is the result?

A : execution fails unless the numeral 3 in the ORDER BY clause is replaced by a column name.

B : l table rows are displayed sorted in ascending order of the values in the third column.

C : first three rows in the table are displayed in the order that they are stored.

D : ly the three rows with the lowest values in the key column are displayed in the order that they are stored.

Answer: B

Question 2

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 3

View the Exhibit and examine the structure of the ORDERS table. The ORDER_ID column is the PRIMARY KEY in the ORDERS table.

Evaluate the following CREATE TABLE command:

CREATE TABLE new_orders(ord_id, ord_date DEFAULT SYSDATE, cus_id)

SELECT order_id.order_date,customer_id

FROM orders;

Which statement is true regarding the above command?

A : NEW_ODRDERS table would not get created because the DEFAULT value cannot be specified in the column definition.

B : NEW_ODRDERS table would get created and only the NOT NULL constraint defined on the specified columns would be passed to the new table.

C : NEW_ODRDERS table would not get created because the column names in the CREATE TABLE command and the SELECT clause do not match.

D : NEW_ODRDERS table would get created and all the constraints defined on the specified columns in the ORDERS table would be passed to the new table.

Answer: B

Question 4

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 5

Examine this statement:

Which two statements are true?

A : l remaining employee names will appear in an ascending order

B : names of employees remaining the maximum salary will appear first in an ascending order

C : l remaining employee names will appear in ascending order

D : l remaining employee names will appear in descending order

E : names of employees maximum salary will appear fist to descending order

F : names of employees maximum salary will appear fist to ascending order

Answer: A,C

Page: 1 / 113

Total 561 Questions | Updated On: Aug 21, 2019

Add To Cart