MCDBA考前自测—SQL　Server　2000管理（Exam　70-228）（第二版）（英文版） (2008 年度畅销榜NO.54385 )

Contents\r\n\r\nAbout the Contributors　v\r\nAcknowledgments　vii\r\nPreface　xv\r\nIntroduction　xvii\r\n\r\n1　Installing SQL Server 2000　\r\n\r\n·Installing SQL Server　\r\n　Questions　\r\n·Failover Clustering　\r\n　Questions　\r\n·Default Collation　\r\n　Questions　\r\n·Number of Instances　\r\n　Questions　\r\n·File Location　\r\n　Questions　\r\n·Service Account　\r\n　Questions　\r\n·Performing a Custom Upgrade to SQL Server 2000　\r\n　Questions　\r\n·Upgrading to SQL Server 2000 from SQL Server 6.5　\r\n　Questions　\r\n·Upgrading to SQL Server 2000 from SQL Server 7.0　\r\n　Questions　\r\n·Lab Question　\r\n·Quick Answer Key　\r\n·In-Depth Answers　\r\n·Lab Answer　\r\n\r\n2　Configuring SQL Server 2000\r\n\r\n·Creating a Linked Server　\r\n　Questions　\r\n·Configuring SQL Mail and SQL Agent Mail　\r\n　Questions　\r\n·Configuring Network Libraries　\r\n　Questions　\r\n·Troubleshooting Failed Installations　\r\n　Questions　\r\n·Lab Question　\r\n·Quick Answer Key　\r\n·In-Depth Answers　\r\n·Lab Answer　\r\n\r\n3　Creating SQL 2000 Databases　\r\n\r\n·Creating and Altering Databases　\r\n　Questions　\r\n·Setting Database Options　\r\n　Questions　\r\n·Adding/Configuring Filegroups　\r\n　Questions　\r\n·Expanding and Shrinking Databases　\r\n　Questions　\r\n·Sizing and Placing the Transaction Log　\r\n　Questions　\r\n·Configuring Database Options for Performance　\r\n　Questions　\r\n·Attaching and Detaching Databases　\r\n　Questions　\r\n·Lab Question　\r\n·Quick Answer Key　\r\n·In-Depth Answers　\r\n·Lab Answer　\r\n\r\n4　Creating and Managing Database Objects　\r\n\r\n·Creating and Managing Basic Database Objects　\r\n·Creating and Managing Constraints　\r\n　Questions　\r\n·Creating and Managing Indexes　\r\n　Questions　\r\n·Creating and Managing Stored Procedures　\r\n　Questions　\r\n·Creating and Managing Triggers　\r\n　Questions　\r\n·Creating and Managing Views　\r\n　Questions　\r\n·Lab Question　\r\n·Quick Answer Key　\r\n·In-Depth Answers　\r\n·Lab Answer　\r\n\r\n5　Managing, Monitoring, and Troubleshooting SQL Server 2000 Databases　\r\n\r\n·Optimizing Database Performance　\r\n　Questions　\r\n·Optimizing Data Storage　\r\n　Questions　\r\n·Managing Database Schema　\r\n　Questions　\r\n·Lab Question　\r\n·Quick Answer Key　\r\n·In-Depth Answers　\r\n·Lab Answer　\r\n\r\n6　Backing Up, Restoring, and Recovering SQL 2000 Databases　\r\n\r\n·Recovering System State　\r\n　Questions　\r\n·Backing Up User Databases　\r\n　Questions　\r\n·Backing Up System Databases　\r\n　Questions　\r\n·Restoring User Databases　\r\n　Questions　1\r\n·Restoring System Databases　\r\n　Questions　\r\n·Configuring, Maintaining, and Troubleshooting Log Shipping　\r\n　Questions　\r\n·Performing Integrity Checks　\r\n　Questions　\r\n·Troubleshooting Transactions and Locking　\r\n　Questions　\r\n·Lab Question　\r\n·Quick Answer Key　\r\n·In-Depth Answers　\r\n·Lab Answer　\r\n\r\n7　Extracting and Transforming Data with SQL Server 2000　\r\n\r\n·Using XML Support　\r\n　Questions　\r\n·Importing and Exporting Data with Data Transformation Services　\r\n　Questions　\r\n·Developing and Managing DTS Packages　\r\n　Questions　\r\n·Managing Linked Servers　\r\n　Questions　\r\n·Converting Data Types　\r\n　Questions　\r\n·Configuring, Maintaining, and Troubleshooting Replication Services　\r\n　Questions　\r\n·Lab Question　\r\n·Quick Answer Key　\r\n·In-Depth Answers　\r\n·Lab Answer　\r\n\r\n8　Managing and Monitoring SQL Server 2000 Security　\r\n\r\n·Configuring Security Modes　\r\n　Questions　\r\n·Creating and Managing Logons　\r\n　Questions　\r\n·Creating and Managing Database User Accounts　\r\n　Questions　\r\n·Adding and Removing Users from Fixed Roles　\r\n　Questions　\r\n·Creating Roles to Manage Database Security　\r\n　Questions　\r\n·Setting Permissions in a Database　\r\n　Questions　\r\n·Enforcing and Managing Security by Using Stored Procedures, Triggers, Views, and User-Defined Functions　\r\n　Questions　\r\n·Managing Security Auditing　\r\n　Questions　\r\n·Lab Question　\r\n·Quick Answer Key　\r\n·In-Depth Answers　\r\n·Lab Answer　\r\n\r\n9　Managing SQL Server 2000 Automation　\r\n\r\n·Creating, Managing, and Troubleshooting SQL Server Agent Jobs　\r\n　Questions　\r\n·Configuring Alerts Using SQL Server Agent　\r\n　Questions　\r\n·Creating and Using User-Defined Event Messages　\r\n　Questions　\r\n·Configuring Operators　\r\n　Questions　\r\n·Lab Question　\r\n·Quick Answer Key　\r\n·In-Depth Answers　\r\n·Lab Answer　\r\n\r\n10　Managing, Monitoring, and Troubleshooting SQL Server 2000　\r\n\r\n·Optimizing Hardware Resources　\r\n　Questions　\r\n·Monitoring Hardware Using System Monitor　\r\n　Questions　\r\n·Resolving System Bottlenecks by Using System Monitor　\r\n　Questions　\r\n·Optimizing and Troubleshooting SQL Server System Activity Using the Profiler　\r\n　Questions　\r\n·Lab Question　\r\n·Quick Answer Key　\r\n·In-Depth Answers　\r\n·Lab Answer　\r\n\r\nPractice Exam　\r\nQuestions　\r\nAnswers　\r\n\r\nGlossary