Free Oracle 1Z0-071 Practice Exam Questions and Answers 2026

Start Learning with the Newest and 100% Free 1Z0-071 Exam Dumps Questions

Page: 1 / 113

Total 561 Questions | Updated On: Apr 02, 2026

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 : DELETEFROM productsWHERE prod_id = (SELECT prod_idFROM salesWHERE time_id - 3*365 = SYSDATE );

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

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

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

Answer: C

Question 2

Which three statements about roles are true?

A : Roles are assigned to roles using the ALTER ROLE Statement

B : A role is a named group of related privileges that can only be assigned to a user

C : Roles are assigned to users using the ALTER USER statement

D : A single role can be assigned to multiple users.

E : A single user can be assigned multiple roles

F : Privileges are assigned to a role using the ALTER ROLE statement.

G : Privileges are assigned to a role using the GRANT statement.

Answer: A,D

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 two are true about the MERGE statement?

A : The WHEN NOT MATCHED clause can be used to specify the deletions to be performed.

B : The WHEN NOT MATCHED clause can be used to specify the inserts to be performed.

C : The WHEN MATCHED clause can be used to specify the inserts to be performed.

D : The WHEN NOT MATCHED clause can be used to specify the updates to be performed.

E : The WHEN MATCHED clause can be used to specify the updates to be performed.

Answer: B,E

Question 5

Examine the structure and data in the PRICE_LIST table:

You plan to give a discount of 25% on the product price and need to display the discount amount in

the same format as the PROD_PRICE.

Which SQL statement would give the required result?

A : SELECT TO_CHAR (prod_price* .25, ‘$99,999.99’)FROM PRICE_LIST

B : SELECT TO_CHAR (TO_NUMBER(prod_price) * .25, ‘$99,999.00’)FROM PRICE_LIST

C : SELECT TO_CHAR (TO_NUMBER(prod_price, ‘$99,999.99’) * . 25, ‘$99,999.00’)FROM PRICE_LIST

D : SELECT TO_NUMBER (TO_NUMBER(prod_price, ‘$99,999.99’) * . 25, ‘$99,999.00’)FROM PRICE_LIST

Answer: C

Page: 1 / 113

Total 561 Questions | Updated On: Apr 02, 2026

Add To Cart