Da Notes - 70-029 - N

Personal notes on the MCDBA tests. These notes are from the various resources I used to pass the MCDBA exams including the MCDBA sample exams from Transcender.

Passing Score: 693, Questions: 49,  Time: 150 Min.

Da Notes Index 

[ 70-029 - A ] [ 70-029 - B ] [ 70-029 - C ] [ 70-029 - D ] [ 70-029 - E ] [ 70-029 - F ] [ 70-029 - H ] [ 70-029 - I ] [ 70-029 - J ] [ 70-029 - K ] [ 70-029 - L ] [ 70-029 - M ] [ 70-029 - N ] [ 70-029 - O ] [ 70-029 - P ] [ 70-029 - Q ] [ 70-029 - R ] [ 70-029 - S ] [ 70-029 - T ] [ 70-029 - U ] [ 70-029 - V ] [ 70-029 - W ]

NON-CLUSTERED INDEX

  see INDEX 

NONREPEATABLE READ 

Shared locks on selected data. Prevents dirty reads, nonrepeatable reads but does not prevent phantom data.

NORMAL FORMS

1NF: No repeating groups or multi-valued columns in a single row.

2NF: "The key, the whole key and nothing but the key". Each column that is not part of the primary key should depend on all columns that make a composite Primary key and not only depend on a subset of the composite Primary key.

3NF: Columns that are not covered by the Primary Key should not depend on each other

NT group 

A global NT group in SQL = Domain\Group or a local NT group in SQL = BUILTIN\Group 

Nulls 

Nulls (6.5 Vs 7.0) 
Watch out for = NULL or <> NULL (6.5)

instead use IS NULL or IS NOT NULL (7.0).