Oracle
1Z0-882 · Question #46
1Z0-882 Question #46: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-882 to reveal the answer and full explanation for question #46. The question stem and answer options stay visible for context.
Question
An application tracks usage of educational courses in a company. Many people can take one course. Each person can take multiple courses. The data has been stored in one table but it is growing too large. You decide to normalize the table. What would a normalized data model contain?
Options
- ATwo tables: employee and course, with foreign keys on employee ID and course ID.
- BThree tables: employee, course, and a table cross-referencing employee IDs and course IDs
- CTwo tables: an employee table with multiple course IDs , and a course table
- DFour tables: employee, course, courses by employee, and employees by course
Unlock 1Z0-882 to see the answer
You've previewed enough free 1Z0-882 questions. Unlock 1Z0-882 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.