【2019年8月版本】OCP 071認證考試最新版本的考試原題-17
最新學訊：近期OCP認證正在報名中，因考試人員較多請盡快報名獲取最近考試時間，報名費用請聯(lián)系在線老師，甲骨文官方認證，報名從速！
我要咨詢【2019年8月版本】OCP 071認證考試最新版本的考試原題-17-CUUG整理
OCP的071考試，在8月份左右全部換了新題，近期考試的題也全部不包括之前的題庫了，這次oracle更新071考試題庫，雖然全都是新題，但跟之前的相比也有關(guān)聯(lián)，比如把之前的考題稍微變換一下數(shù)字、更新一下日期、或者再加一個錯誤選項等等。
對于2019年8月份的更新，我們CUUG已經(jīng)進行了收集整理，并給出初步的答案和講解，僅供參考，希望對考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
(解析：這道題涉及到調(diào)優(yōu)問題，應(yīng)用中經(jīng)常出現(xiàn)多對多之間的關(guān)系，如何解決 STUDENTS and PROJECTS 兩張表的多對多關(guān)系，可以創(chuàng)建一個中間表，這個表包含那兩張表的主鍵列，同時是另外兩張表的外鍵約束。通常這個表建成索引組織表。)
PostgreSQL入門到精通 100+ 個學習資料
- 陳衛(wèi)星-老師CUUG金牌講師
- 陳老師 CUUG金牌講師 精通Oracle管理、備份恢復(fù)、性能優(yōu)化 11年Ora...[詳細了解老師]
