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.’

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.’

答案：

B

举一反三

内容

0
‎用下面的语句创建了Student表：‍‎CREATE TABLE Student(Sno CHAR(10) primary key,‍‎Sname VARCHAR(10),‍‎age SMALLINT,‍‎Cname VARCHAR(20) );‍‎请用ALTER TABLE语句设置age字段默认值为20，正确的语句是（）。‍‎‍ A: ALTER TABLE Student ALTER COLUMN age SET DEFAULT 20; B: ALTER TABLE Student CHANGE COLUMN age SET DEFAULT 20; C: ALTER TABLE Student ADD COLUMN age SET DEFAULT 20; D: ALTER TABLE Student DROP COLUMN age SET DEFAULT 20;
1
Macth each word in column A with its definition in column B
2
Match each word in Column A with the correct definition in Column B.
3
Among the following conclusions about the critical stress σcr of the compressive column, the correct one is ( ). A: The σcr value of the long column is independent of the material B: The σcr value of the intermediate column is independent of the flexibility C: The σcr value of the intermediate column is independent of the material D: The σcr value of the small flexibility column is independent of the flexibility
4
Among the following conclusions about the critical stress σcr of the compressive column, the correct one is ( ) A: The σcr value of the long column is independent of the material B: The σcr value of the intermediate column is independent of the flexibility C: The σcr value of the intermediate column is independent of the materia D: The σcr value of the small flexibility column is independent of the flexibility