MTA DAF 4

Question 1

Which type of index uses pointers that point to row location?

Answer 1

nonclustered index

Question 2

What would enable you to enforce the uniqueness property of columns, other than a primary key within a table?

Answer 2

unique constraint key

Question 3

What type of field would you make an employee ID?

Answer 3

unique constraint key

Question 4

Which normalization form indicates the elimination of repeating groups?

Answer 4

1NF

Question 5

If you define a primary key, which of the following levels have you reached?

Answer 5

1NF

Question 6

What is an attribute or set of attributes that can be used to uniquely identify the row?

Answer 6

primary key

Question 7

Which normalization form indicates the elimination of redundant data?

Answer 7

2NF

Question 8

What type of index has an index key value that points to a data row, which contains the key value?

Answer 8

nonclustered index

Question 9

What do you call the elimination of redundant data?

Answer 9

normalization

Question 10

What structures are used when storing keys for a clustered index?

Answer 10

B-Tree

Question 11

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?

Answer 11

foreign key

Question 12

Which level eliminates columns not dependent on key?

Answer 12

3NF

Question 13

What type of index sorts the data stored inside the table?

Answer 13

clustered index

Question 14

Which of the following is not a condition for 1NF?

• Table must have no duplicate records.
• The table must have no multi-valued attributes.
• Entries in the column are of the same data type.
• There are no primary keys.

Answer 14

There are no primary keys

Question 15

Which level of is reached by using primary keys on table within a SQL Server database?

Answer 15

1NF