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] educational background, self-assessment encryption 2nd 3rd enforcing data access 2nd English Query entities associate entities 2nd associative entities characteristic entities definition of join entities kernel entities selecting 2nd 3rd unary entities 2nd Entity Relationship Diagrams (ERDs) Entity Relationship Model [See ER Model] equals sign (=) ER (Entity Relationship) Model 2nd 3rd attributes decomposing 2nd 3rd defining 2nd 3rd definition of foreign keys 2nd identifiers key attributes 2nd primary keys 2nd surrogate keys dependencies parent-child entities associate entities associative entities characteristic entities definition of kernel entities selecting 2nd 3rd unary entities ERDs (Entity Relationship Diagrams) relationships 2nd cardinality definition of identifying 2nd many-to-many 2nd 3rd 4th 5th one-to-many 2nd 3rd 4th one-to-one 2nd 3rd ERDs (Entity Relationship Diagrams) event alerts 2nd Event Viewer 2nd events categories of 2nd Lock[colon]Acquired Lock[colon]Cancel Lock[colon]Deadlock Lock[colon]Deadlock Chain Lock[colon]Escalation Lock[colon]Released Lock[colon]Timeout 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 exam readiness 2nd exams [See 70-229 exam] exclusive locks EXECUTE statement executing SQL code 2nd execution plans (queries) caching and sharing 2nd reading 2nd 3rd 4th 5th EXISTS keyword 2nd 3rd EXP() function experience, self-assessment EXPLICIT clause (SELECT statement) 2nd Extensible Markup Language [See XML] |