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]

object permissions 2nd 3rd 4th 5th 6th

OBJECT_ID() function

OBJECT_NAME() function

objects

     naming conventions 2nd

     object definitions 2nd

     system objects 2nd

     user objects 2nd

ODBC Structured Query Language (OSQL)

OFFLINE option (databases)

OLE-DB 2nd

one-tier systems 2nd

one-to-many relationships 2nd 3rd 4th

one-to-one relationships 2nd 3rd

Open Objects option (server properties)

OPEN statement

OPENQUERY function

OPENROWSET function 2nd 3rd

OPENXML keyword (SELECT statement) 2nd 3rd

operating systems

     service properties 2nd

operators 2nd 3rd

     arithmetic operators

     BETWEEN

     bitwise operators

     comparison operators 2nd

     CUBE 2nd

     definition of

     EXISTS

     IN

     LIKE 2nd

     logical operators 2nd

     ROLLUP 2nd

     unary operators

OPTIMISTIC cursors

optimization 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

ORDER BY clause (SELECT statement) 2nd

ordering data 2nd

OSQL (ODBC Structured Query Language)

OUTER JOIN statement 2nd 3rd

outer joins 2nd 3rd

owners (databases)

     changing

ownership

     broken ownership chains, troubleshooting 2nd 3rd