Free Practice Oracle 1Z0-071 Exam Questions 2025

Stay ahead with 100% Free Oracle Database 12c SQL 1Z0-071 Dumps Practice Questions

Page: 1 / 113

Total 561 Questions | Updated On: Aug 21, 2019

Add To Cart

Question 1

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

Question 2

In your session NLS_ DATE_ FORMAT is set to DD--MON_RR.

Which two queries display the year as four digits?

A : SELECT TO_DATE(TO_CHAR(SYSDATE,'MM/DD/YYYY'),'MM/DD/YYYY') FROM DUAL;

B : SELECT TO_CHAR (ADD_MONTHS (SYSDATE,6)) FROM DUAL;

C : SELECT TO_DATE (SYSDATE, 'RRRR-MM-DD') FROM DUAL;

D : SELECT TO_DATE (ADD_MONTHS(SYSDATE,6), 'dd-mon-yyyy') FROM DUAL;

E : SELECT TO_CHAR (SYSDATE, 'MM/DD/YYYY') FROM DUAL;

F : SELECT TO_CHAR (ADD_MONTHS (SYSDATE, 6), 'dd-mon-yyyy') FROM DUAL;

Answer: A

Question 3

Examine this query which executes successfully:

SELECT job, deptno FROM emp

UNION ALL

SELECT job, deptno FROM jobs_ history;

What will be the result?

A : It will return rows common to both SELECT statements.

B : It will return rows from both SELECT statements after eliminating duplicate rows

C : It will return rows that are not common to both SELECT statements.

D : It will return rows from both SELECT statements including duplicate rows.

Answer: D

Question 4

Which two statements are true regarding views? (Choose two.)

A : The WITH CHECK OPTION constraint can be used in a view definition to restrict the columns displayed through the view.

B : The OR REPLACE option is used to change the definition of an existing view without dropping and re-creating it.

C : Rows cannot be deleted through a view if the view definition contains the DISTINCT keyword.

D : Rows added through a view are deleted from the table automatically when the view is dropped.

E : A simple view in which column aliases have been used cannot be updated.

F : A subquery used in a complex view definition cannot contain group functions or joins.

Answer: B,C

Question 5

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

Page: 1 / 113

Total 561 Questions | Updated On: Aug 21, 2019

Add To Cart