考试网 >> IT认证 >> 微软 >> MCSE模拟题 >> MCSE模拟试题：SQLServer考题

发布时间：2006-06-28 03:59     点击：

   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

    Answer: Windows NT Performance Monitor

    You are the SQL Server 7.0 administrator for your company. You want to identify all errors in the SALES database, but repair only the allocation errors, Which two of the following statements should you issue to identify all errors and repair only all allocation errors?(Choose TWO Answers)

发表评论： 匿名发表 用户名: 查看评论

您将承担一切因您的行为、言论而直接或间接导致的民事或刑事法律责任 留言板管理人员有权保留或删除其管辖留言中的任意内容 本站提醒：不要进行人身攻击。谢谢配合。