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]

failed object creation, troubleshooting 2nd

FAST_FORWARD cursors

FETCH NEXT statement

fields

     definition of

fifth normal form

file system

     file placement 2nd

     filegroups 2nd

     filenames

     primary files

     secondary files

filegroups 2nd

FILEGROWTH clause (CREATE DATABASE statement)

filenames

files [See also file system]

     data files

     file placement 2nd

     filegroups 2nd

     filenames

     log files 2nd

     primary files

     secondary files

fill factor 2nd

Fill Factor option (server properties)

filtering

     data access 2nd

filtering data

     arithmetic operators

     BETWEEN keyword

     bitwise operators

     comparison operators 2nd

     EXISTS keyword

     IN keyword

     LIKE keyword 2nd

     logical operators 2nd

     NULL values 2nd

     unary operators

firing order of triggers 2nd 3rd

first normal form (1NF) 2nd

fixed roles

FLOOR() function

FOR XML clause (SELECT statement) 2nd

FOREIGN KEY constraints 2nd 3rd 4th

foreign keys 2nd

formatting data 2nd

Formula descriptor (columns)

FORWARD_ONLY cursors

fourth normal form

FROM clause (SELECT statement)

Full-Text catalogs 2nd

Full-Text indexes 2nd

full-text indexes 2nd

functions [See also global variables]

     ABS()

     ASCII()

     AVG()

     CAST() 2nd 3rd

     CEILING()

     CHAR()

     CHECKSUM()

     CHECKSUM_AGG()

     CHECKSUM_BINARY()

     COL_LENGTH()

     COL_NAME()

     CONVERT() 2nd

     COUNT()

     COUNT_BIG()

     DATALENGTH()

     DATEADD()

     DATEDIFF() 2nd

     DATENAME() 2nd

     DATEPART() 2nd

     DB_ID()

     DB_NAME()

     deterministic

     EXP()

     FLOOR()

     GETANSINULL()

     GETDATE()

     HOST_ID()

     HOST_NAME()

     IDENT_INCR()

     IDENT_SEED()

     INDEX_COL()

     ISNULL() 2nd

     LEN()

     LTRIM()

     MAX()

     MIN()

     nondeterministic 2nd

     NULLIF()

     OBJECT_ID()

     OBJECT_NAME()

     OPENQUERY

     OPENROWSET 2nd 3rd

     PATINDEX()

     PI()

     POWER()

     RAND()

     REPLICATE()

     REVERSE()

     ROUND()

     RTRIM()

     SPACE()

     SQRT()

     SQUARE()

     statistical functions 2nd 3rd

     STATS_DATE()

     STDDEV()

     STDDEVP()

     STUFF()

     SUBSTRING() 2nd 3rd

     SUM()

     SUSER_SID()

     SUSER_SNAME()

     T-SQL functions

     user-defined functions 2nd 3rd 4th

         creating 2nd

         definition of

     USER_ID()

     USER_NAME()

     VAR()

     VARP()