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

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

    Answer:

    DBCCCHECKDB(‘sal es?& DBCC CHECKALLOC ?`sales’REPAIR_ALLOW_DATA_LOSS ?/P>

    You provide technical support to companies that use SQL Server 7.0. A customer reportsthat there is a problem, and you are asked to investigate it. You want to capture a trace inSQL server Profiler. What are the minimum permissions that you must have at thecustomer’s S QL Server co mput er t o be ab l e t o creat e and capt ure a Profil er traceAnswer: You must have the EXEC permission for the Profiler extended stored procedures.You are running a web site, you want accounting who is accessing specific tables. Whichshould you use performance monitor to monitor?

    A. Connect event, execution plan event, service control event, SQL username, NT user name.

    B. Attention event, exec prepared sql event, sql username, NT user name

    C. Connect event, disconnect event, existingconnection event, NT user name

    D. Object: opened event, sql user name, NT user name.

    Answer: D

    The departmental server has Full Text search implemented on its SQL server database. Currently both the Full Text database and the database files reside on the same logical drive. You do not want the Full Text indexing to use more than 25% of the available drive space because you want to allow space for dynamic expansion of the data files. You want to be able to remotely monitor the amount of space in use by the catalogs. How should you remotely monitor the space usage with a minimum number of additional administrative steps?

    A. Use the windows NT Performance Monitor to connect to the Server and to monitor the size of the Microsoft Search catalog

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

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