|
读过这本书吗?
最近在读
读过
想读
还不熟悉
|
图书城书列:
加入到博客或社交网站:
|
|
我来评论这本书:
内容提要:
实践是最好的方法――通过本书,您可以进行最有效的模拟测试,对考试题目进行快速复习。以便在认证考试中获得更高的分数。 特别针对MCDBA Installing、Configuring、and Administering Microsoft SQL Server 2000 Enterprise Edition(Exam 70-228)考试 内容覆盖这门考试的所有考点,可以让您快速复习考试的内容并巩固所学知识。 独一无二的Exam Watch,指出了最容易被应试者忽略的问题,以及如何正确地回答这些问题。
编辑推荐:
实践是最好的方法——通过本书,您可以进行最有效的模拟测试,对考试题目进行快速复习。以便在认证考试中获得更高的分数。
特别针对MCDBA Installing、Configuring、and Administering Microsoft SQL Server 2000 Enterprise Edition(Exam 70-228)考试 内容覆盖这门考试的所有考点,可以让您快速复习考试的内容并巩固所学知识。 独一无二的Exam Watch,指出了最容易被应试者忽略的问题,以及如何正确地回答这些问题。 目录:
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 前言:
This book's primary objective is to help you prepare for the MCDBA Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition exam (70-228) under the new Windows 2000/Microsoft Windows XP/Microsoft Windows.NET MCDBA certification track. As the Microsoft program transitions to these new versions of Microsoft Windows, it Will become increasingly important that current and aspiring IT professionals have multiple resources available to assist them in increasing their knowledge and building their skills.
Microsoft ha..
|