100% Free 1Z0-071 Practice Exam Questions and Answers

Stay Ahead with Latest 1Z0-071 Oracle Database 12c Practice Test Questions 2026

Page: 1 / 113

Total 561 Questions | Updated On: Oct 24, 2026

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

View the exhibit for the structure of the STUDENT and FACULTY tables.

You need to display the faculty name followed by the number of students handled by the faculty at

the base location.

Examine the following two SQL statements:

Statement 1

SQL>SELECT faculty_name, COUNT(student_id)

FROM student JOIN faculty

USING (faculty_id, location_id)

GROUP BY faculty_name;

Statement 2

SQL>SELECT faculty_name, COUNT(student_id)

FROM student NATURAL JOIN faculty

GROUP BY faculty_name;

Which statement is true regarding the outcome?

A : Only statement 2 executes successfully and gives the required result.

B : Only statement 1 executes successfully and gives the required result.

C : Both statements 1 and 2 execute successfully and give different results.

D : Both statements 1 and 2 execute successfully and give the same required result.

Answer: B

Question 3

Examine this business rule:

Each student can work on multiple projects and earth project can have multiple students.

You must decide an Entity Relationship (ER) model for optional data storage and allow generating reports in

this format:

STUDENT_ID FIRST_NAME LAST_NAME PROJECT_ID PROJECT_NAME PROJECT_TASK Which

two statements are true?

A : An associative table must be created with a composite key of STUDENT_ID and PROJECT_ID, which is the foreign key linked to the STUDENTS and PROJECTS entities.

B : The ER must have a many-to-many relationship between the STUDENTS and PROJECTS entities that must be resolved into 1-to-many relationships.

C : PROJECT_ID must be the primary key in the PROJECTS entity and foreign key in the STUDENTS entity.

D : The ER must have a 1-to-many relationship between the STUDENTS and PROJECTS entities.

E : STUDENT_ID must be the primary key in the STUDENTS entity and foreign key in the PROJECTS entity.

Answer: A,B

Question 4

Examine this description of the PRODUCTS table: