Multiple Choice
Which of the following best defines a trace?
A) a graphical interface that enables a database administrator to capture events
B) the result set of database events captured by SQL Server Profiler
C) any activity executed by the SQL Server database engine
D) used to monitor activity of the physical resources that are managed by the operating system
Correct Answer:
Verified
Correct Answer:
Verified
Q1: How are requests to use a particular
Q3: What are two major design factors that
Q4: Which counter indicates the number of requests
Q5: List three query design guidelines that can
Q6: Which command takes corrective action on a
Q7: How does external fragmentation occur?
Q8: What is a deadlock and how does
Q9: Which of the following is a valid
Q10: A(n)_ is always created for the primary
Q11: Indexes prevent the database engine from having