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]

n-tier systems 2nd

naming conventions

     databases

     filenames

     objects 2nd

nchar data type

Nested Triggers option (server properties)

Network Packet Size option (server properties)

new features

     cascading referential integrity

     collations

     data types

     distributed partitioned views

     indexed views

     INSTEAD OF and AFTER triggers

     multiple instance connections

     partitioned views

     T-SQL functions

     XML support

NOLOCK hint

nonclustered covering indexes 2nd

nonclustered indexes 2nd 3rd 4th 5th

     what not to index 2nd 3rd

     what to index 2nd

nondeterministic functions 2nd

normalization 2nd 3rd

     definition of 2nd

     denormalization 2nd 3rd 4th 5th

     fifth normal form

     first normal form 2nd

     fourth normal form

     second normal form

     third normal form

Northwind database

NOT NULL constraints

NT logins 2nd 3rd

     creating 2nd

ntext data type

NULL values 2nd

NULLIF() function

numeric data types 2nd

NUMERIC_ROUNDABORT option (databases)

nvarchar data type