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. Thesales 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 NUL B: Update the FriendlyName column to the same valueas the productName column. Alter the FriendlyName column to be NOT NUL C: D: Define the new column as NOT NULL with a default value of ’Undefined.’ E: Define the new column as NUL F: Use application logic to enforce the data constraint. G: Define the new column as NULL with a default value of ’Undefined.’

公告：维护QQ群：833371870，欢迎加入！
公告：维护QQ群：833371870，欢迎加入！
公告：维护QQ群：833371870，欢迎加入！

2022-06-08

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. Thesales 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 NUL B: Update the FriendlyName column to the same valueas the productName column. Alter the FriendlyName column to be NOT NUL C: D: Define the new column as NOT NULL with a default value of ’Undefined.’ E: Define the new column as NUL F: Use application logic to enforce the data constraint. G: Define the new column as NULL with a default value of ’Undefined.’

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. Thesales 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 NUL
B: Update the FriendlyName column to the same valueas the productName column. Alter the FriendlyName column to be NOT NUL
C:
D: Define the new column as NOT NULL with a default value of ’Undefined.’
E: Define the new column as NUL
F: Use application logic to enforce the data constraint.
G: Define the new column as NULL with a default value of ’Undefined.’

答案：

查看

举一反三