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: Jun 06, 2025

Add To Cart

Question 1

Examine the structure proposed for the TRANSACTIONS table:

Which two statements are true regarding the creation and storage of data in the above table

structure? (Choose two.)

A : The CUST_STATUS column would store exactly one character

B : The TRANS_VALIDITY column would have a maximum size of one character.

C : The CUST_CREDIT_LIMIT column would be able to store decimal values.

D : The CUST_STATUS column would give an error.

E : The TRANS_DATE column would be able to store day, month, century, year, hour, minutes, seconds, and fractions of seconds.

F : The TRANS_VALIDITY column would give an error.

Answer: A,C

Question 2

Examine the structure of the INVOICE table.

Which two SQL statements would execute successfully? (Choose two.)

A : SELECT inv_no,NVL2(inv_date,'Pending','Incomplete')FROM invoice;

B : SELECT inv_no,NVL2(inv_amt,inv_date,'Not Available')FROM invoice;

C : SELECT inv_no,NVL2(inv_date,sysdate-inv_date,sysdate)FROM invoice;

D : SELECT inv_no,NVL2(inv_amt,inv_amt*.25,'Not Available')FROM invoice;

Answer: A,C

Question 3

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 4

Which statement falls to execute successfully?

A : SELECT *FROM employees eJOIN department dWHERE e.department_id=d.department_idAND d.department_id=90;

B : SELECT *FROM employees eJOIN departments dON e.department_id=d.department_idWHERE d.department_id=90;

C : SELECT *FROM employees eJOIN departments dON e.department_id=d.department_idAND d.department_id=90;

D : SELECT *FROM employees eJOIN departments dON d.departments_id=90WHERE e.department_id=d.department_id;

Answer: A

Question 5

View the exhibit and examine the descriptions of the DEPT and LOCATIONS tables.

You want to update the CITY column of the DEPT table for all the rows with the corresponding value

in the CITY column of the LOCATIONS table for each department.

Which SQL statement would you execute to accomplish the task?

A : UPDATE dept dSET city = ALL (SELECT cityFROM locations lWHERE d.location_id = l.location_id);

B : UPDATE dept dSET city = (SELECT cityFROM locations l)WHERE d.location_id = l.location_id;

C : UPDATE dept dSET city = ANY (SELECT cityFROM locations l)

D : UPDATE dept dSET city = (SELECT cityFROM locations lWHERE d.location_id = l.location_id);

Answer: D

Page: 1 / 113

Total 561 Questions | Updated On: Jun 06, 2025

Add To Cart