9636745
Descrição
Quiz por Hawerth Castro, atualizado more than 1 year ago
|
Criado por Hawerth Castro
mais de 7 anos atrás
|
|
Questão 1
Questão
What do you call the elimination of redundant data?
Responda
-
normalization
-
de-duplication
-
loopbacking
-
reduxing
Questão 2
Questão
Which of the following indicates the elimination of repeating groups?
Responda
-
1NF
-
2NF
-
3NF
-
4NF
Questão 3
Questão
Which of the following indicates the elimination of redundant data?
Responda
-
1NF
-
2NF
-
3NF
-
4NF
Questão 4
Questão
Which of the following is not a condition for 1NF?
Responda
-
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.
Questão 5
Questão
What would enable you to enforce the uniqueness property of columns, other than a primary key within a table?
Responda
-
secondary key
-
constant check
-
validator
-
unique constraint key
Questão 6
Questão
What is an attribute or set of attributes that can be used to uniquely identify the row?
Responda
-
primary key
-
second key
-
unique constraint key
-
foreign key
Questão 7
Questão
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?
Responda
-
primary key
-
second key
-
unique constraint key
-
foreign key
Questão 8
Questão
What type of index sorts the data stored inside the table?
Responda
-
clustered index
-
non-clustered index
-
quick index
-
primary index
Questão 9
Questão
What type of index has an index key value that points to a data row, which contains the key value?
Responda
-
clustered index
-
nonclustered index
-
quick index
-
primary index
Questão 10
Questão
What type of field would you make an employee ID?
Responda
-
standard key
-
foreign key
-
unique constraint key
-
secondary key
Questão 11
Questão
If you define a primary key, which of the following levels have you reached?
Responda
-
1NF
-
2NF
-
3NF
-
4NF
Questão 12
Questão
Which level eliminates columns not dependent on keys?
Responda
-
1NF
-
2NF
-
3NF
-
4NF
Questão 13
Questão
Which level of is reached by using primary keys on a table within a SQL Server database?
Responda
-
1NF
-
2NF
-
3NF
-
4NF
Questão 14
Questão
What structures are used when storing keys for a clustered index?
Responda
-
root tree
-
reverse root tree
-
B-tree
-
alphabetical
Questão 15
Questão
Which type of index uses pointers that point to row location?
Responda
-
clustered index
-
nonclustered index
-
quick index
-
primary index
Quer criar seus próprios Quizzes gratuitos com a GoConqr? Saiba mais.