Note: This question is part of a series of questions that use the same set of answer choices. An answer choice may be correct for more than one question in the series.
You administer a Microsoft SQL Server 2008 database for an inventory management system. The application contains a product table that has the following definition:
CREATE TABLE [Production].[Product](
[ProductID] [int] IDENTITY(1,1) NOT NULL,
[Name] [nvarchar](50) NOT NULL,
[ProductNumber] [nvarchar](25) NOT NULL,
[Color] [nvarchar](15) NULL,
[Class] [nchar](2) NULL,
[Style] [nchar](2) NULL,
[Active] [bit] NOT NULL,
[ModifiedDate] [datetime] NOT NULL,
CONSTRAINT [PK_Product_ProductID] PRIMARY KEY CLUSTERED ([ProductID] ASC) ON [PRIMARY]) ON [PRIMARY]
GO
You want to add a new field to the Product table to meet the following requirements:
•Allows user-specified information that will be added to records in the Product table.
•Supports the largest storage size needed for the field.
•Uses the smallest data type necessary to support the domain of values that will be entered by users.
You need to add a field named User_Data_1 to support decimal values between 0 and 10,000 that have up to six decimal points.
Which SQL statement should you use?
A. ALTER TABLE [Production].[Product] ADD [User_Data_1] DATETIME2
B. ALTER TABLE [Production].[Product] ADD [User_Data_1] SMALLMONEY
C. ALTER TABLE [Production].[Product] ADD [User_Data_1] NUMERIC(11,6)
D. ALTER TABLE [Production].[Product] ADD [User_Data_1] DATETIME
E. ALTER TABLE [Production].[Product] ADD [User_Data_1] NUMERIC(6,11)
F. ALTER TABLE [Production].[Product] ADD [User_Data_1] DATE
G. ALTER TABLE [Production].[Product] ADD [User_Data_1] BIGINT
H. ALTER TABLE [Production].[Product] ADD [User_Data_1] TINYINT
I. ALTER TABLE [Production].[Product] ADD [User_Data_1] CHAR(100)
J. ALTER TABLE [Production].[Product] ADD [User_Data_1] NVARCHAR(100)
K. ALTER TABLE [Production].[Product] ADD [User_Data_1] BIT
L. ALTER TABLE [Production].[Product] ADD [User_Data_1] SMALLINT
M. ALTER TABLE [Production].[Product] ADD [User_Data_1] VARCHAR(100)
N. ALTER TABLE [Production].[Product] ADD [User_Data_1] INT
O. ALTER TABLE [Production].[Product] ADD [User_Data_1] NCHAR(100)
P. ALTER TABLE [Production].[Product] ADD [User_Data_1] NUMERIC(5,6)
Q ALTER TABLE [Production].[Product] ADD [User_Data_1] MONEY
Q. ALTER TABLE [Production].[Product] ADD [User_Data_1] SMALLDATETIME
