Da Notes - 70-029 - A

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 ]

Aggregate Functions

Processes all chosen values in one column and calculates a result value SUM, AVG, COUNT, MAX, MIN, COUNT (*), STDEV, STDEVP, VAR, VARP.

Aggregate functions can be placed in WHERE clauses when use in a subquery (using parenthesis).
Index frequently aggregated columns to improve query performance.

Most aggregate functions ignore null values except COUNT(*) which counts rows with null values.

Alter database - see create database

You must know all the parameters of this T-SQL command.

Review how to add foreign key constraints, defaults and check constraints. 

ANSI_NULL_DFLT_OFF

When set to ON, new columns created using the ALTER TABLE and CREATE TABLE statements are by default NOT NULL.

Has no effect on columns created with an explicit NULL or NOT NULL.