Da Notes - 70-029 - M

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 ]

Many-to-many

Can be accomplished by creating a third table (junction table) and two One-to-many relationships to it. 

A foreign key can only implement a one-to-one or a many-to-one relationship.

A primary key can only implement a one-to-one or at one-to-many relationship 

MICROSOFT SEARCH SERVICE

FULL TEXT SEARCH
Complex searches on unstructured test for words and phrases. More powerful than LIKE operator and wildcards. Available in: Microsoft index server and Microsoft site server. Custom installation of SQL Server.

Columns searched must be: char, nchar, varchar, ncvarchar, text, ntext.

Functions:
Indexing - stored in operating system files and organized into full text catalogs

Querying - returns identity of row and a ranking value

Objects:
Full text index - tracks significant words used. Requires primary or unique key. 

SQL Server Index Full Text
Stored in database Stored as files
Several per table ONE per table
Automatically updated Manually updated
Not grouped Grouped in full text catalog
Maintained with T-SQL Maintained using stored procs