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.
What should you do?
A.
You need to define the new column as NULL. Update the ProductName column to the same value as the Description column. Alter the ProductName column to be NOT NULL.
B.
You need to define the new column as NOT NULL with a default value of ‘Undefined.’
C.
You need to define the new column as NULL. Use application logic to enforce the data constraint.
D.
You need to define the new column as NULL with a default value of ‘Undefined.’
Explanation:
You don’t want to create the new column to accept NULL values and therefore you should create it as NOT NULL and by default enter ‘Undefined’ as the value for each product until the Sales Department changes the value to the correct friendly name.