MCAD/MCSE/MCDBA 70-229 Exam Cram 2: Designing & Implementing Databases w/SQL Server 2000 Enterprise Edition

Terms you'll need to understand:

• RAID

• Gigabit

• Database

• Table

• Record

• Row

• Column

• Field

• Filegroups

• Clustered index

• Nonclustered index

• Trigger

• Primary key

• Foreign key

• Constraint

• Stored procedure

• Log file

• Model database

Techniques you'll need to master:

• Hardware setup/file placement

• Database creation

• Object creation

• Setting/altering properties

• Setting constraints