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]

* (asterisk)

+ (plus sign)

-- (double dash)

/* (slash-star)

1204 trace flag

1NF (first normal form) 2nd

2528 trace flag

260 trace flag

3205 trace flag

70-229 exam

    exam prep questions

         chapter 1 2nd 3rd

         chapter 10 2nd 3rd 4th 5th

         chapter 2 2nd 3rd 4th 5th 6th 7th 8th 9th

         chapter 3 (physical database implementation) 2nd 3rd 4th 5th 6th 7th

         chapter 4 2nd 3rd 4th 5th

         chapter 5 (data retrieval/modification) 2nd 3rd 4th 5th 6th 7th 8th

         chapter 6 (programming business logic) 2nd 3rd 4th

         chapter 7 2nd 3rd 4th

         chapter 8 2nd 3rd 4th 5th 6th

         chapter 9 2nd 3rd

     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

     topics 2nd

         cascading referential integrity

         collations

         data types

         database design 2nd

         distributed partitioned views

         hardware requirements 2nd 3rd

         indexed views

         INSTEAD OF and AFTER triggers

         multiple instance connections

         partitioned views

         program execution 2nd

         Query Analyzer 2nd

         SQL Server tools 2nd 3rd 4th

         T-SQL functions

         XML support

70-229 exam cram

     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

= (equals sign)

@ (at symbol)

@@CONNECTIONS function

@@CPU_BUSY function

@@CURSOR_ROWS global variable

@@ERROR global variable

@@FETCH_STATUS global variable

@@IDENTITY global variable

@@IDLE function

@@IO_BUSY function 2nd

@@PACK_RECEIVED function

@@PACK_SENT function

@@PACKET_ERRORSfunction

@@ROWCOUNT global variable

@@SERVERNAME global variable

@@SPID global variable

@@TOTAL_ERRORS function

@@TOTAL_READ function

@@TOTAL_WRITE function

@@TRANCOUNT global variable

@@VERSION global variable