Oracle
1Z0-071 · Question #39
1Z0-071 Question #39: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-071 to reveal the answer and full explanation for question #39. The question stem and answer options stay visible for context.
Question
Examine the business rule: Each student can take up multiple projects and each project can have multiple students. You need to design an Entity Relationship Model (ERD) for optimal data storage and allow for generating reports in this format: STUDENT_ID FIRST_NAME LAST_NAME PROJECT_ID PROJECT_NAME PROJECT_TASK Which two statements are true in this scenario?
Options
- AThe ERD must have a1:M relationship between the students and projects entitles.
- BThe ERD must have a M:M relationship between the students and projects entities that must be
- CSTUDENT_ID must be the primary key in the STUDENTS entity and foreign key in the projects
- DPROJECT_ID must be the primary key in the projects entity and foreign key in the STUDENTS
- EAn associative table must be created with a composite key of STUDENT_ID andPROJECT_ID;
Unlock 1Z0-071 to see the answer
You've previewed enough free 1Z0-071 questions. Unlock 1Z0-071 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.