皮皮学,免费搜题
登录
logo - 刷刷题
搜题
【单选题】
You are the database administrator for a retail company. The company owns 270 stores. Every month, each store submits approximately 2,000 sales records, which are loaded into a SQL Server 2000 database at the corporate headquarters. A Data Transformation Services (DTS) package transforms the sales records, as they are loaded. The package writes the transformed sales records to the Sales table, which has a column for integer primary key values. The IDENTITY property automatically assigns a key value to each transformed sales record. After loading this month's sales data, you discover that a portion of the data contains errors. You stop loading data, identify the problem records, and delete those records from the database. You want to reuse the key values that were assigned to the records that you deleted. You want to assign the deleted key values to the next sales records you load. You also want to disrupt users' work as little as possible. What should you do?
A.
Export all records from the Sales table to a temporary table. Truncate the Sales table, and then reload the records from the temporary table.
B.
Export all records from the Sales table to a text file. Drop the Sales table, and then reload the records from the text file.
C.
Use the DBCC CHECKIDENT statement to reseed the Sales table's IDENTITY property.
D.
Set the Sales table's IDENTITY_INSERT property to ON. Add new sales records that have the desired key values.
手机使用
分享
复制链接
新浪微博
分享QQ
微信扫一扫
微信内点击右上角“…”即可分享
反馈
参考答案:
举一反三
【判断题】滇池、鄱阳湖和长白山天池都属于构造湖。答案:
A.
正确
B.
错误
【单选题】小岛上的一个纪元是多少年?
A.
二十年
B.
四十年
C.
五十二年
D.
八十八年
【多选题】在19世纪70年代后,早期维新思想的代表人物有
A.
李鸿章
B.
郑观应
C.
王韬
D.
马建忠
【单选题】图中,合闸位置继电器 KCC 断电返回时,
A.
常开触点 KCC1 断开,红灯 RD 熄灭;常闭触点 KCC2 闭合。
B.
常开触点 KCC2 断开,红灯 RD 亮;常闭触点 KCC1 闭合。
C.
常开触点 KCC1 断开,红灯 RD亮;常闭触点 KCC2 闭合。
D.
常开触点 KCC1 断开,红灯 RD 熄灭;常闭触点 KCC2 断开。
【判断题】氧和碳在硅晶体中分布是一样的,都是呈螺旋状分布的。
A.
正确
B.
错误
【单选题】听力原文:M:I hope it'll be fine tomorrow, I'm going to boat with Frank. W: Oh, I think it will be fine. M: Are you sure? W: Yes. I heard it on the radio. What are the two speakers talking about?
A.
A fine boat.
B.
Their friend,Frank.
C.
The weather.
【单选题】听力原文:W: Do you like the dress? M: I love it. W: I designed it myself. M: It's beautiful. W: Are you ready? We're supposed to be there before the guests arrive. M: I know. I know. Help me with this tie...
A.
Colleagues.
B.
Husband and wife.
C.
Mother and son.
D.
Classmates.
【简答题】电容式传感器可分为 、 、 三种类型。
【多选题】电容式传感器可分为 、 、 三种类型。
A.
变极距式
B.
变面积式
C.
变介质式
D.
电流型
【单选题】听力原文:W: Do you like the dress? M: I love it. W: I designed it myself. M: It's beautiful. W: Are you ready? We're supposed to be there before the guests arrive. M: I know. I know. Help me with this tie...
A.
Colleagues.
B.
Husband and wife.
C.
Mother and son.
D.
Classmates.
相关题目:
参考解析:
知识点:
题目纠错 0
发布
创建自己的小题库 - 刷刷题