题目内容

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. 错误

查看答案

唐代边塞的代表作家是()

A. 岑参与高适
B. 李白与杜甫
C. 王维与孟浩然
D. 李华与萧颖士

查看答案