Test Yourself Mcdba Sql Server Tm 2000 Administration (Exam 70-228) / Edition 2

Test Yourself Mcdba Sql Server Tm 2000 Administration (Exam 70-228) / Edition 2

by Stephen Giles, Glen Martin
     
 

ISBN-10: 0072134437

ISBN-13: 9780072134438

Pub. Date: 11/01/2001

Publisher: McGraw-Hill Companies, The

Don't let the real test be your first test! Osborne's Test Yourself MCDBA SQL Server 2000 Administration,Second Edition contains hundreds of practice questions for exam 70-228. The book is organized by official exam objective and contains in-depth answers that explain why the correct options are right and why the incorrect options are wrong.

Don't Let the Real

Overview

Don't let the real test be your first test! Osborne's Test Yourself MCDBA SQL Server 2000 Administration,Second Edition contains hundreds of practice questions for exam 70-228. The book is organized by official exam objective and contains in-depth answers that explain why the correct options are right and why the incorrect options are wrong.

Don't Let the Real Test Be Your First Test!

Practice Makes Perfect Score Higher With The Most Effective Self-Test & Quick Review Program More Questions—More Content

  • Based on Installing,Configuring,and Administering Microsoft SQL Server 2000 Enterprise Edition Exam (70-228)
  • Coverage features quick review of all technology objectives and realistic exam questions to build your knowledge
  • Exclusive "Exam Watch" features point out the most frequently missed questions—and how to answer them correctly

Product Details

ISBN-13:
9780072134438
Publisher:
McGraw-Hill Companies, The
Publication date:
11/01/2001
Series:
Microsoft Test Yourself Series
Edition description:
2ND
Pages:
464
Product dimensions:
7.50(w) x 9.25(h) x 0.94(d)

Table of Contents

About the Contributorsv
Acknowledgmentsvii
Prefacexv
Introductionxvii
1Installing SQL Server 20001
Installing SQL Server2
Questions3
Failover Clustering4
Questions6
Default Collation8
Questions10
Number of Instances11
Questions12
File Location13
Questions14
Service Account15
Questions17
Performing a Custom Upgrade to SQL Server 200018
Questions18
Upgrading to SQL Server 2000 from SQL Server 6.519
Questions20
Upgrading to SQL Server 2000 from SQL Server 7.021
Questions22
Lab Question24
Quick Answer Key25
In-Depth Answers26
Lab Answer36
2Configuring SQL Server 200039
Creating a Linked Server40
Questions44
Configuring SQL Mail and SQL Agent Mail45
Questions47
Configuring Network Libraries49
Questions51
Troubleshooting Failed Installations52
Questions55
Lab Question57
Quick Answer Key59
In-Depth Answers60
Lab Answer69
3Creating SQL 2000 Databases71
Creating and Altering Databases72
Questions76
Setting Database Options78
Questions81
Adding/Configuring Filegroups83
Questions86
Expanding and Shrinking Databases87
Questions89
Sizing and Placing the Transaction Log91
Questions92
Configuring Database Options for Performance95
Questions97
Attaching and Detaching Databases99
Questions101
Lab Question103
Quick Answer Key105
In-Depth Answers106
Lab Answer116
4Creating and Managing Database Objects119
Creating and Managing Basic Database Objects120
Creating and Managing Constraints122
Questions125
Creating and Managing Indexes126
Questions131
Creating and Managing Stored Procedures132
Questions134
Creating and Managing Triggers135
Questions136
Creating and Managing Views137
Questions139
Lab Question141
Quick Answer Key143
In-Depth Answers144
Lab Answer149
5Managing, Monitoring, and Troubleshooting SQL Server 2000 Databases151
Optimizing Database Performance152
Questions159
Optimizing Data Storage162
Questions164
Managing Database Schema165
Questions168
Lab Question170
Quick Answer Key171
In-Depth Answers172
Lab Answer175
6Backing Up, Restoring, and Recovering SQL 2000 Databases177
Recovering System State178
Questions181
Backing Up User Databases182
Questions187
Backing Up System Databases189
Questions191
Restoring User Databases192
Questions199
Restoring System Databases202
Questions204
Configuring, Maintaining, and Troubleshooting Log Shipping205
Questions207
Performing Integrity Checks208
Questions212
Troubleshooting Transactions and Locking212
Questions215
Lab Question216
Quick Answer Key217
In-Depth Answers218
Lab Answer227
7Extracting and Transforming Data with SQL Server 2000229
Using XML Support230
Questions234
Importing and Exporting Data with Data Transformation Services235
Questions238
Developing and Managing DTS Packages240
Questions242
Managing Linked Servers244
Questions246
Converting Data Types247
Questions249
Configuring, Maintaining, and Troubleshooting Replication Services251
Questions254
Lab Question255
Quick Answer Key256
In-Depth Answers257
Lab Answer262
8Managing and Monitoring SQL Server 2000 Security263
Configuring Security Modes264
Questions266
Creating and Managing Logons267
Questions271
Creating and Managing Database User Accounts273
Questions274
Adding and Removing Users from Fixed Roles276
Questions280
Creating Roles to Manage Database Security281
Questions284
Setting Permissions in a Database286
Questions289
Enforcing and Managing Security by Using Stored Procedures, Triggers, Views, and User-Defined Functions291
Questions294
Managing Security Auditing296
Questions298
Lab Question300
Quick Answer Key302
In-Depth Answers303
Lab Answer311
9Managing SQL Server 2000 Automation315
Creating, Managing, and Troubleshooting SQL Server Agent Jobs316
Questions321
Configuring Alerts Using SQL Server Agent322
Questions326
Creating and Using User-Defined Event Messages328
Questions330
Configuring Operators332
Questions333
Lab Question335
Quick Answer Key336
In-Depth Answers337
Lab Answer342
10Managing, Monitoring, and Troubleshooting SQL Server 2000343
Optimizing Hardware Resources344
Questions347
Monitoring Hardware Using System Monitor350
Questions352
Resolving System Bottlenecks by Using System Monitor354
Questions356
Optimizing and Troubleshooting SQL Server System Activity Using the Profiler357
Questions359
Lab Question361
Quick Answer Key362
In-Depth Answers363
Lab Answer368
Practice Exam369
Questions370
Answers395
Glossary417

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >