PrepAway - Latest Free Exam Questions & Answers

Tag: sql server alter column add default not named

What should you do to add this new column by using the least amount of effort?

You are work as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. The Domain.com network contains a SQL Server 2005 database server named Certkiller -DB08. Your duties at Domain.com include the administrating of Certkiller -DB08.
Certkiller -DB08 hosts a database named CK_Sales that stores sales transactions for the company. The table structure for the CK_Sales database is shown in the following exhibit:

You need to modify the Products table to add a new column named ProductName. You want a friendly name for each product will be stored in this column. The table currently contains data. The Marketing department has not yet created a friendly name for each product. You need to add this new column by using the least amount of effort.
exhibit What should you do?