9636745
Descripción
Test por Hawerth Castro, actualizado hace más de 1 año
|
Creado por Hawerth Castro
hace casi 7 años
|
|
Pregunta 1
Pregunta
What do you call the elimination of redundant data?
Respuesta
-
normalization
-
de-duplication
-
loopbacking
-
reduxing
Pregunta 2
Pregunta
Which of the following indicates the elimination of repeating groups?
Respuesta
-
1NF
-
2NF
-
3NF
-
4NF
Pregunta 3
Pregunta
Which of the following indicates the elimination of redundant data?
Respuesta
-
1NF
-
2NF
-
3NF
-
4NF
Pregunta 4
Pregunta
Which of the following is not a condition for 1NF?
Respuesta
-
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.
Pregunta 5
Pregunta
What would enable you to enforce the uniqueness property of columns, other than a primary key within a table?
Respuesta
-
secondary key
-
constant check
-
validator
-
unique constraint key
Pregunta 6
Pregunta
What is an attribute or set of attributes that can be used to uniquely identify the row?
Respuesta
-
primary key
-
second key
-
unique constraint key
-
foreign key
Pregunta 7
Pregunta
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?
Respuesta
-
primary key
-
second key
-
unique constraint key
-
foreign key
Pregunta 8
Pregunta
What type of index sorts the data stored inside the table?
Respuesta
-
clustered index
-
non-clustered index
-
quick index
-
primary index
Pregunta 9
Pregunta
What type of index has an index key value that points to a data row, which contains the key value?
Respuesta
-
clustered index
-
nonclustered index
-
quick index
-
primary index
Pregunta 10
Pregunta
What type of field would you make an employee ID?
Respuesta
-
standard key
-
foreign key
-
unique constraint key
-
secondary key
Pregunta 11
Pregunta
If you define a primary key, which of the following levels have you reached?
Respuesta
-
1NF
-
2NF
-
3NF
-
4NF
Pregunta 12
Pregunta
Which level eliminates columns not dependent on keys?
Respuesta
-
1NF
-
2NF
-
3NF
-
4NF
Pregunta 13
Pregunta
Which level of is reached by using primary keys on a table within a SQL Server database?
Respuesta
-
1NF
-
2NF
-
3NF
-
4NF
Pregunta 14
Pregunta
What structures are used when storing keys for a clustered index?
Respuesta
-
root tree
-
reverse root tree
-
B-tree
-
alphabetical
Pregunta 15
Pregunta
Which type of index uses pointers that point to row location?
Respuesta
-
clustered index
-
nonclustered index
-
quick index
-
primary index
¿Quieres crear tus propios Tests gratis con GoConqr? Más información.