What do you call the elimination of redundant data?
normalization
de-duplication
loopbacking
reduxing
Which of the following indicates the elimination of repeating groups?
1NF
2NF
3NF
4NF
Which of the following indicates the elimination of redundant data?
Which of the following is not a condition for 1NF?
Table must have no duplicate records.
The table must have no multi-valued attributes.
There are no primary keys.
Entries in the column are of the same data type.
What would enable you to enforce the uniqueness property of columns, other than a primary key within a table?
secondary key
constant check
validator
unique constraint key
What is an attribute or set of attributes that can be used to uniquely identify the row?
primary key
second key
foreign key
What key is replicated from the primary key of one table to a secondary table, and then all the key attributes get duplicated from the primary table?
What type of index sorts the data stored inside the table?
clustered index
non-clustered index
quick index
primary index
What type of index has an index key value that points to a data row, which contains the key value?
nonclustered index
What type of field would you make an employee ID?
standard key
If you define a primary key, which of the following levels have you reached?
Which level eliminates columns not dependent on keys?
Which level of is reached by using primary keys on a table within a SQL Server database?
What structures are used when storing keys for a clustered index?
root tree
reverse root tree
B-tree
alphabetical
Which type of index uses pointers that point to row location?
