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: Dec 17, 2025

Add To Cart

Question 1

Which three statements are true about performing Data Manipulation Language (DML) operations on a view with no INSTEAD OF triggers defined? (Choose three.)

A : Insert statements can always be done on a table through a view.

B : Views cannot be used to add rows to an underlying table if the table has columns with NOT NULL constraints lacking default values which are not referenced in the defining query of the view

C : Views cannot be used to query rows from an underlying table if the table has a PRIMARY KEY and the PRIMARY KEY columns are not referenced in the defining query of the view.

D : Delete statements can always be done on a table through a view

E : The WITH CHECK clause has no effect when deleting rows from the underlying table through the view.

F : Views cannot be used to add or modify rows in an underlying table if the defining query of the view contains the DISTINCT keyword.

Answer: A,C,D

Question 2

Examine this statement:

SELECT cust_id, cust^last_ndma "Last Name"

FROM customers

WHERE country_id — 10 UNION

SELECT cust_ID_CUST_NO, cust_last_name

PROM customers

WHERE country__id = 30

Identify three order by clauses, any one of which will complete the query successfully

A : ORDER BY 2. cust _id

B : ORDER BY 2,

C : ORDER BY "CUST^NO

D : ORDER BY 'Last Name

E : ORDER BY CUST_NO

Answer: A,B,D

Question 3

Which two statements cause changes to the data dictionary?

A : DELETE FROM scott. emp;

B : GRANT UPDATE ON scott. emp TO fin manager;

C : AITER SESSION set NLs. _DATE FORMAT = 'DD/MM/YYYY';

D : TRUNCATE TABLE emp:

E : SELECT * FROM user_ tab._ privs;

Answer: B,D

Question 4

Which two are true about external tables that use the ORACLE _DATAPUMP access driver?

A : Creating an external table creates a directory object.

B : When creating an external table, data can be selected only from a table whose rows are stored in database blocks.

C : When creating an external table, data can be selected from another external table or from a table whose rows are stored in database blocks.

D : Creating an external table creates a dump file that can be used by an external table in the same or a different database.

E : Creating an external table creates a dump file that can be used only by an external table in the same database.

Answer: B,D

Question 5

Which two are true about creating tables in an Oracle database?

A : A create table statement can specify the maximum number of rows the table will contain.

B : The same table name can be used for tables in different schemas.

C : A system privilege is required.

D : Creating an external table will automatically create a file using the specified directory and file name.

E : A primary key constraint is manadatory.

Answer: B,C

Page: 1 / 113

Total 561 Questions | Updated On: Dec 17, 2025

Add To Cart