精品推荐
阅读排行
· 工程竣工验收报告· 大学生毕业自我鉴定
· 大学生自我鉴定7
· 大学毕业生自我鉴定
· 大学生学年自我鉴定
· 大学毕业生自我鉴定
· 师范生实习鉴定评语
· 给老师的一封感谢信
· 心理健康教育论文
· 黑板报设计图欣赏
| 作者：不明 来源：www.pccode.net 整理 发布时间：2007-1-24 15:21:18 发布人：wongrs | |||
|
Part 1 Your company’s S QL Server 7 . 0 dat abase i s backed dail y at m i dn i ght. One morni ng you load a large amount of data by using a nonlogged transaction. You then disable the selectinto/bulkcopy ption. What is the easiest way to restore the validity of the transaction logbackup sequence? A. Create a database backup. B. Truncate the transaction log. C. Backup the transaction log. D. Create a differential database backup. Answer: D You want to improve the performance of a SQL Server 7.0 database by distributing input/output operations across multiple physical disks. You know which tables and indexesare queried most frequently, and you want to place each of them on a separate disk. How canyou place each of the most frequently queried tables and indexes on its own separate disk?Answer: One each disk, create a filegroup consisting of a single file and place each table andindex in its own filegroup.You are planning to use SQL Server Profiler to debug and optimize queries and applicationsin SQL Server 7.0. You want to be able to use SQL Server query-processing tools analyze thedata captured by Profiler. Where should you save the event data that will be captured by the Profiler trace? A. In a text file B. In a Windows NT Application log C. In the trace definition file. D. In a SQL Server table Answer: D Notice: If you want to use SQL Server query processing tools to analyze the captured data, thenyou should save the event data to a table.You must perform multiple identical installations of SQL Server 7.0 in remote branches ofyour company that are not connected to the central office. The network administrators in thebranches have not been trained to install SQL Server 7.0. How can you facilitate theinstallations so that most of the work will be done automatically?Answer: Run SQL Server Setup interactively to install SQL Server on a computer in the centraloffice. During installation, assign the MSSQLServer and SQLServerAgent services to the localsystem user account Send the iss file to the branches.Your Company is using Sql Server 7.0 store corporate business data on a Windows NT Server computer. To assess disk space requirements and to optimize disk space usage you want to know how often new data is record in database, what tool will provide you with information about the frequency of write operations: Answer: Windows NT Performance Monitor You are the
|