MCSE Microsoft® SQL Server 2000 Administration Readiness Review
Exam 70-228
Irfan Chaudhry, Dean Bartholomew
262 pages, parution le 01/04/2001
Résumé
Test your readiness for the MCP exam.
If you took Microsoft Certified Professional (MCP) Exam 70-228 today, would you pass? With the Readiness Review MCP exam simulation on CD-ROM, you get a low-risk, low-cost way to find out! This next-generation test engine delivers a set of randomly generated, 50-question practice exams covering real MCP objectives. You can test and retest with different question sets each time-and with automated scoring, you get immediate Pass/Fail feedback. More important, you get answers to these four critical questions:
- What do MCP exam questions look like?
- In what topic and skill areas am I proficient/deficient?
- How should I focus my studies?
- Am I ready for the real exam?
- Installing and upgrading
- Creating databases
- Extracting and transforming data
- Optimizing performance
- Managing security
- Troubleshooting system activity
Contents
| Welcome to Microsoft SQL Server 2000 Administration | ix |
| Before You Begin | x |
| Using the MCSE Readiness Review | xii |
| Exam Objectives Summary | xviii |
| Getting More Help | xx |
| OBJECTIVE DOMAIN 1: Installing and Configuring SQL Server 2000 | 1 |
| Tested Skills and Suggested Practices | 1 |
| Further Reading | 4 |
| Objective 1.1: Install SQL Server 2000. | 7 |
| Questions | 9 |
| Answers | 11 |
| Objective 1.2: Upgrade to SQL Server 2000. | 15 |
| Questions | 17 |
| Answers | 19 |
| Objective 1.3: Create a linked server. | 21 |
| Questions | 22 |
| Answers | 24 |
| Objective 1.4: Configure SQL Mail and SQLAgentMail. | 27 |
| Questions | 28 |
| Answers | 30 |
| Objective 1.5: Configure network libraries. | 33 |
| Questions | 35 |
| Answers | 37 |
| Objective 1.6: Troubleshoot failed installations. | 39 |
| Questions | 40 |
| Answers | 41 |
| OBJECTIVE DOMAIN 2: Creating SQL Server 2000 Databases | 45 |
| Tested Skills and Suggested Practices | 46 |
| Further Reading | 47 |
| Objective 2.1: Configure database options for performance. | 49 |
| Questions | 50 |
| Answers | 52 |
| Objective 2.2: Attach and detach databases. | 55 |
| Questions | 56 |
| Answers | 58 |
| Objective 2.3: Create and alter databases. | 61 |
| Questions | 62 |
| Answers | 64 |
| Objective 2.4: Create and manage objects. | 69 |
| Questions | 71 |
| Answers | 74 |
| OBJECTIVE DOMAIN 3: Managing, Monitoring, and Troubleshooting SQL Server 2000 Databases | 77 |
| Tested Skills and Suggested Practices | 78 |
| Further Reading | 80 |
| Objective 3.1: Optimize database performance. | 83 |
| Questions | 85 |
| Answers | 88 |
| Objective 3.2: Optimize data storage. | 91 |
| Questions | 92 |
| Answers | 94 |
| Objective 3.3: Modify the database schema. | 97 |
| Questions | 99 |
| Answers | 100 |
| Objective 3.4: Perform disaster recovery operations. | 103 |
| Questions | 104 |
| Answers | 108 |
| Objective 3.5: Perform integrity checks. | 111 |
| Questions | 113 |
| Answers | 115 |
| Objective 3.6: Troubleshoot transactions and locking by using SQL Profiler, SQL Server Enterprise Manager, or Transact-SQL. | 117 |
| Questions | 118 |
| Answers | 120 |
| OBJECTIVE DOMAIN 4: Extracting and Transforming Data with SQL Server 2000 | 123 |
| Tested Skills and Suggested Practices | 124 |
| Further Reading | 126 |
| Objective 4.1: Set up Internet Information Services (IIS) virtual directories to support XML. | 129 |
| Questions | 130 |
| Answers | 132 |
| Objective 4.2: Import and export data. | 135 |
| Questions | 137 |
| Answers | 139 |
| Objective 4.3: Develop and manage Data Transformation Services (DTS) packages. | 141 |
| Questions | 142 |
| Answers | 146 |
| Objective 4.4: Manage linked servers. | 149 |
| Questions | 151 |
| Answers | 152 |
| Objective 4.5: Convert data types. | 155 |
| Questions | 156 |
| Answers | 157 |
| Objective 4.6: Configure, maintain, and troubleshoot replication services. | 161 |
| Questions | 163 |
| Answers | 165 |
| OBJECTIVE DOMAIN 5: Managing and Monitoring SQL Server 2000Security | 169 |
| Tested Skills and Suggested Practices | 169 |
| Further Reading | 171 |
| Objective 5.1: Configure mixed security modes or Windows Authentication. | 175 |
| Questions | 177 |
| Answers | 178 |
| Objective 5.2: Create and manage logons. | 181 |
| Questions | 182 |
| Answers | 185 |
| Objective 5.3: Create and manage database users. | 189 |
| Questions | 190 |
| Answers | 192 |
| Objective 5.4: Create and manage security roles. | 195 |
| Questions | 196 |
| Answers | 198 |
| Objective 5.5: Enforce and manage security by using stored procedures, triggers, views, and user-defined functions. | 201 |
| Questions | 202 |
| Answers | 203 |
| Objective 5.6: Set permissions in a database. | 205 |
| Questions | 206 |
| Answers | 207 |
| Objective 5.7: Manage security auditing. | 211 |
| Questions | 212 |
| Answers | 213 |
| OBJECTIVE DOMAIN 6: Managing, Monitoring, and Troubleshooting SQL Server 2000 | 215 |
| Tested Skills and Suggested Practices | 216 |
| Further Reading | 217 |
| Objective 6.1: Create, manage, and troubleshoot SQL Server Agent jobs. | 219 |
| Questions | 221 |
| Answers | 223 |
| Objective 6.2: Configure alerts and operators by using SQL Server Agent. | 227 |
| Questions | 229 |
| Answers | 230 |
| Objective 6.3: Optimize hardware resource usage. | 233 |
| Questions | 234 |
| Answers | 235 |
| Objective 6.4: Optimize and troubleshoot SQL Server system activity. | 237 |
| Questions | 239 |
| Answers | 241 |
| GLOSSARY | 243 |
| INDEX | 253 |
Caractéristiques techniques
| PAPIER | |
| Éditeur(s) | Microsoft Press |
| Auteur(s) | Irfan Chaudhry, Dean Bartholomew |
| Parution | 01/04/2001 |
| Nb. de pages | 262 |
| Format | 18,7 x 22,8 |
| Couverture | Broché |
| Poids | 595g |
| Intérieur | Noir et Blanc |
| EAN13 | 9780735612501 |
Avantages Eyrolles.com
Livraison à partir de 0,01 € en France métropolitaine
Paiement en ligne SÉCURISÉ
Livraison dans le monde
Retour sous 15 jours
+ d'un million et demi de livres disponibles
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse
