Cover image for MCDBA SQL Server 7 test yourself practice exams : exams 70-028 and 70-029
Title:
MCDBA SQL Server 7 test yourself practice exams : exams 70-028 and 70-029
Publication Information:
Berkeley, Calif. : Osborne/McGraw-Hill, [2000]

©2000
Physical Description:
xxxiv, 604 pages : illustrations ; 24 cm
Language:
English
Title Subject:
ISBN:
9780072121810
Format :
Book

Available:*

Library
Call Number
Material Type
Home Location
Status
Item Holds
Searching...
QA76.3 .M327 2000 Adult Non-Fiction Central Closed Stacks
Searching...

On Order

Summary

Summary

A typist uncovers a man's body from behind the sofa...

As instructed, stenographer Sheila Webb let herself into the house at 19 Wilbraham Crescent. It was then that she made a grisly discovery: the body of a dead man sprawled across the living room floor.

What intrigued Poirot about the case was the time factor. Although in a state of shock, Sheila clearly remembered having heard a cuckoo clock strike three o'clock. Yet, the four other clocks in the living room all showed the time as 4.13. Even more strangely, only one of these clocks belonged to the owner of the house...


Table of Contents

Forewordp. iii
About the Contributorsp. vii
Acknowledgmentsp. ix
Prefacep. xv
Introductionp. xix
Part I SQL Server 7.0 Administration (Exam 70-028)
SQL Server 7.0 Administration Questionsp. 3
Microsoft SQL Server 7.0 Overviewp. 4
Capacity and Growth Planning for a SQL Databasep. 17
Planning Database and Server Securityp. 25
Planning for Installationp. 34
Installing SQL Serverp. 41
Configuring SQL Serverp. 48
Monitoring and Tuning SQL Serverp. 53
Managing Database Filesp. 60
Managing Securityp. 67
Automating Administrative Tasksp. 75
Backing Up Databasesp. 82
Methods of Restoring Databasesp. 93
Transferring Datap. 103
Replicationp. 116
Implementing Replication Scenariosp. 125
Setting Up Replicationp. 130
SQL Server 7.0 Administration Answersp. 135
Microsoft SQL Server 7.0 Overviewp. 136
Capacity and Growth Planning for a SQL Databasep. 146
Planning Database and Server Securityp. 154
Planning for Installationp. 163
Installing SQL Serverp. 172
Configuring SQL Serverp. 180
Monitoring and Tuning SQL Serverp. 184
Managing Database Filesp. 190
Managing Securityp. 194
Automating Administrative Tasksp. 200
Backing Up Databasesp. 205
Methods of Restoring Databasesp. 217
Transferring Datap. 223
Replicationp. 232
Implementing Replication Scenariosp. 239
Setting Up Replicationp. 243
Part II SQL Server 7.0 Designing and Implementing Databases (Exam 70-029)
SQL Server 7.0 Database Design Questionsp. 251
Transact-SQL Overviewp. 252
Creating and Managing Files and Databasesp. 258
Developing a Logical Data Modelp. 262
Planning and Creating Indexesp. 277
Queriesp. 288
Summarizing Datap. 304
Managing Transactions and Locksp. 316
Implementing Viewsp. 320
Implementing Stored Proceduresp. 335
Implementing Triggersp. 347
Working with Distributed and External Datap. 352
SQL Server 7.0 Database Design Answersp. 357
Transact-SQL Overviewp. 358
Creating and Managing Files and Databasesp. 361
Developing a Logical Data Modelp. 364
Planning and Creating Indexesp. 373
Queriesp. 381
Summarizing Datap. 389
Managing Transactions and Locksp. 397
Implementing Viewsp. 402
Implementing Stored Proceduresp. 410
Implementing Triggersp. 419
Working with Distributed and External Datap. 422
Part III Practice Exams
Test Yourself: Administration Practice Exam 1 (Exam 70-028)p. 429
Administration Practice Exam 1 Test Yourself Questionsp. 430
Administration Practice Exam 1 Test Yourself Answersp. 448
Test Yourself: Administration Practice Exam 2 (Exam 70-028)p. 465
Administration Practice Exam 2 Test Yourself Questionsp. 466
Administration Practice Exam 2 Test Yourself Answersp. 485
Test Yourself: Database Design Practice Exam 1 (Exam 70-029)p. 503
Database Design Practice Exam 1 Test Yourself Questionsp. 504
Database Design Practice Exam 1 Test Yourself Answersp. 523
Test Yourself: Database Design Practice Exam 2 (Exam 70-029)p. 539
Database Design Practice Exam 2 Test Yourself Questionsp. 540
Database Design Practice Exam 2 Test Yourself Answersp. 558
About the Web Sitep. 575
Access Global Knowledgep. 576
What You'll Find Therep. 576
Glossaryp. 577