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
ISBN-10:
0072134437
ISBN-13:
9780072134438
Pub. Date:
11/01/2001
Publisher:
McGraw-Hill Companies, The
ISBN-10:
0072134437
ISBN-13:
9780072134438
Pub. Date:
11/01/2001
Publisher:
McGraw-Hill Companies, The
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

Paperback

$37.0
Current price is , Original price is $37.0. You
$37.00 
  • SHIP THIS ITEM
    Qualifies for Free Shipping
  • PICK UP IN STORE

    Your local store may have stock of this item.

  • SHIP THIS ITEM

    Temporarily Out of Stock Online

    Please check back later for updated availability.


Overview

The SQL Administration 2000 exam is a required exam for the Microsoft MCDBA (Microsoft Certified Database Administrator) track, and an elective exam for the MCSE (Microsoft Certified Systems Engineer) certification track. This book is an ideal supplement to the MCDBA SQL Server 2000 Administration Study Guide and will provide over 300 new questions to practice for the exam.

Product Details

ISBN-13: 9780072134438
Publisher: McGraw-Hill Companies, The
Publication date: 11/01/2001
Series: Test Yourself
Edition description: 2nd ed.
Pages: 400
Product dimensions: 7.42(w) x 9.10(h) x 1.10(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
From the B&N Reads Blog

Customer Reviews