6425490
Pregunta 1
Pregunta
1. Normalization works through a series of stages called normal forms.
Respuesta
- True
- False
Pregunta 2
Pregunta
2. Normalization produces a lower normal form.
Respuesta
- True
- False
Pregunta 3
Pregunta
3. Normalization is a process that is used for changing attributes to entities.
Respuesta
- True
- False
Pregunta 4
Pregunta
4. In order to meet performance requirements, you may have to denormalize portions of the database design.
Respuesta
- True
- False
Pregunta 5
Pregunta
5. Denormalization produces a lower normal form.
Respuesta
- True
- False
Pregunta 6
Pregunta
6. Normalization is a very important database design ingredient and the highest level is always the most desirable.
Respuesta
- True
- False
Pregunta 7
Pregunta
7. A table is in BCNF if every determinant in the table is a candidate key.
Respuesta
- True
- False
Pregunta 8
Pregunta
8. A table is in BCNF if every determinant in the table is a foreign key
Respuesta
- True
- False
Pregunta 9
Pregunta
9. A table is in fourth normal form if it is in third normal form and has no independent multivalued dependencies.
Respuesta
- True
- False
Pregunta 10
Pregunta
10. Relational models view the data as part of a table or collection of tables in which all key values must be identified.
Respuesta
- True
- False
Pregunta 11
Pregunta
11. Repeating groups must be eliminated by making sure that each row defines a single entity
Respuesta
- True
- False
Pregunta 12
Pregunta
12. Dependency diagrams are very helpful in getting a bird’s-eye view of all the relationships among a table’s attributes.
Respuesta
- True
- False
Pregunta 13
Pregunta
13. Dependencies that are based on only a part of a composite primary key are called transitive dependencies.
Respuesta
- True
- False
Pregunta 14
Pregunta
14. All relational tables satisfy the 1NF requirements.
Respuesta
- True
- False
Pregunta 15
Pregunta
15. With partial dependencies, data redundancies occur because every row entry requires duplication of data.
Respuesta
- True
- False
Pregunta 16
Pregunta
16. Converting a database format from 1NF to 2NF is a complex process.
Respuesta
- True
- False
Pregunta 17
Pregunta
17. Because a partial dependency can exist only if a table's primary key is composed of several attributes, if a table in 1NF has a single-attribute primary key, then the table is automatically in 2NF.
Respuesta
- True
- False
Pregunta 18
Pregunta
18. A table is in 2NF if it is in 1NF and it includes no partial dependencies.
Respuesta
- True
- False
Pregunta 19
Pregunta
19. It is possible for a table in 2NF to exhibit transitive dependency, where one or more nonprime attributes functionally determine other nonprime attributes.
Respuesta
- True
- False
Pregunta 20
Pregunta
20. A determinant is any attribute whose value determines other values within a column.
Respuesta
- True
- False
Pregunta 21
Pregunta
21. A dependency of one nonprime attribute on another nonprime attribute is a partial dependency.
Respuesta
- True
- False
Pregunta 22
Pregunta
22. Atomic attributes are attributes that can be further divided
Respuesta
- True
- False
Pregunta 23
Pregunta
23. Normalization should be part of the design process.
Respuesta
- True
- False
Pregunta 24
Pregunta
24. Normalization represents a micro view of the entities within the ERD.
Respuesta
- True
- False
Pregunta 25
Pregunta
25. The combination of normalization and ER modeling yields a useful ERD, whose entities may now be translated into appropriate relationship structures.
Respuesta
- True
- False
Pregunta 26
Pregunta
26. A good relational DBMS excels at managing denormalized relations.
Respuesta
- True
- False
Pregunta 27
Pregunta
27. The advantage of higher processing speed must be carefully weighed against the disadvantage of data anomalies.
Respuesta
- True
- False
Pregunta 28
Pregunta
28. Normalization purity is easy to sustain in the modern database environment.
Respuesta
- True
- False
Pregunta 29
Pregunta
29. Unnormalized database tables often lead to various data redundancy disasters in production databases.
Respuesta
- True
- False
Pregunta 30
Pregunta
30. Attributes should clearly define participation, connectivity, and document cardinality.
Respuesta
- True
- False
Pregunta 31
Pregunta
31. Repeating groups must be eliminated by making sure that each column defines a single entity
Respuesta
- True
- False
Pregunta 32
Pregunta
32. Dependencies can be identified with the help of the dependency diagram.
Respuesta
- True
- False
Pregunta 33
Pregunta
33. Data redundancies are caused by the fact that every row entry requires duplication of data
Respuesta
- True
- False
¿Quieres crear tus propios Tests gratis con GoConqr? Más información.