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
ADO.NET 3.5 Cookbook (Cookbooks (OReilly))
Getting Typed DataRows from DataViews
Updating Data Asynchronously Using Message Queuing
Using ADO.NET and SQL Server DBMS Transactions Together
Debugging a SQL Server Stored Procedure
A.4. Interfaces
Competency-Based Human Resource Management
Competency-Based Employee Recruitment and Selection
Competency-Based Performance Management
Appendix B Further Suggestions on Employee Development
Appendix C Examples of Life-Career Assessment Exercises
Appendix D Employee Development and Succession Management
The Java Tutorial: A Short Course on the Basics, 4th Edition
Creating and Using Packages
How to Throw Exceptions
Getting Started Problems
AWT Components
The APPLET Tag
Introducing Microsoft ASP.NET AJAX (Pro - Developer)
The Microsoft Client Library for AJAX
The Pulsing Heart of ASP.NET AJAX
Partial Page Rendering
The AJAX Control Toolkit
Remote Method Calls with ASP.NET AJAX
Twisted Network Programming Essentials
Accessing a Password-Protected Page
Using a Web Client to Update Resources Through REST
Using Authentication in a Twisted Server
Listing Mailboxes on an IMAP Server
NNTP Clients and Servers
802.11 Wireless Networks: The Definitive Guide, Second Edition
Management Frames
Robust Security Network (RSN) Operations
Power Management and the PCF
Gaussian Frequency Shift Keying (GFSK)
11 Performance Calculations
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