MCDBA考前自測(cè)：SQL Server 2000管理(Exam 70-228)

定　價(jià)：￥50.00

作　者：	(美)Stephen Giles,(美)Glen Martin著
出版社：	人民郵電出版社
叢編項(xiàng)：	SQL Server 2000管理
標(biāo)　簽：	關(guān)系型數(shù)據(jù)庫(kù) 數(shù)據(jù)庫(kù)管理系統(tǒng) 試題英文

購(gòu)買(mǎi)這本書(shū)可以去

當(dāng)當(dāng)網(wǎng) (￥40.00)

ISBN：	9787115100863	出版時(shí)間：	2002-01-01	包裝：	平裝
開(kāi)本：	24cm	頁(yè)數(shù)：	430	字?jǐn)?shù)：

內(nèi)容簡(jiǎn)介

　　實(shí)踐是最好的方法——通過(guò)本書(shū)，您可以進(jìn)行最有效的模擬測(cè)試，對(duì)考試題目進(jìn)行快速?gòu)?fù)習(xí)。以便在認(rèn)證考試中獲得更高的分?jǐn)?shù)。特別針對(duì)MCDBA Installing、Configuring、and Administering Microsoft SQL Server 2000 Enterprise　Edition（Exam 70-228）考試內(nèi)容覆蓋這門(mén)考試的所有考點(diǎn)，可以讓您快速?gòu)?fù)習(xí)考試的內(nèi)容并鞏固所學(xué)知識(shí)。獨(dú)一無(wú)二的Exam Watch，指出了最容易被應(yīng)試者忽略的問(wèn)題，以及如何正確地回答這些問(wèn)題。

作者簡(jiǎn)介

暫缺《MCDBA考前自測(cè)：SQL Server 2000管理(Exam 70-228)》作者簡(jiǎn)介

圖書(shū)目錄

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