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

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

    B. Create a scheduled job to regularly monitor the size of the Full Text indexes and send the result to your E-MAIL address

    C. Create a batch file to monitor the size of Full Text indexes and send the result to you viaNetwork Message. Use the Windows NT Scheduler Service to schedule the batch file to run

regularly

    D. Create a batch file to monitor the size of the Full Text indexes and send the result to you via Network Message. Create a scheduled job to run the batch file regularly.

    Answer: A

    You are a SQL Server 7.0 system administrator for you company. To provide users with Full Text search capabilities, you create a Full Text catalog and enable Full Text indexing for specific tables in a database. From your Windows NT Workstation computer, you want to remotely monitor the size of the Full Text catalog on Windows NT server computer that is running SQL Server. Which of the following tools is the most convenient to use for monitor the Full Text catalog?

    A. Performance Monitor

    B. Query Analyzer

    C. The SP_MONITOR system stored procedure

    D. SQL Server Profiler.

    Answer: A

    Notice: To obtain real-time information about the size of a specific full-text catalog, you can continuously monitor the appropriate instance of the Microsoft search Indexer Catalogs You load a lot data into your database, then you find that the space for log is almost full, how can you do to ensure the restore: (Choose all that apply)

    A. Make a full backup

    B. Make a differential backup

    C. Backup the transaction log with the default options

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

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