教学文章
Technology Exchange
Technology Exchange
热门课程
400电话
免费咨询热线
400-090-9964
【2019年8月版本】OCP 071认证考试最新版本的考试原题-17-CUUG整理
OCP的071考试，在8月份左右全部换了新题，近期考试的题也全部不包括之前的题库了，这次oracle更新071考试题库，虽然全都是新题，但跟之前的相比也有关联，比如把之前的考题稍微变换一下数字、更新一下日期、或者再加一个错误选项等等。
对于2019年8月份的更新，我们CUUG已经进行了收集整理，并给出初步的答案和讲解，仅供参考，希望对考OCP 071认证的同学有帮助。
choose two
Examine this business rule:
Each studert can work on mutiple projects and eath project can have multiple students
You must desion an Entity Relationsep (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 eitity 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.
Anaswer：AB
(解析：这道题涉及到调优问题，应用中经常出现多对多之间的关系，如何解决 STUDENTS and PROJECTS 两张表的多对多关系，可以创建一个中间表，这个表包含那两张表的主键列，同时是另外两张表的外键约束。通常这个表建成索引组织表。)