Oracle Database SQL 12c 1z0-071 Exam Practice Test 1

Question : 8 of 50

Marks: +1, -0

The ER must have a 1-to-many relationship between the STUDENTS and PROJECTS entities.
The ER must have a many-to-many relationship between the STUDENTS and PROJECTS entities that must be resolved into 1-to-many relationships.
STUDENT_ID must be the primary key in the STUDENTS entity and foreign key in the PROJECTS entity.
PROJECT_ID must be the primary key in the PROJECTS entity and foreign key in the STUDENTS entity.
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 andPROJECTS entities.

Go to Question: