9636745
Description
Quiz by Hawerth Castro, updated more than 1 year ago
|
Created by Hawerth Castro
over 7 years ago
|
|
Question 1
Question
What do you call the elimination of redundant data?
Answer
-
normalization
-
de-duplication
-
loopbacking
-
reduxing
Question 2
Question
Which of the following indicates the elimination of repeating groups?
Answer
-
1NF
-
2NF
-
3NF
-
4NF
Question 3
Question
Which of the following indicates the elimination of redundant data?
Answer
-
1NF
-
2NF
-
3NF
-
4NF
Question 4
Question
Which of the following is not a condition for 1NF?
Answer
-
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.
Question 5
Question
What would enable you to enforce the uniqueness property of columns, other than a primary key within a table?
Answer
-
secondary key
-
constant check
-
validator
-
unique constraint key
Question 6
Question
What is an attribute or set of attributes that can be used to uniquely identify the row?
Answer
-
primary key
-
second key
-
unique constraint key
-
foreign key
Question 7
Question
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
-
primary key
-
second key
-
unique constraint key
-
foreign key
Question 8
Question
What type of index sorts the data stored inside the table?
Answer
-
clustered index
-
non-clustered index
-
quick index
-
primary index
Question 9
Question
What type of index has an index key value that points to a data row, which contains the key value?
Answer
-
clustered index
-
nonclustered index
-
quick index
-
primary index
Question 10
Question
What type of field would you make an employee ID?
Answer
-
standard key
-
foreign key
-
unique constraint key
-
secondary key
Question 11
Question
If you define a primary key, which of the following levels have you reached?
Answer
-
1NF
-
2NF
-
3NF
-
4NF
Question 12
Question
Which level eliminates columns not dependent on keys?
Answer
-
1NF
-
2NF
-
3NF
-
4NF
Question 13
Question
Which level of is reached by using primary keys on a table within a SQL Server database?
Answer
-
1NF
-
2NF
-
3NF
-
4NF
Question 14
Question
What structures are used when storing keys for a clustered index?
Answer
-
root tree
-
reverse root tree
-
B-tree
-
alphabetical
Question 15
Question
Which type of index uses pointers that point to row location?
Answer
-
clustered index
-
nonclustered index
-
quick index
-
primary index
Want to create your own Quizzes for free with GoConqr? Learn more.