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]

ABS() function

access (data)

     concurrency 2nd 3rd

     exam prep questions 2nd 3rd 4th 5th 6th

     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

     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

ACID properties (transactions) 2nd

Address Windowing Extension (AWE)

Affinity Mask option (server properties)

AFTER triggers 2nd 3rd

aggregate functions 2nd

     AVG()

     COUNT()

     COUNT_BIG()

     MAX()

     MIN()

     SUM()

alerts 2nd 3rd

     definition of

     event alerts 2nd

     performance counter alerts 2nd

Allow Nulls descriptor (columns)

Allow Updates option (server properties)

ALTER DATABASE statement 2nd

ALTER TRIGGER statement 2nd

ALTER VIEW statement

Analysis Services

analyzing data 2nd

ANSI_NULL_DEFAULT option (databases)

ANSI_NULLS option (databases)

ANSI_PADDING option (databases)

ANSI_WARNINGS option (databases)

answers to practice exam one

     answer explanations 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th

     answer key 2nd

answers to practice exam two

     answer explanations 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th

     answer key 2nd

application logs 2nd

application roles 2nd

ARITHABORT option (databases)

arithmetic operators

articles

ASCII() function

associate entities 2nd

associative entities

asterisk (*)

at symbol (@)

atomic value

atomicity (transactions)

attributes

     decomposing 2nd 3rd

     defining 2nd 3rd

     definition of

     foreign keys 2nd

     identifiers

     key attributes 2nd

     primary keys 2nd

     surrogate keys

audits 2nd

     C2 security audits 2nd

     SQL Profiler security audits 2nd

auto options

     AUTO_CLOSE 2nd

     AUTO_CREATE_STATISTICS

     AUTO_SHRINK

     AUTO_UPDATE_STATISTICS

AUTO_CLOSE option (databases) 2nd

AUTO_CREATE_STATISTICS option (databases)

AUTO_SHRINK option (databases)

AUTO_UPDATE_STATISTICS option (databases)

automation 2nd 3rd 4th

     alerts 2nd

         event alerts 2nd

         performance counter alerts 2nd

     jobs 2nd

     operators 2nd

autonomy (site) 2nd

averages, returning

AVG() function

AWE (Address Windowing Extension)

AWE Enabled option (server properties)