| Forword |
|
iii | |
| About the Contributors |
|
vii | |
| Acknowledgments |
|
ix | |
| Preface |
|
xv | |
| Introduction |
|
xix | |
| Part I SQL Server 7.0 Administration (Exam 70--028) |
|
|
SQL Server 7.0 Administration Questions |
|
|
3 | (132) |
|
Microsoft SQL Server 7.0 Overview |
|
|
4 | (13) |
|
Capacity and Growth Planning for a SQL Database |
|
|
17 | (8) |
|
Planning Database and Server Security |
|
|
25 | (9) |
|
Planning for Installation |
|
|
34 | (7) |
|
|
|
41 | (7) |
|
|
|
48 | (5) |
|
Monitoring and Tuning SQL Server |
|
|
53 | (7) |
|
|
|
60 | (7) |
|
|
|
67 | (8) |
|
Automating Administrative Tasks |
|
|
75 | (7) |
|
|
|
82 | (11) |
|
Methods of Restoring Databases |
|
|
93 | (10) |
|
|
|
103 | (13) |
|
|
|
116 | (9) |
|
Implementing Replication Scenarios |
|
|
125 | (5) |
|
|
|
130 | (5) |
|
SQL Server 7.0 Administration Answers |
|
|
135 | (116) |
|
Microsoft SQL Server 7.0 Overview |
|
|
136 | (10) |
|
Capacity and Growth Planning for a SQL Database |
|
|
146 | (8) |
|
Planning Database and Server Security |
|
|
154 | (9) |
|
Planning for Installation |
|
|
163 | (9) |
|
|
|
172 | (8) |
|
|
|
180 | (4) |
|
Monitoring and Tuning SQL Server |
|
|
184 | (6) |
|
|
|
190 | (4) |
|
|
|
194 | (6) |
|
Automating Administrative Tasks |
|
|
200 | (5) |
|
|
|
205 | (12) |
|
Methods of Restoring Databases |
|
|
217 | (6) |
|
|
|
223 | (9) |
|
|
|
232 | (7) |
|
Implementing Replication Scenarios |
|
|
239 | (4) |
|
|
|
243 | (8) |
| PART II SQL Server 7.0 Designing and Implementing Databases (Exam 70-029) |
|
|
SQL Server 7.0 Database Design Questions |
|
|
251 | (106) |
|
|
|
252 | (6) |
|
Creating and Managing Files and Databases |
|
|
258 | (4) |
|
Developing a Logical Data Model |
|
|
262 | (15) |
|
Planning and Creating Indexes |
|
|
277 | (11) |
|
|
|
288 | (16) |
|
|
|
304 | (12) |
|
Managing Transactions and Locks |
|
|
316 | (4) |
|
|
|
320 | (15) |
|
Implementing Stored Procedures |
|
|
335 | (12) |
|
|
|
347 | (5) |
|
Working with Distributed and External Data |
|
|
352 | (5) |
|
SQL Server 7.0 Database Design Answers |
|
|
357 | (72) |
|
|
|
358 | (3) |
|
Creating and Managing Files and Databases |
|
|
361 | (3) |
|
Developing a Logical Data Model |
|
|
364 | (9) |
|
Planning and Creating Indexes |
|
|
373 | (8) |
|
|
|
381 | (8) |
|
|
|
389 | (8) |
|
Managing Transactions and Locks |
|
|
397 | (5) |
|
|
|
402 | (8) |
|
Implementing Stored Procedures |
|
|
410 | (9) |
|
|
|
419 | (3) |
|
Working with Distributed and External Data |
|
|
422 | (7) |
| PART III Practice Exams |
|
|
Test Yourself: Administration Practice Exam 1 (Exam 70-028) |
|
|
429 | (36) |
|
Administration Practice Exam 1 Test Yourself Questions |
|
|
430 | (18) |
|
Administration Practice Exam 1 Test Yourself Answers |
|
|
448 | (17) |
|
Test Yourself: Administration Practice Exam 2 (Exam 70-028) |
|
|
465 | (38) |
|
Administration Practice Exam 2 Test Yourself Questions |
|
|
466 | (19) |
|
Administration Practice Exam 2 Test Yourself Answers |
|
|
485 | (18) |
|
Test Yourself: Database Design Practice Exam 1 (Exam 70-029) |
|
|
503 | (36) |
|
Database Design Practice Exam 1 Test Yourself Questions |
|
|
504 | (19) |
|
Database Design Practice Exam 1 Test Yourself Answers |
|
|
523 | (16) |
|
Test Yourself: Database Design Practice Exam 2 (Exam 70-029) |
|
|
539 | (36) |
|
Database Design Practice Exam 2 Test Yourself Questions |
|
|
540 | (18) |
|
Database Design Practice Exam 2 Test Yourself Answers |
|
|
558 | (17) |
|
|
|
575 | (2) |
|
|
|
576 | (1) |
|
|
|
576 | (1) |
| Glossary |
|
577 | |
