Microsoft
77-885 · Question #1
77-885 Question #1: Real Exam Question with Answer & Explanation
Sign in or unlock 77-885 to reveal the answer and full explanation for question #1. The question stem and answer options stay visible for context.
Question
You work as a Database Designer for Tech Perfect Inc. The company has a Windows Vista-based computer with Microsoft Office 2010 installed on it. The computer contains two databases named Shippers and Orders created in Microsoft Office Access 2010. A one-to-many relationship is created between both tables. You want to delete a Shipper. The shipper that you want to delete has orders in the Orders table. When you delete the Shipper record, these orders will become "orphans". The orders will still include a shipper ID, but this ID will not be valid. What will you do to prevent these orphans?
Options
- ACascade delete related records.
- BEnforce domain integrity.
- CCascade update related fields.
- DEnforce referential integrity.
Unlock 77-885 to see the answer
You've previewed enough free 77-885 questions. Unlock 77-885 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.