MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam [Pehme köide]

Introduction		1	(6)
Self Assessment		7	(6)
Installing and Configuring SQL Server 2005		13	(18)
Installing and Configuring SQL Server 2005		14	(14)
Installation Requirements		14	(4)
The Installation Process		18	(1)
Installation Preparations		19	(3)
Postinstallation Procedures		22	(6)
Exam Prep Questions		28	(3)
Answers to Exam Prep Questions		30	(1)
Creating Database Objects		31	(38)
Creating and Defining Databases		32	(9)
Using T-SQL to Create and Alter a Database		33	(1)
The Makeup of a Database		33	(2)
Standard Views, Indexed Views, and Partitioned Views		35	(5)
Miscellaneous SQL Server Objects		40	(1)
Defining SQL Server Tables		41	(19)
Using Types and Schemas		42	(4)
Using Columns with Automated or Calculated Values		46	(1)
Maintaining Order by Using Indexes		47	(3)
Primary/Foreign Keys and Relationships		50	(2)
Using Cascading Actions		52	(1)
Using DML and DDL Triggers		53	(1)
Partitioning Tables		54	(2)
Creating Partitioned Tables		56	(4)
SQL Server Programmability Objects		60	(5)
Stored Procedures		60	(1)
Creating Check Constraints		61	(1)
Creating Your Own Functions		62	(1)
English Query Capabilities with Full-Text Catalogs		63	(1)
Objects with Security Context		64	(1)
Exam Prep Questions		65	(2)
Answers to Exam Prep Questions		67	(2)
Implementing Database Objects		69	(30)
Data Querying and Reporting		70	(10)
Listing the Contents of a Table		71	(1)
Making a Report More Presentable		72	(3)
Querying a Sampling of the Data Stored		75	(1)
Relating Data from Multiple Tables		76	(2)
Applying Conditional Data Filtering		78	(2)
Data Querying Using Full-Text Indexes		80	(1)
Creating and Populating a Catalog		80	(1)
Using System Tables and Views		81	(10)
Getting Information from System Tables		82	(3)
Information Retrieval from System Stored Procedures		85	(1)
Using Dynamic Management Views and Other System Views		86	(1)
Inserting Data		87	(1)
Using UDT and the CLR to Control Data Input		87	(1)
Using the CLR Within Stored Procedures		88	(1)
Inserting Individual Records		88	(1)
Using a Query to Insert Complete Recordsets		89	(1)
Disabling Functionality During Data Insertion		90	(1)
Changing What Is Already Stored		91	(2)
Updating a Single Record		92	(1)
Doing Updates That Affect Multiple Records		92	(1)
Performing Transaction Processing		92	(1)
Upgrading Data from Previous Releases of SQL Server		93	(1)
Removing Unwanted Data		93	(3)
Directly Removing Records from a Table		94	(1)
Indirectly Removing Data from a Table		94	(1)
Escalating Privileges to Allow Deletion		95	(1)
Controlling Privileges by Using Grant, Deny, and Revoke		95	(1)
Exam Prep Questions		96	(2)
Answers to Exam Prep Questions		98	(1)
Supporting the XML Framework		99	(18)
Managing XML Data		100	(11)
Newly Supported XML Features		101	(1)
XML: The Basics		102	(4)
The xml Data Type and Methods		106	(1)
XML Method Interactions		107	(4)
Other SQL Server XML Support		111	(3)
Indexing XML Data		111	(1)
Creating Primary and Secondary Indexes		112	(1)
Native XML Web Service Support		112	(2)
Exam Prep Questions		114	(1)
Answers to Exam Prep Questions		115	(2)
Data Consumption and Throughput		117	(16)
Importing and Exporting Data		118	(6)
Using the Bulk Copy Program (BCP)		119	(3)
Using Openrowset for Importing Data		122	(1)
Using SQL Server Integration Services (SSIS)		122	(2)
Implementing Service Broker		124	(5)
Designing a Service		125	(4)
Exam Prep Questions		129	(2)
Answers to Exam Prep Questions		131	(2)
Database Maintenance		133	(26)
SQL Server 2005 Database Maintenance		134	(2)
What's New in SQL Server Maintenance?		134	(2)
Performing Database Backups		136	(10)
Recovery Models and Backups		136	(2)
Recovery Models Using T-SQL		138	(1)
Backup Types and Scenarios		139	(2)
Setting the Options of a Backup		141	(1)
Options of the T-SQL Backup Statement		142	(4)
Restoring Data from a Backup		146	(4)
Using the T-SQL Restore Statement		149	(1)
Using Database Snapshots		150	(3)
Creating and Deleting Database Snapshots		152	(1)
Automating Maintenance with Job Scheduling		153	(3)
Viewing Job Details and History		154	(2)
Exam Prep Questions		156	(2)
Answers to Exam Prep Questions		158	(1)
Monitoring SQL Server Performance		159	(22)
SQL Server Management Studio		160	(1)
Monitoring and Recording Performance		161	(8)
Using Activity Monitor for the Here and Now		162	(2)
Management Studio: Log File Viewer		164	(2)
Server-Maintained Information		166	(3)
Using Windows System Monitor		169	(3)
Using SQL Server Profiler		172	(6)
Defining a Profiler Trace		174	(1)
Using Profiler Traces to Diagnose Locking		175	(1)
Trace Playback and Diagnosis		176	(1)
Using Profiler to Gather a Workload		177	(1)
Exam Prep Questions		178	(2)
Answers to Exam Prep Questions		180	(1)
Troubleshooting and Optimizing SQL Server		181	(22)
Data Analysis and Problem Diagnosis		182	(6)
Tuning the Operating System and Hardware		182	(1)
Creating and Maintaining Statistics		183	(1)
Locks, Blocks, and Deadlocks		184	(4)
Tuning the Database Structure		188	(7)
Indexing Strategies		188	(4)
Data Partitioning Across Servers		192	(1)
Using the DTA		193	(2)
Server Configuration Maintenance		195	(4)
Using the Database Console Command (DBCC)		195	(3)
Setting Alerts to Automate Problem Identification		198	(1)
Exam Prep Questions		199	(2)
Answers to Exam Prep Questions		201	(2)
Implementing High Availability		203	(20)
High-Availability Solutions		204	(6)
Implementing Log Shipping		205	(2)
Using Database Mirroring		207	(2)
Using Failover Clustering		209	(1)
Using Replication		210	(8)
Replication Strategies		211	(3)
Types of Replication		214	(2)
Elements of Replication		216	(2)
Microsoft Analysis Services		218	(2)
Exam Prep Questions		220	(2)
Answers to Exam Prep Questions		222	(1)
Practice Exam 1		223	(14)
Exam Questions		224	(13)
Answers to Practice Exam 1		237	(22)
Practice Exam 2		259	(14)
Exam Questions		260	(13)
Answers to Practice Exam 2		273	(20)
Appendix A: Suggested Readings and Resources		293	(6)
Installing and Configuring SQL Server 2005		293	(1)
Books		293	(1)
On the Web		294	(1)
SQL Server Books Online Help Facility		294	(1)
Creating Database Objects		294	(1)
Books		294	(1)
On the Web		294	(1)
SQL Server Books Online Help Facility		294	(1)
Implementing Database Objects		295	(1)
Books		295	(1)
On the Web		295	(1)
SQL Server Books Online Help Facility		295	(1)
Supporting the XML Framework		295	(1)
Books		295	(1)
On the Web		295	(1)
SQL Server Books Online Help Facility		296	(1)
Data Consumption and Throughput		296	(1)
Books		296	(1)
On the Web		296	(1)
SQL Server Books Online Help Facility		296	(1)
Database Maintenance		297	(1)
Books		297	(1)
On the Web		297	(1)
SQL Server Books Online Help Facility		297	(1)
Monitoring SQL Server Performance		297	(1)
On the Web		297	(1)
SQL Server Books Online Help Facility		297	(1)
Troubleshooting and Optimizing SQL Server		298	(1)
On the Web		298	(1)
SQL Server Books Online Help Facility		298	(1)
Implementing High Availability		298	(1)
On the Web		298	(1)
SQL Server Books Online Help Facility		298	(1)
Appendix B: Accessing Your Free MeasureUp Practice Test		299	(2)
Appendix C: MeasureUp's Product Features		301	(4)
Multiple Testing Modes		301	(1)
Study Mode		301	(1)
Certification Mode		301	(1)
Custom Mode		302	(1)
Missed Question Mode		302	(1)
Non-Duplicate Mode		302	(1)
Question Types		302	(1)
Random Questions and Order of Answers		303	(1)
Detailed Explanations of Correct and Incorrect Answers		303	(1)
Attention to Exam Objectives		303	(1)
Technical Support		303	(2)
Glossary		305	(14)
Index		319

Thomas R. Moore, MCITP, MCTS, MCSE, MCSA, MCSD, MCDBA, MCP, MCT, CSE, CTT+, has been in the computer industry for more than 25 years. Thomas has a wide variety of expertise in all hardware environments and with most Microsoft Server products. My first and lasting love, besides my wife and family, of course, however, is database programming, he says. Thomas is comfortable in any programming language environment. He achieved his MCSD and MCDBA certifications from their inception; completed the Microsoft CSE certification as a certified software engineer with Dexterity and Microsoft Business Solutions products; and, most recently, completed the new Microsoft Certifications for MCITP and MCTS on SQL Server 2005. Over the past 20 years, he has been working for a variety of Microsoft partners, and he is currently an intermediate developer/technical consultant with Diamond Municipal Solutions in Paris, Ontario, where he has been for the past four years. Among his myriad IT certifications, Thomas also holds certifications in English and business/technical writing. Thomas enjoys staying up-to-date, although like most of us, he finds it a challenge to keep up with the pace of the industry.