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

View the Exhibit and examine the description for the PRODUCTS and SALES table.

PROD_ID is a primary key in the PRODUCTS table and foreign key in the SALES table with ON DELETE

CASCADE option. The SALES table contains data for the last three years. You want to remove all the

rows from the PRODUCTS table for which no sale was done for the last three years.

Which is the valid DELETE statement?

A : LETEFROM productsWHERE prod_id = (SELECT prod_idFROM salesWHERE time_id - 3*365 = SYSDATE );

B : LETEFROM productsWHERE prod_id = (SELECT prod_idFROM salesWHERE SYSDATE >= time_id - 3*365 );

C : LETEFROM productsWHERE prod_id IN (SELECT prod_idFROM salesWHERE SYSDATE - 3*365 >= time_id);

D : LETEFROM productsWHERE prod_id IN (SELECT prod_idFROM salesWHERE time_id >= SYSDATE - 3*365 );

Answer: C

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

You need to display the date 11-oct-2007 in words as ‘Eleventh of October, Two Thousand Seven’. Which SQL statement would give the required result?

A : LECT TO_CHAR(TO_DATE(’11-oct-2007’), ‘fmDdthsp “of” Month, Year’)FROM DUAL;

B : LECT TO_CHAR(‘11-oct-2007’, ‘fmDdspth “of” Month, Year’)FROM DUAL;

C : LECT TO_CHAR(TO_DATE(‘11-oct-2007’), ‘fmDdspth of month, year’)FROM DUAL;

D : LECT TO_DATE(TO_CHAR(’11-oct-2007’), ‘fmDdspth “of” Month, Year’))FROM DUAL;

Answer: A

Question 4

Examine the description of the EMPLOYEES table:

Which query requires explicit data type conversion?

A : LECT join_date FROM employees WHERE join_date > ’10-02-2018’;

B : LECT salary + ‘120.50’ FROM employees;

C : LECT SUBSTR(join_date, 1, 2) – 10 FROM employees;

D : LECT join_date + ‘20’ FROM employees;

E : LECT join_date || ‘ ‘ || salary FROM employees;

Answer: D

Question 5

Examine these statements executed in a single Oracle session:

Which three statements are true?

A : code for pen is 1

B : ere is no row containing pencil.

C : code for fountain pen is 3.

D : code for pen is 10

E : ere is no row containing fountain pen.

F : ere is no row containing pen.

Answer: B,C,D

Page: 1 / 113

Total 561 Questions | Updated On: Aug 21, 2019

Add To Cart