Databases Reference
In-Depth Information
ASSESS YOUR UNDERSTANDING
Go to
www.wiley.com/college/gillenson
to assess your knowledge of ways to
improve data access.
Measure your learning by comparing pre-test and post-test results.
Summary Questions
1.
A perceived hardware performance problem can sometimes mask a
problem with a different hardware component. True or False?
2.
Normalization has no impact on data access or database performance.
True or False?
3.
Which of the following would you use to capture SQL Server activity?
(a)
SQL Server Profiler
(b)
System Monitor
(c)
Performance Monitor
(d)
Database Engine Tuning Advisor
4.
Excessive virtual memory paging is typically caused by which of the
following?
(a)
a hard disk that is too slow
(b)
an overworked hard disk
(c)
too little system memory
(d)
too slow of a processor
5.
What is usually the best solution for memory bottlenecks?
(a)
install a faster hard disk
(b)
increase available disk space
(c)
install a faster processor
(d)
install more RAM memory
6.
On a Windows XP computer running SQL Server 2005, which of the fol-
lowing would you use to observe real-time hardware performance?
(a)
SQL Profiler
(b)
Database Engine Tuning Advisor
(c)
System Monitor
(d)
alerts
7.
When is the best time to collect baseline performance data?
(a)
before installing SQL Server
(b)
before the database application goes live
