MCDBA SQL Server 7 Test Yourself Practice Exams (Exams 70-028 & 70-029) - Softcover

Softcover

ISBN 10: 0072121815 ISBN 13: 9780072121810

Publisher: McGraw-Hill Osborne Media, 1999

Synopsis

The ultimate self-testing MCDBA SQL Server 7 exam prep tool Syngress Media's MCDBA SQL Server 7 Test Yourself Practice Exams go the extra mile to help you ace these career-building exams. You learn about the purpose, focus, and structure of job task-oriented exams...the latest innovations in Microsoft testing...get a fool-proof strategy for answering the questions. This test-beater features more than 700 challenging,scenario-based exam questions, with in-depth answers from the experts. (You're even told why the incorrect choices are wrong!). Special Exam Watch warnings alert you to the questions most often missed - and tell you how to get them right. *SQL Server 7 Administration (Exam 70-028) covers growth planning...database and server security...installing, configuring,monitoring and tuning SQL Server...automating administrative tasks...backing up and restoring databases...transferring data...and replication *SQL Server 7 Designing and Implementing Databases (Exam 70-029)covers creating and managing files and databases...developing a logical data model...planning and creating indexes...queries...summarizing data...managing transactions and locks...implementing views, stored procedures and triggers...working with distributed and external data

About this title

About the Author

Syngress Media, Inc. (Norwell, MA) is an independent company committed to creating the very best book, software and Internet based exam preparation tools. They have published over 20 certification study guides and over a dozen Personal Testing Centers. All of these products are created by leading content experts, many of whom are also full-time trainers.

From the Back Cover

Test yourself--don't let the real test be your first test! More questions - more content: the best self-testing program available. Based on Microsoft's MCDBA SQL Server 7 Database Design and Database Administration exams. Covers all Microsoft-defined exam objectives for Exams 70-028 and 70-029. Comprehensive coverage features more than 700 practice exam questions-grouped by official exam objective; answers provide in-depth explanations - and show why the incorrect choices are wrong, as shown below: You have found that performance is degrading on a stored procedure that builds product summaries from your order detail records. You have run the SQL Server Query Analyzer and noticed that a composite index is no longer being used. Warnings about out of date or missing statistics are not appearing on the graphical execution plan. What should you do to give the query optimizer better information about the composite index? A: Run the Index Tuning Wizard. B: Run CREATE STATISTICS for all columns in the composite index. C: Run UPDATE STATISTICS. D: Drop the index and re-create it. Correct: B: Statistics are automatically created for only the first column of a composite index. The query optimizer may be seeing that the cost of using the composite index may be too high given the distribution of values in the first column. Adding statistics for the other columns in the composite index will allow the query optimizer to more accurately determine whether the index should be used to process the query. Incorrect: A: is incorrect because the Index Tuning Wizard will not create new statistics. C is incorrect because statistics are up-to-date. Running UPDATE STATISTICS is unlikely to change the query optimizer's strategy based on the distribution of data in the first column of the composite index. D is wrong because re-creating the index will just update the statistics for the first column.

Edition details

• Publisher: McGraw-Hill Osborne Media
• Publication date: 1999
• Language: English
• ISBN 10: 0072121815
• ISBN 13: 9780072121810
• Binding: Paperback
• Number of pages: 656
• Editor: Syngress Media Inc.