|
发信人: reynolds(雷龙.DBA中) 整理人: reynolds(2002-07-03 10:32:11), 站内信件 |
| 76. You are the administrator of a SQL Server 2000 computer. The server contains a database named Sales. Your company deploys an upgraded version of a customer relationship management application, which accesses the sales database.
The sales database contains a table named Customer, which stores information about your company’s customers. Users report that they cannot delete information in the CustomerAddress2 column. The Customer table is configured as shown below: Table Design Name Customers Owner dbo CreateDate 8/25/2000 10:42:06 a.m Filegroup PRIMARY Rows 1 Columns Key ID Name Data Type Size Nulls CustomerID int 4 CustomerName varchar 50 CustomerAddress varchar 50 CustomerAddress2 varchar 50 CustomerCity varchar 50 Y CustomerState char 2 CustomerZip char 10 You use SQL Profiler to capture the activity of the application and receive the results shown below: Event Class Text Data Application Name Audit Login ----Nework protocol---- Visual Basic SQL:Batch Completed Update Customer se… Visual Basic You want to configure the Customer table to support the upgraded application. What should you do? A. Alter the table to allow null values in the CustomerAddress2 column. B. Alter the data type of the CustomerAddress2 column to sql_varient. C. Create an UPDATE trigger that changes a null value in the CustomerAddress2 column to an empty string. D. Use an INSTEAD OF trigger to change the value of the CustomerAddress2 column to an empty string whenever the column’s value is null. Answer: A Reason: 好像没有什么可以解释的吧。 77. You are the administrator of a SQL Server 2000 computer. You import a large amount of data into the contracts database. After the import, you perform a full database backup. You examine the hard disk and discover that the log file has grown from 200MB to 800MB. You want to recover disk space as quickly as possible without losing backup information. Which two Transact-SQL statements should you execute? (Each correct answer present s part of the solution. Choose two) A. BACKUP LOG Contracts WITH no_log B. BACKUP LOG Contracts WITH truncate_only C. BACKUP LOG Contracts TO disk= ‘E: \SQLBackup\Contracts_Log.bkp’ D. ALTER DATABASE Contracts (Name= Contract_Log.ldf, FILENAME= ‘E: \Data\Contracts_ldf’SIZE= 200) E. DBCC ShrinkDatabase (Contracts, 200) F. DBCC ShrinkFile (Contracts_Log, 200) Answer: C F Reason: 我第一次看到这个题目的时候选择错误了，我选择了B。结果发现要选择2个答案，显然我没有仔细看题目，这道题目要求不丢失备份信息，因此在没有Full Backup的选项的时候，我的答案是错误的。 78. You are the administrator of two Microsoft Windows 2000 Advanced Server computers. On these servers, you are configuring a database that will store accounting information for your company. The data must be available at all times. Interruptions in data connectivity should not last longer than five minutes. Any changes to the database should not require you to reconfigure the client computers. How should you configure the database? A. Configure the database on the two servers as a SQL Server 2000 cluster. B. Configure the database on one server, and then configure a standby database on the second server. C. Configure the database on each server. Use Microsoft Distributed Transaction Coordinator to keep the two servers perfectly synchronized. D. Configure the database as a federated database, and then partition half the data on each server. Answer: A Reason: 其实A B都是可行的冗余方案，但是题目要求不修改客户端配置，所以... 79. You are the administrator of a SQL Server 2000 computer. The server contains a database named Contracts. The server is configured as shown below: See http://www.cheet-sheets.com/228/image11.jpg 
The database files in Contracts are configured as shown below: File Name Location Initial Size (MB) File group Contracts_data E:\data\contracts_data 2000 PRIMARY Contracts_data2 E:\data\contracts_data2 2000 SECONDARY 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. Answer: D Reason: 80. You are the administrator of a SQL Server 2000 computer. The server contains a database named Sales. The database will store sales transactions. Retail locations must be able to add transactions to the database 24 hours a day, every day. The server is configured as shown below: See http://www.cheet-sheets.com/228/image12.jpg 
You need to configure the data files and transaction log for the Sales database. What should you do? A. Place the transaction log on physical disk 0 and the data file on the RAID-5 disk array. B. Place the transaction log on the RAID-5 disk array and the data file on physical disk 0. C. Place the transaction log and the data file on physical disk 0. D. Place the transaction log and the data file on the RAID-5 disk array. Answer: D Reason: 原来选择的A，是考虑日志和数据分离为了提高数据库性能。但是题目并没有性能要求，而是要求7*24小时可用，所以改为D了。 ---- / <>< o /| / <>< (o / |/| ) ) <@ < ( O )( \ |\| <>< ) <>< () \| \ \ 每天在网易游水的鱼 |
|
[关闭][返回] |