MCAD/MCSE/MCDBA 70-229 Exam Cram 2: Designing & Implementing Databases w/SQL Server 2000 Enterprise Edition
Index[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] packages Pad Index setting PAGLOCK hint parent-child dependency partitioned views 2nd 3rd 4th 5th 6th indexing 2nd PATINDEX() function performance file placement 2nd RAID (redundant array of independent/inexpensive disks) 2nd performance counter alerts 2nd performance tuning 2nd 3rd 4th 5th concurrency 2nd 3rd Current Activity view 2nd 3rd 4th 5th 6th DBCC (Database Console Command) 2nd 3rd maintenance options 2nd miscellaneous options 2nd trace flags 2nd validation options 2nd Event Viewer 2nd exam prep questions 2nd 3rd 4th indexes 2nd clustered 2nd covering 2nd dropping 2nd full-text 2nd Index Tuning Wizard 2nd indexed views 2nd nonclustered 2nd 3rd rebuilding 2nd 3rd strategies 2nd what not to index 2nd 3rd what to index 2nd locks 2nd 3rd contention 2nd controlling lock behavior 2nd 3rd exclusive locks granularity shared locks transaction isolation levels 2nd partitioned views 2nd indexing 2nd Query Optimizer 2nd 3rd 4th execution plan caching and sharing 2nd hints 2nd 3rd 4th 5th 6th 7th 8th reading execution plans 2nd 3rd 4th 5th SQL Profiler 2nd 3rd diagnosing locking with 2nd 3rd templates traces 2nd 3rd 4th 5th 6th 7th statistical functions 2nd 3rd stored procedures 2nd 3rd 4th recompilation 2nd web applications and 2nd transactions 2nd 3rd atomicity beginning 2nd consistency durability isolation isolation levels 2nd rolling back 2nd permissions object permissions 2nd 3rd 4th 5th 6th server roles statement permissions 2nd 3rd 4th 5th physical databases [See databases] PI() function plus sign (+) POWER() function practice exam one 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th answer explanations 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th answer key 2nd practice exam two 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th answer explanations 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th answer key 2nd Precision descriptor (columns) primary files PRIMARY KEY constraints 2nd 3rd 4th Primary Key descriptor (columns) primary keys 2nd Priority Boost option (server properties) procedure cache 2nd 3rd [See stored procedures] security 2nd sp_changedbowner sp_dboption process information definition of processes automation 2nd 3rd 4th alerts 2nd 3rd 4th 5th 6th jobs 2nd operators 2nd current activity, viewing 2nd 3rd 4th Profiler properties database properties 2nd ANSI_NULL_DEFAULT ANSI_NULLS ANSI_PADDING ANSI_WARNINGS ARITHABORT AUTO_CLOSE 2nd AUTO_CREATE_STATISTICS AUTO_SHRINK AUTO_UPDATE_STATISTICS CONCAT_NULL_YIELDS_NULL CURSOR_CLOSE_ON_COMMIT CURSOR_DEFAULT GLOBAL CURSOR_DEFAULT LOCAL MULTI_USER NUMERIC_ROUNDABORT OFFLINE QUOTED_IDENTIFIER READ_ONLY READ_WRITE RECOVERY BULK_LOGGED RECOVERY FULL RECOVERY SIMPLE RECURSIVE_TRIGGERS RESTRICTED_USER SINGLE_USER TORN_PAGE_DETECTION WITH termination (termination in italic) 2nd operating system service properties 2nd server properties Affinity Mask Allow Updates AWE Enabled C2 Audit Mode Cost Threshold for Parallelism Cursor Threshold Default Full-Text Language Default Language Fill Factor Index Create Memory Lightweight Pooling Locks Max Degree of Parallelism Max Server Memory Max Text Repl Size Max Worker Threads Media Retention Min Memory Per Query Min Server Memory Nested Triggers Network Packet Size Open Objects Priority Boost Query Governor Cost Limit Query Wait Reconfigure 2nd Recovery Interval Remote Access Remote Login Timeout Remote Proc Trans Remote Query Timeout Scan for Startup Process Set Working Set Size Two Digit Year Cutoff User Connections User Options properties (databases) altering 2nd publications Publishers central Publisher, multiple Subscribers 2nd multiple Publishers, multiple Subscribers 2nd multiple Publishers, single Subscriber single Publisher, single Subscriber 2nd Pubs database |