微软认证模拟试题：SQLServer考题[2]
x" i2 ~1 K' X1 Jraloffice. 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:( Q7 ~' y7 F& c) X
Answer: Windows NT Performance Monitor9 y5 C L0 m) N- x. i2 ~2 a
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)
2 a5 {# |& k& fAnswer:% ]% p/ S: a5 C/ M
DBCCCHECKDB(‘sal es?& DBCC CHECKALLOC ?`sales’REPAIR_ALLOW_DATA_LOSS ?/P> 5 h- c3 \# r/ O+ [& J& R [
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?
# x+ U' l$ S: c0 S" rA. Connect event, execution plan event, service control event, SQL username, NT user name.
4 y* f- H' }! p1 fB. Attention event, exec prepared sql event, sql username, NT user name% p4 a+ q, s: T S. ~0 s% t
C. Connect event, disconnect event, existingconnection event, NT user name" `2 {6 y" N3 Y3 w8 [& G# y3 F
D. Object: opened event, sql user name, NT user name.
% T; V$ P7 f# gAnswer: D
& ~4 y) F3 s7 f& B7 bThe departmental server has Full Text search implemented on its SQL server database. Currently both the Full Text database and the database files reside |
发表于 2012-8-3 00:09:22
