|
发信人: reynolds(雷龙.DBA中) 整理人: reynolds(2002-04-02 10:28:57), 站内信件 |
| 16. You are the administrator of a SQL Server 2000 computer. You have two new hard disks on which you will create a database named Inventory. You want to insert, update, and delete data as quickly as possible.
Which two actions should you take? (Each correct answer presents parts of the solution. Choose two) A. Configure the hard disks as two mirrored NTFS volumes. B. Configure the hard disks as one mirrored NTFS volume. C. Configure the hard disks as two independent NTFS volumes. D. Configure the hard disks as one extended NTFS volumes. E. Place inventory_data.mdf on the first volume and inventory_log.idf on the second volume. F. Place inventory_data.mdf on the first volume and inventory_data2.ndf and inventory_log.idf on the second volume. G. Place inventory_data.mdf and inventory_log.idf on the same volume. Answer: C E Reason: 数据库和事务日志分离是有利于存取速度的。当然利用RAID技术也可以，但是本题目没有涉及到该技术，所以不在讨论之列。 17. You are the administrator of a SQL Server 2000 database. You import a table of geographic information from a Microsoft Access database into a SQL Server 2000 database. The table has 12,000 rows. Each row averages 5,000 bytes. The table contains lookup data that does not change. You want to minimize the size of the data file and the time required to back up the data. Which two actions should you take? (Each correct answer presents part of the solution. Choose two) A. Create a 60-MB data file named geography.ndf B. Create a 95-MB data file named geography.ndf C. Create a 60-MB data file named geography.mdf D. Create a 95-MB data file named geography.mdf E. Place the table in the PRIMARY firegroup. F. Place the table in a new firegroup named LOCATION. Answer: B F（有答案说是AF） Reason: 大小的测算我是这样考虑的，一个页8K，不够8K的数据也占用8K，那么12000条记录，占用8*12000/1024=93.75M，再加上表结构数据，约95M，这个可以参考《联机帮助手册》的创建和维护数据库-数据库-数据库设计和考虑事项-估计数据库的大小-估计表的大小这一章节。 至于在新文件组中放置新的数据库可以提高性能一说，参见《联机帮助手册》的优化数据库性能-数据库设计-物理数据库设计-使用文件组防止数据-在文件组上放置表这一章节。 18. 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 below: See http://www.cheet-sheets.com/228/image4.jpg 
You need to automate the process of updating the primary key tools. You also want to minimize record 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. Answer: A Reason: 已经具备关联的数据库，利用CASCADE子句就可以了。 19. You are the administrator of two SQL Server 2000 computers. One of these servers contains a 4-GB database named Marketing. You want to remove the Marketing database from one server and add it to the other as quickly as possible. What should you do? A. Detach the database from the original server by using the sp_detach_db stored procedure. Copy the database and the transaction log files to the new server, and attach them by using the sp_attach_db stored procedure. B. Use the DTS export wizard to transfer all database objects from the original server to the new server. Drop the database from the original server. C. Run a full backup of the database on the original server. Create a new database named Marketing on the new server. Restore the backup in the new Marketing database. Drop the database from the original server. D. Shut down the original server. Copy the database and the transaction log files to the new server. Use the DISK INIT and DISK REFIT statements to attach the data file to the new server. Drop the database from the original server. Answer: A Reason: ====================================================================== 答案A：指定要附加的数据库的 MDF（master 数据文件）名称。最多可以指定 16 个文件名。如果指定 16 个以上的文件，则 Microsoft SQL Server 不能附加数据库。有关附加数据库的更多信息，请参见 sp_attach_db。 答案B：许多单位都需要将数据集中以改进企业决策制订。但是，他们的数据可能以各种格式保存并分布在不同的位置。数据转换服务 (DTS) 通过提供一组工具，使您得以将来自完全不同的源的数据析取、转换和合并到 DTS 连通性所支持的单个或多个目的，以满足这些重要的商业需求。通过使用 DTS 工具图形化地生成 DTS 包或使用 DTS 对象模型编制包，可创建适合您单位的特殊商业需要的自定义数据移动解决方案。 DTS并非数据恢复的理想选择，DTS大量数据往往涉及大量的带宽和系统资源。 ====================================================================== 20. You are the administrator of a SQL Server 2000 computer. The server contains a database that stores financial data. You want to use data transformation services packages to import numeric data from other SQL server computers. The precision and scale values of this data are not defined consistently on the other servers. You want to prevent any loss of data during the import operations. What should you do? A. Use the ALTER COLUMN clause of the ALTER TABLE statement to change data types in the source tables. Change the data types so that they will use the lowest precision and scale values of the data that will be transferred. B. Use the ALTER COLUMN clause of the ALTER TABLE statement to change data types in the destination tables. Change the data types to reflect the highest precision and scale values involved in data transfer. C. Set a flag on each DTS transformation to require an exact match between source and destination columns. D. Set the maximum error count for each DTS transformation task equal to the number of rows of data you are importing. Use an exception file to store any rows of data that generate errors. E. Write Microsoft ActiveX scripts for each DTS transformation. Use the scripts to recast data types to the destinations precision and scale values. Answer: B Reason: C D E都是不可行的。A和B类似，但是要注意的是，修改源数据库不符合题意。 ---- / <>< o /| / <>< (o / |/| ) ) <@ < ( O )( \ |\| <>< ) <>< () \| \ \ 每天在网易游水的鱼 |
|
[关闭][返回] |