Oracle Exam 1Z0-071 Topic 3 Question 11 Discussion

Actual exam question for Oracle's 1Z0-071 exam

Question #: 11
Topic #: 3

Examine this business rule:

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

You must design an Entity Relationship (ER) model for optimal data storage and allow for generating reports in this format:

STUDEN_ID FIRST_NAMK LASTNAME PROJECT_ID PROJECT_NAME PROJECT_TASK

Which two statements are true?

AThe ER must have a many-to-many relationship between the students and projects entitles tb.it must be resolved Into one-to-many relationships.

BAn associative table must be created with a composite key of student_id and project_id, which is the foreign key linked to the Stand projects entitles.

CSTUDENT_ID must be the primary key In the students entity and foreign key In the projects
entity.

DPORJECTI_ID must be the primary key In the projects entity and foreign key in the students
The ER must have a one-to-many relationship between the students and projects entitles.

Show Suggested Answer

Suggested Answer: B

by Gail at May 05, 2022, 03:15 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-071 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!