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]

maintenance options (DBCC) 2nd

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

Master database 2nd

mathmatical functions 2nd

Max Degree of Parallelism option (server properties)

Max Server Memory option (server properties)

Max Text Repl Size option (server properties)

Max Worker Threads option (server properties)

MAX() function

MAXSIZE clause (CREATE DATABASE statement) 2nd

Media Retention option (server properties)

memory

    caching

         data cache

         procedure cache

         query execution plans 2nd

merge replication 2nd 3rd 4th

metadata 2nd

Microsoft Search Service (MSSearch) 2nd

Min Memory Per Query option (server properties)

Min Server Memory option (server properties)

MIN() function

Mixed security mode

Model database 2nd

money data type

monitoring

     SQL Profiler 2nd 3rd

moving data 2nd

     BACKUP/RESTORE operations 2nd

     BCP (Bulk Copy Program) 2nd 3rd 4th

     DTS Import/Export Wizard 2nd

     XML (Extensible Markup Language) 2nd 3rd

msdb database 2nd

MSDTC source (application log)

MSSearch (Microsoft Search Service) 2nd

MSSQLSERVER source (application log)

MSSQLServerADHelper source (application log)

MSSQLServerOLAPService source (application log)

MULTI_USER option (databases)

multiple instances

     connectiing to

multiple machine database implementations

     replication 2nd

         advantages of 2nd

         articles

         central Publisher, multiple Subscribers 2nd

         data distribution 2nd

         Distributors

         latency 2nd

         merge replication 2nd

         multiple Publishers, multiple Subscribers 2nd

         multiple Publishers, single Subscriber

         publications

         Publishers

         single Publisher, single Subscriber 2nd

         site autonomy 2nd

         snapshot replication 2nd

         Subscribers

         transactional consistency 2nd

         transactional replication 2nd

     standby servers and log shipping 2nd

multiple Publishers, multiple Subscribers replication 2nd

multiple Publishers, single Subscriber replication