Microsoft
98-364 · Question #73
98-364 Question #73: Real Exam Question with Answer & Explanation
Sign in or unlock 98-364 to reveal the answer and full explanation for question #73. The question stem and answer options stay visible for context.
Question
You work as a Database Designer for Realtech Inc. You want to create two tables, Product and Order, such that a row in the Order table does not exist without a corresponding row in the Product table. The structure of the Product and Order tables with their respective columns is given below: - Product - ProductID - ProductNumber - Date_of_manufacturing - SupplierID - ProductPrice - ProductQty - Order - OrderID - OrderDate - OrderQuantity - OrderPrice Based on this information, while maintaining the integrity of this rule, what will you do to accomplish the task?
Options
- ACreate the Product table, and then create the Order table.
- BCreate the Product table, and then create the Order table that has a primary key referenced
- CCreate the Product table, and then create the Order table.
- DCreate the Product table, and then create the Order table that has a foreign key constraint
Unlock 98-364 to see the answer
You've previewed enough free 98-364 questions. Unlock 98-364 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.