What should you do?

You administer a Microsoft SQL Server 2008 database that contains two tables named Products and Suppliers.
You want to implement referential integrity between the Products and Suppliers tables.
You want to create a new Foreign Key constraint on the Products table.
The new Foreign Key constraint must meet the following requirements:
•It must be created on the SupplierID column on the Products table to refer to the SupplierID column on the Suppliers table.
•It must prevent the deletion of rows from the Suppliers table whenever an attempt is made to delete a Supplier by using a SupplierID referenced by
Foreign Keys in existing rows in the Products table.
You need to be able to create a new Foreign Key constraint by using Microsoft SQL Server Management Studio.
What should you do? (To answer, configure the appropriate option or options in the dialog box in the answer area.)
Exhibit:


A. This is the answer
B.
C.
D.

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.