Flylib.com
MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam
MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam
ISBN: 0789735881
EAN: 2147483647
Year: 2006
Pages: 200
Authors:
Thomas Moore
BUY ON AMAZON
MCTS 70-431: Implementing and Maintaining Microsoft SQL Server 2005
Table of Contents
Copyright
About the Author
Acknowledgments
We Want to Hear from You
Reader Services
Introduction
About the 70-431 Exam and Content Areas
How to Prepare for the Exam
What This Book Does
What This Book Does Not Do
About This Book
Self Assessment
SQL Server Implementation and Maintenance as an MCTS
Chapter 1. Installing and Configuring SQL Server 2005
Installing and Configuring SQL Server 2005
Exam Prep Questions
Chapter 2. Creating Database Objects
Creating and Defining Databases
Defining SQL Server Tables
SQL Server Programmability Objects
Exam Prep Questions
Answers to Exam Prep Questions
Chapter 3. Implementing Database Objects
Data Querying and Reporting
Data Querying Using Full-Text Indexes
Using System Tables and Views
Changing What Is Already Stored
Removing Unwanted Data
Exam Prep Questions
Answers to Exam Prep Questions
Chapter 4. Supporting the XML Framework
Managing XML Data
Other SQL Server XML Support
Exam Prep Questions
Answers to Exam Prep Questions
Chapter 5. Data Consumption and Throughput
Importing and Exporting Data
Implementing Service Broker
Exam Prep Questions
Answers to Exam Prep Questions
Chapter 6. Database Maintenance
SQL Server 2005 Database Maintenance
Performing Database Backups
Restoring Data from a Backup
Using Database Snapshots
Automating Maintenance with Job Scheduling
Exam Prep Questions
Answers to Exam Prep Questions
Chapter 7. Monitoring SQL Server Performance
SQL Server Management Studio
Monitoring and Recording Performance
Using Windows System Monitor
Using SQL Server Profiler
Exam Prep Questions
Answers to Exam Prep Questions
Chapter 8. Troubleshooting and Optimizing SQL Server
Data Analysis and Problem Diagnosis
Tuning the Database Structure
Server Configuration Maintenance
Exam Prep Questions
Answers to Exam Prep Questions
Chapter 9. Implementing High Availability
High-Availability Solutions
Using Replication
Microsoft Analysis Services
Exam Prep Questions
Answers to Exam Prep Questions
Chapter 10. Practice Exam 1
Exam Questions
Chapter 11. Answers to Practice Exam 1
Question 1
Question 2
Question 3
Question 4
Question 5
Question 6
Question 7
Question 8
Question 9
Question 10
Question 11
Question 12
Question 13
Question 14
Question 15
Question 16
Question 17
Question 18
Question 19
Question 20
Question 21
Question 22
Question 23
Question 24
Question 25
Question 26
Question 27
Question 28
Question 29
Question 30
Question 31
Question 32
Question 33
Question 34
Question 35
Question 36
Question 37
Question 38
Question 39
Question 40
Chapter 12. Practice Exam 2
Exam Questions
Chapter 13. Answers to Practice Exam 2
Question 1
Question 2
Question 3
Question 4
Question 5
Question 6
Question 7
Question 8
Question 9
Question 10
Question 11
Question 12
Question 13
Question 14
Question 15
Question 16
Question 17
Question 18
Question 19
Question 20
Question 21
Question 22
Question 23
Question 24
Question 25
Question 26
Question 27
Question 28
Question 29
Question 30
Question 31
Question 32
Question 33
Question 34
Question 35
Question 36
Question 37
Question 38
Question 39
Question 40
Appendix A. Suggested Readings and Resources
Chapter 1: Installing and Configuring SQL Server 2005
Chapter 2: Creating Database Objects
Chapter 3: Implementing Database Objects
Chapter 4: Supporting the XML Framework
Chapter 5: Data Consumption and Throughput
Chapter 6: Database Maintenance
Chapter 7: Monitoring SQL Server Performance
Chapter 8: Troubleshooting and Optimizing SQL Server
Chapter 9: Implementing High Availability
Appendix B. Accessing Your Free MeasureUp Practice Test
Appendix C. MeasureUp s Product Features
Multiple Testing Modes
Question Types
Random Questions and Order of Answers
Detailed Explanations of Correct and Incorrect Answers
Attention to Exam Objectives
Technical Support
Glossary
Index
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam
ISBN: 0789735881
EAN: 2147483647
Year: 2006
Pages: 200
Authors:
Thomas Moore
BUY ON AMAZON
Microsoft Windows Server 2003(c) TCP/IP Protocols and Services (c) Technical Reference
Local Area Network (LAN) Technologies
Internet Protocol (IP) Addressing
Transmission Control Protocol (TCP) Connections
Transmission Control Protocol (TCP) Retransmission and Time-Out
Windows Internet Name Service (WINS)
Cisco CallManager Fundamentals (2nd Edition)
Regions
Route Patterns and Route Filters
Overview of Station Devices Supported by CallManager
Summary
Summary
Introducing Microsoft ASP.NET AJAX (Pro - Developer)
The AJAX Revolution
The Microsoft Client Library for AJAX
The Pulsing Heart of ASP.NET AJAX
The AJAX Control Toolkit
Remote Method Calls with ASP.NET AJAX
Ruby Cookbook (Cookbooks (OReilly))
Testing Whether an Object Is String-Like
Coupling Systems Loosely with Callbacks
Including Namespaces
Testing Whether a Program Is Running Interactively
Creating a GUI Application with wxRuby
FileMaker 8 Functions and Scripts Desk Reference
Day()
Get(ApplicationLanguage)
LayoutNames()
Let()
SerialIncrement()
User Interfaces in C#: Windows Forms and Custom Controls
Classic Controls
Modern Controls
Custom Controls
Dynamic User Interface
GDI+ Controls
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies