题目内容

You are the administrator of several SQL Server 2000 computers. A data Transformation Services (DTS) package uses native OLE DB providers to transfer data between the servers. Connection details for the servers are specified in .udl files. The .udl files are frequently updated as connection details change.
You want to distribute the DTS package as a file to developers in your company. You want to make sure connection details are available to developers who receive the DTS package.
Which two tasks should you perform？ (Each correct answer presents part of the solution. Choose two)

A. Enable the Always read properties from UDL file option in the Connection Properties dialog box.
B. Disable the Always read properties from UDL file option in the Connection Properties dialog box.
C. Delete the .udl files and store connection details in the registry by using system data source names.
Delete the .udl files, and store connection details in the registry by using user data source names.
E. Make the .udl files available on a network share.

查看答案

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

更多问题

由于房地产具有独一无二性，所以房地产市场不具备替代性。

A. 正确
B. 错误

查看答案

基准地价、标定地价、房屋重置价格都是一种评估价值。

A. 正确
B. 错误

查看答案

某工程合同价款1000万元，建设单位未经竣工验收擅自交付使用，应处以()的罚款。

A. 10万～20万元
B. 15万～30万元
C. 20万～40万元
D. 20万～50万元

查看答案

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.

查看答案

由于房地产具有独一无二性，所以房地产市场不具备替代性。

基准地价、标定地价、房屋重置价格都是一种评估价值。

某工程合同价款1000万元，建设单位未经竣工验收擅自交付使用，应处以()的罚款。

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？

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？