|
发信人: reynolds(雷龙.DBA中) 整理人: reynolds(2002-04-01 14:28:20), 站内信件 |
| 41. You are the administrator of an SQL Server 2000 computer. The server contains a database named ResearchRecords. This database contains research records and administrative records. The database consumes about 30GB of disk space. The data files are configured as shown below:
Database files File Name Location Space Allocated (MB) Filegroup MedicalRecords_data E:\Program Files\Micro… 10000 PRIMARY MedicalRecords_data F:\data\MedicalRecords 10000 PRIMARY MedicalRecords_data G:\ProgramFiles\Micro… 20000 PRIMARY You run full database backups each night after business hours. You notice that the backup is not complete by the time the morning shift begins to use the database. You need to minimize the time needed to restore data in the event of a system failure. You also want to reconfigure the database to allow the backups to complete during the evening hours. Which two actions should you take? (Each correct answer presents part of the solution. Choose two) A. Reorganize the data files into two groups. Place the system tables in the PRIMARY filegroup and the user-defined tables in the other filegroup. B. Reorganize the data files into three groups. Place the system tables and shared objects in the PRIMARY filegroup, the clinical records in a filegroup, and the administrative records in a filegroup, and the administrative records in a filegroup. C. Reorganize the data files into three groups. Place the system, tables in the PRIMARY filegroup, the indexes in a filegroup, and the tables in the other filegroup. D. Back up the transaction log each night. Run a filegroup backup on a different filegroup each night. E. Back up the transaction log each night. Run a filegroup backup on the database each weekend. F. Back up the transaction log each night. Run a differential backup each Sunday, and run a full backup the first day of each month. Answer: C D Reason: 索引单独存放在一个文件组有利于提高效率。 ====================================================================== 在文件组上放置索引 默认情况下，索引创建在基表所在的文件组上，该索引即在该基表上创建。不过，可以在不同于包含基表的文件组的其它文件组上创建非聚集索引。通过在其它文件组上创建索引，可以在文件组通过自带的控制器使用不同的物理驱动器时实现性能提升。这样一来，数据和索引信息即可由多个磁头并行读取。例如，如果文件组 f1 上的 Table_A 和文件组 f2 上的 Index_A 都由同一个查询使用，就可无争夺地充分利用这两个文件组，因此可以实现性能提升。但是，如果 Table_A 由查询扫描而没有引用 Index_A，则只利用文件组 f1，因而未实现性能提升。 ====================================================================== 42. You are the administrator of several SQL Server 2000 computers. You want to retrieve information from an archived inventory database. You have a full tape backup of the database. The backup’s header information shows that the backup uses the SQL_Latin1_General_CR437_BIN collation. However, the existing SQL server computers in your office are configured to use the SQL_Latin1_General_CP1_CI_AS collation. You do not want to join tables in the inventory database with tables in other databases. You need to restore the inventory database to a SQL Server 2000 computer by using the least amount of administrative effort. What should you do? A. Use the rebuildm utility to rebuild the system database on an existing SQL server computer. Configure all the databases on that server to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the server. B. Restore the inventory database to an existing SQL server computer. Accept the SQL_Latin1_General_CR437_BIN collation for that database. C. Install a new named instance of SQL Server 2000 on an existing SQL Server 2000 computer. Configure the named instance to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the named instance. D. Install SQL Server 2000 on a new computer. Configure the new server to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the new server. Answer: B Reason: SQL 2K可以在恢复的时候进行代码转换。 43. You are the administrator of an SQL Server 2000 computer. The server contains a database named Sales. The database is configured as shown below: See http://www.cheet-sheets.com/228/image7.jpg 
In the last six months, the database has grown by 3 GB. Users report that query response time has slowed. The options set the database are shown in the database options exhibit. Click the exhibit button (exhibit not available). You want to accelerate query response time. What should you do? A. Update the database statistics. B. Add indexes to the foreign key fields. C. Truncate the transaction log. D. Run the Database Maintenance Plan Wizard. E. Drop primary keys from all tables. Answer: B Reason: 外键关联。 44. You are the administrator of an SQL Server 2000 computer. The server contains a database named Sales that has two database files and one transaction log file. Each data file is located on its own hard disk and exists in its own filegroup. You perform full database, differential, and transaction log backups on a regular basis. All backups made during a single week are striped across three disk backup devices. A portion of the header information for the current week’s backups is shown in the following table: Backup Name Backup Type BackupFinishDate sales_db_10000625 1 2000-06-25 11:57:04.000 sales_t1_10000626_1 2 2000-06-26 11:04:12.000 sales_t1_10000626_2 2 2000-06-26 15:04:23.000 sales_df_20000426 5 2000-06-26 21:15:41.000 On June 28, 2000, at 1:47 P.M, the hard disk that contains the PRIMARY filegroup fails. You want to recover as much data as possible. What should you do? (Each correct answer presents part of solution. Choose two) A. Backup the transaction log by using the NO_LOG option. B. Backup the transaction log by using the NO_TRUNCATE option. C. Restore the most recent full database backup. D. Restore the most recent differential backup. E. Restore all differential backups in sequence. F. Restore all transaction log backups in sequence. G. Restore all transaction logs once the most recent differential backup. Answer: C D Reason: 迷惑的东西太多了，自己要小心。 45. You are the database administrator for a legal 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 and the account information: 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. Answer: B Reason: ---- / <>< o /| / <>< (o / |/| ) ) <@ < ( O )( \ |\| <>< ) <>< () \| \ \ 每天在网易游水的鱼 |
|
[关闭][返回] |