PrepAway - Latest Free Exam Questions & Answers

Tag: For Each Table in Database

What should you do to ensure that combination of the DateShipped, ProductID and InvoiceID is unique for each r

You work as the database administrator for an IT training company named Domain.com. All servers on the Domain.com network run Windows Server 2003 and all database servers run SQL Server 2005. The Domain.com network contains a database server named Certkiller -DB01 B01. Certkiller -DB01 hosts a database named CK_Sales that stores sales data for the company. The tables in the CK_Sales database are shown in the following database diagram.

A PRIMARY KEY column has been declared on the ProductID column of the Products table and the InvoiceID column of the Invoices table. You are creating a table named Inventory to track stock levels. You need to ensure that combination of the DateShipped, ProductID and InvoiceID is unique for each row in the Inventory table.
exhibit What should you do?