You are modifying a table named Product in a SQL Server 2005 database. You want to add a new column named FriendlyName to the Product table. A friendly name for each product will be stored in this column. The table currently contains data. The sales department has not yet created a friendly name for each product. FriendlyName is a required value for each product. You want to add this new column by using the least amount of effort. What should you do?
A.
Define the new column as NULL. Update the FriendlyName column to the same value as the ProductName column. Alter the FriendlyName column to be NOT NULL.
B.
Define the new column as NOT NULL with a default value of ‘Undefined.’
C.
Define the new column as NULL. Use application logic to enforce the data constraint.
D.
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.