McDba SQL Server 7 Test Yourself Practice Exams: (Exams 70-028 and 70-029)

by Syngress Media, Inc.

• ISBN13: 9780072121810
• ISBN10: 0072121815
• Edition: 1st
• Format: Paperback
• Copyright: 2000-02-01
• Publisher: Osborne McGraw-Hill

Summary

With a new and expanded Test Yourself format, this guide gives full coverage of both SQL Server 7 Database Administration and SQL Server 7 Database Design official exam objectives. More than 800 sample exam questions are provided with in-depth answers. Exam Watch warnings point out troublesome questions and issues and show readers how to be prepared.

Table of Contents

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)
Installing SQL Server	41	(7)
Configuring SQL Server	48	(5)
Monitoring and Tuning SQL Server	53	(7)
Managing Database Files	60	(7)
Managing Security	67	(8)
Automating Administrative Tasks	75	(7)
Backing Up Databases	82	(11)
Methods of Restoring Databases	93	(10)
Transferring Data	103	(13)
Replication	116	(9)
Implementing Replication Scenarios	125	(5)
Setting Up Replication	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)
Installing SQL Server	172	(8)
Configuring SQL Server	180	(4)
Monitoring and Tuning SQL Server	184	(6)
Managing Database Files	190	(4)
Managing Security	194	(6)
Automating Administrative Tasks	200	(5)
Backing Up Databases	205	(12)
Methods of Restoring Databases	217	(6)
Transferring Data	223	(9)
Replication	232	(7)
Implementing Replication Scenarios	239	(4)
Setting Up Replication	243	(8)
PART II SQL Server 7.0 Designing and Implementing Databases (Exam 70-029)
SQL Server 7.0 Database Design Questions	251	(106)
Transact-SQL Overview	252	(6)
Creating and Managing Files and Databases	258	(4)
Developing a Logical Data Model	262	(15)
Planning and Creating Indexes	277	(11)
Queries	288	(16)
Summarizing Data	304	(12)
Managing Transactions and Locks	316	(4)
Implementing Views	320	(15)
Implementing Stored Procedures	335	(12)
Implementing Triggers	347	(5)
Working with Distributed and External Data	352	(5)
SQL Server 7.0 Database Design Answers	357	(72)
Transact--SQL Overview	358	(3)
Creating and Managing Files and Databases	361	(3)
Developing a Logical Data Model	364	(9)
Planning and Creating Indexes	373	(8)
Queries	381	(8)
Summarizing Data	389	(8)
Managing Transactions and Locks	397	(5)
Implementing Views	402	(8)
Implementing Stored Procedures	410	(9)
Implementing Triggers	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)
About the Web Site	575	(2)
Access Global Knowledge	576	(1)
What You'll Find There	576	(1)
Glossary	577