题目内容

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.

查看答案

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

更多问题

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.

查看答案

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？

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.

查看答案

鲁迅小说《风波》收入()

A. 《呐喊》
B. 《故事新编》
C. 《彷徨》
D. 《坟》

查看答案

房地产的实物，是指房地产中看得见、摸得着的部分，即有形的实体。

A. 正确
B. 错误

查看答案