You are the administrator of a SQL Server 2000 computer. The server contains a database na

You are the administrator of a SQL Server 2000 computer. The server contains a database named sales. You need to change the way customer Ids appear in the Customers table. The database schema is shown in the exhibit.

You need to automate the process of updating the primary key tools. You also want to minimize records locks and administration within the database during the update process.

What should you do?

A.Add an ON UPDATE CASCADE constraint to the CustomerID field in the Customers table. Modify the values in the CustomerID field in the Customers table.

B.Create a duplicate record that has a new CustomerID value. Update the foreign key fields in the invoices, contacts, and quotes tables with the new value.

C.Disable the FOREIGN KEY constraints. Within a transaction, modify the values in the CustomerID field in the Customers table and all related foreign key values in the invoices, contacts, and quotes tables. Re-enable the FOREIGN KEY constraints after the keys are changed.

D.Create a Data Transformation Services package. Use the package to transform. the CustomerID value and the values of the related foreign keys in the invoices, contacts, and quotes tables.

  • 悬赏:0 答案豆
  • 提问人:00****29
  • 发布时间:2013-01-08
您可能感兴趣的试题
1
You are the database administrator for a financial services company. Employees enter data 24 hours a day into a SQL Server 2000 database. These employees report slower response times when new account information is gathered from branch offices and added to the database. You currently use the following BULK INSERT statement to add the account information: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?

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.

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

3
You are the administrator of a SQL Server 2000 computer. The server contains a database named Customers, which is used by a custom client/server application.The database contains more than 1 million rows. Users report that the database responds slowly when they search for customers by using the application. Users search for customers by scrolling through an alphabetical list of customer names.You use SQL profiles to capture information about how the application uses the database.You receive results as shown in the following screen shot.You need to improve the application’s performance. What should you do?

A.Create additional nonclustered indexes on the CustomerInformation table.

B.Rewrite the application so that it uses a user-defined function to return the customer list.

C.Rewrite the application so that it uses a query with a WHERE clause to search for customer names.

D.Rewrite the application so that is uses a stored procedure to return the customer list.

4
You are the administrator of a SQL Server 2000 computer. The server contains a database named Contracts. The server is configured as shown in the server configuration exhibit.The database files are configured as shown in the database properties exhibit.The database developers have been creating new tables and indexes without specifying a filegroup.The primary filegroup is reaching its maximum capacity.You want the developers to continue adding new objects, but you do not want then to change the way they create objects. You do not want to run out of disk space. You also want to minimize the time it takes to administer the database.What should you do?

A.Back up the existing objects on the PRIMARY filegroup. Drop them from the database. Re-create them on the SECONDARY filegroup.

B.Set the file growth on the PRIMARY filegroup to UNLIMITED.

C.Set the PRIMARY filegroup so that it is read-only.

D.Set the SECONDARY filegroup as the default filegroup.

继续查找其他问题的答案?

请先输入下方的验证码查看最佳答案

图形验证:看不清?点击更换 换一换
免验证查看
  • 49.8

    ¥75 每天只需0.6元
    3个月 推荐
  • 39.8

    ¥60
    1个月
  • 99.8

    ¥150
    1年

选择支付方式

  • 微信付款
  • 支付宝付款
郑重提醒:支付后,系统自动为您完成注册

请使用微信扫码支付(元)

订单号:
支付后,系统自动为您完成注册
遇到问题请联系在线客服

恭 喜 您 获 得
扫 码 免 费 领 取
会 员 或 搜 题 次 数
本弹窗关闭将不再弹出
请不要关闭本页面,支付完成后请点击【支付完成】按钮
遇到问题请联系在线客服
常用手机号:
用于找回密码
图片验证码:
看不清?点击更换
短信验证码:
新密码:
 
扫码看答案