题目内容

BULK INSERT finance.dbo.customers
FROM ‘di\bulk\accts143_10141000.txt’
WITH DATAFILETYPE = ‘char’,
FIELD/TERMINATOR = ‘\t’,
ROWTERMINATOR = ‘\n,’
TABLOCK
You want to ensure that response times do not slow when new account information is added to the database. What should you do？

A. Drop the indexes for the customers table before the data load, and then re-create the indexes after the data load is complete.
B. Remove the TABLOCK option from the BULK INSERT statement.
C. Add the BATCHSIZE option to the BULK INSERT statement and then set the option equal to 10 percent of the number of rows to be loaded.
D. Add the ROWS_PER_BATCH option to the BULK INSERT statement and then set the option equal to 10 percent of the number of rows to be loaded.

查看答案

搜索结果不匹配？点我反馈

更多问题

某地区某类房地产1998～2004年价格见下表。
某类房地产1998～2004年价格 (单位：元/m2)
根据直线趋势法，预测该地区该类型房地产2005年的价格为()元/m2。

A. 3300
B. 3157
C. 3357
D. 3156

查看答案

从2003年1月1日起，保险企业开展业务支付的代理手续费，可在不超过当年本企业全部实收保费收入()的范围内据实扣除。

A. 0.02
B. 0.05
C. 0.08
D. 0.1

查看答案

一般物品是“劳动价值”的货币表现，地价本质上是地租的资本化，不是“劳动价值”的货币表现。

A. 正确
B. 错误

查看答案

You are the administrator of a SQL Server 2000 computer. The server contains a database named Inventory. The Inventory database has a table named StorageLocations that stores the location of parts contained in your company's warehouses. The StorageLocations table is configured as shown in the exhibit.
The LocationDescription field is usually described with a name 10 to 25 characters in length. The locations never store more than 100,000 units of any given part.
You want to modify the table's schema to save space. You cannot lose any existing data. You want to do this by using the minimum amount of administrative time and server resources.
Which Transact-SQL statement should you execute？

ALTER TABLE [dbo].[StorageLocations] ALTER COLUMN [UnitsStored] [int] NOT NULL
B. ALTER TABLE [dbo].[StorageLocations] [LocationDescription] [char] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
C. ALTER TABLE [dbo].[StorageLocations] ALTER COLUMN [UnitsStored] [smallint] NOT NULL
D. ALTER TABLE [dbo].[StorageLocations] [LocationDescription] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL

查看答案

BULK INSERT finance.dbo.customersFROM ‘di\bulk\accts143_10141000.txt’WITH DATAFILETYPE = ‘char’,FIELD/TERMINATOR = ‘\t’,ROWTERMINATOR = ‘\n,’TABLOCKYou want to ensure that response times do not slow when new account information is added to the database. What should you do？

某地区某类房地产1998～2004年价格见下表。某类房地产1998～2004年价格 (单位：元/m2)根据直线趋势法，预测该地区该类型房地产2005年的价格为()元/m2。

从2003年1月1日起，保险企业开展业务支付的代理手续费，可在不超过当年本企业全部实收保费收入()的范围内据实扣除。

一般物品是“劳动价值”的货币表现，地价本质上是地租的资本化，不是“劳动价值”的货币表现。

BULK INSERT finance.dbo.customers
FROM ‘di\bulk\accts143_10141000.txt’
WITH DATAFILETYPE = ‘char’,
FIELD/TERMINATOR = ‘\t’,
ROWTERMINATOR = ‘\n,’
TABLOCK
You want to ensure that response times do not slow when new account information is added to the database. What should you do？

某地区某类房地产1998～2004年价格见下表。
某类房地产1998～2004年价格 (单位：元/m2)
根据直线趋势法，预测该地区该类型房地产2005年的价格为()元/m2。