CONTENTS
1 Installing SQL Server 2000
Installing SQL Server
Questions
Failover Clustering
Questions
Default Collation
Questions
Number of Instances
Questions
File Location
Questions
Service Account
Questions
Performing a Custom Upgrade to SQL Server 2000
Questions
Upgrading to SQL Server 2000 from SQL Server 6.5
Questions
Upgrading to SQL Server 2000 from SQL Server 7.0
Questions
Lab Question
Quick Answer Key
In-Depth Answers
Lab Answer
2 Configuring SQL Server 2000
Creating a Linked Server
Questions
Configuring SQL Mail and SQL Agent Mail
Questions
Configuring Network Libraries
Questions
Troubleshooting Failed Installations
Questions
Lab Question
Quick Answer Key
In-Depth Answers
Lab Answer
3 Creating SQL 2000 Databases
Creating and Altering Databases
Questions
Setting Database Options
Questions
Adding/Configuring Filegroups
Questions
Expanding and Shrinking Databases
Questions
Sizing and Placing the Transaction Log
Questions
Configuring Database Options for Performance
Questions
Attaching and Detaching Databases
Questions
Lab Question
Quick Answer Key
In-Depth Answers
Lab Answer
4 Creating and Managing Database Objects
Creating and Managing Basic Database Objects
Creating and Managing Constraints
Questions
Creating and Managing Indexes
Questions
Creating and Managing Stored Procedures
Questions
Creating and Managing Triggers
Questions
Creating and Managing Views
Questions
Lab Question
Quick Answer Key
In--Depth Answers
Lab Answer
5 Managing, Monitoring, and Troubleshooting SQL
Server 2000 Databases
Optimizing Database Performance
Questions
Optimizing Data Storage
Questions
Managing Database Schema
Questions
Lab Question
Quick Answer Key
In-Depth Answers
Lab Answer
6 Backing Up, Restoring, and Recovering
SQL 2000 Databases
Recovering System State
Questions
Backing Up User Databases
Questions
Backing Up System Databases
Questions
Restoring User Databases
Questions
Restoring System Databases
Questions
Configuring, Maintaining, and Troubleshooting Log Shipping
Questions
Performing Integrity Checks
Questions
Troubleshooting Transactions and Locking
Questions
Lab Question
Quick Answer Key
In-Depth Answers
Lab Answer
7 Extracting and Transforming Data with
SQL Server 2000
Using XML Support
Questions
Importing and Exporting Data With Data Transformation Services
Questions
Developing and Managing DTS Packages
Questions
Managing Linked Servers
Questions
Converting Data Types
Questions
Configuring, Maintaining, and Troubleshooting Replication Services
Questions
Lab Question
Quick Answer Key
In-Depth Answers
Lab Answer
8 Managing and Monitoring SQL Server 2000 Security
Configuring Security Modes
Questions
Creating and Managing Logons
Questions
Creating and Managing Database User Accounts
Questions
Adding and Removing Users from fixed Roles
Questions
Creating Roles to Manage Database Security
Questions
Setting Permissions in a Database
Questions
Enforcing and Managing Security by Using Stored Procedures,
Triggers, View, and User-Defined Functions
Questions
Managing Security Auditing
Questions
Lab Question
Quick Answer Key
In-Depth Answers
Lab Answer
9 Managing SQL Server 2000 Automation
Creating, Managing, and Troubleshooting SQL Server Agent Jobs
Questions
Configuring Alerts Using SQL Server Agent
Questions
Creating and Using User-Defined fount Messages
Questions
Configuring Operators
Questions
Lab Question
Quick Answer Key
In-Depth Answers
Lab Answer
10 Managing, Monitoring, and Troubleshooting
SQL Server 2000
Optimizing Hardware Resources
Questions
Monitoring Hardware Using System Monitor
Questions
Resolving System Bottlenecks by Using System Monitor
Questions
Optimizing and Troubleshooting SQL Server System
Activity Using the Profiler
Questions
Lab Question
Quick Answer Key
In-Depth Answers
Lab Answer
Practice Exam
Questions
Answers
Glossary
鄂公网安备 42010302001612号 