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]

ideal Certified Information Systems Auditor candidate

IDENT_INCR() function

IDENT_SEED() function

identifiers

identifying relationships 2nd

Identity descriptor (columns)

Identity Increment descriptor (columns)

Identity Seed descriptor (columns)

IF...ELSE statement 2nd

image data type

Import/Export Wizard 2nd

IN keyword

Index Create Memory option (server properties)

Index Tuning Wizard 2nd

INDEX_COL() function

indexed views 2nd 3rd 4th 5th 6th

indexes 2nd 3rd 4th 5th 6th

     clustered 2nd

     clustered indexes 2nd

     covering 2nd

     creating 2nd

     definition of

     dropping 2nd

     fill factor 2nd

     full-text 2nd

     Full-Text indexes 2nd

     Index Tuning Wizard 2nd

     indexed views 2nd

     nonclustered 2nd 3rd

     nonclustered indexes 2nd

     Pad Index setting

     rebuilding 2nd 3rd 4th

     strategies 2nd

     unique indexes

     what not to index 2nd 3rd

     what to index 2nd

INFORMATION_SCHEMA views 2nd

INNER JOIN statement 2nd

inner joins 2nd

INSERT statement 2nd 3rd

inserting data

     INSERT statement 2nd 3rd

instances

     definition of

INSTEAD OF triggers 2nd 3rd 4th 5th

Integrated security mode

integrity of data [See data integrity]

integrity, referential

Internet application architecture 2nd

INTO clause (SELECT statement) 2nd

IS NOT NULL statement

IS NULL statement

Is RowGuid descriptor (columns)

ISNULL() function 2nd

isolation (transactions)

isolation levels (transactions) 2nd