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: Mar 26, 2025

Add To Cart

Question 1

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 2

Examine these statements and results

SQL> SELECT COUNT(*) FROM emp

COUNT(*)

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

sQL> CREATE GLOBAL TEMPORARY TABLE t emp As SELECT * FROM emp;

Table created

SQL> INSERT INTo temp SELECT * FROM emp;

14 rows created

SQL> COMMIT:

Commit complete*

SQL> INSERT INTo temp SELECT * EROM emp;

14. rows created

SQL> SELECT COUNT(*) FROM t emp

How many rows are retrieved by the last query?

A : 28

B : 0

C : 14

D : 42

Answer: C

Question 3

Examine the structure of the MEMBERS table:

You want to display details of all members who reside in states starting with the letter A followed by

exactly one character.

Which SQL statement must you execute?

A : LECT * FROM MEMBERS WHERE state LIKE '%A_';

B : LECT * FROM MEMBERS WHERE state LIKE 'A_';

C : LECT * FROM MEMBERS WHERE state LIKE 'A_%';

D : LECT * FROM MEMBERS WHERE state LIKE 'A%';

Answer: B

Question 4

Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data? (Choose four.)

A : It is possible for child rows that have a foreign key to remain in the child table at the time the parent row is deleted

B : Only the primary key can be defined at the column and table level

C : The foreign key columns and parent table primary key columns must have the same names

D : A table can have only one primary key and one foreign key

E : A table can have only one primary key but multiple foreign keys

F : Primary key and foreign key constraints can be defined at both the column and table level

G : It is possible for child rows that have a foreign key to be deleted automatically from the child table at the time the parent row is deleted

Answer: A,E,F,G

Question 5

Which two are true about the NVL, NVL2, and COALESCE functions?

A : first expression in NVL2 is never returned.

B : L2 can have any number of expressions in the list.

C : ALESCE stops evaluating the list of expressions when it finds the first null value.

D : ALESCE stops evaluating the list of expressions when it finds the first non-null value.

E : L must have expressions of the same data type.

F : L can have any number of expressions in the list.

Answer: A,D

Page: 1 / 113

Total 561 Questions | Updated On: Mar 26, 2025

Add To Cart