You need to create a column that allows you to create a unique constraint.
Which two column definitions should you choose? (Each correct answer presents a complete solution. Choose two.)
A.
nvarchar(100) NULL
B.
nvarchar(max) NOT NULL
C.
nvarchar(100) NOT NULL
D.
nvarchar(100) SPARSE NULL
A and C