6425731
Pregunta 1
Pregunta
1. Normalization works through a series of stages called normal forms. Typically ____ stages are processed.
Respuesta
-
A) two
-
B) three
-
C) four
-
D) five
Pregunta 2
Pregunta
2. 1NF, 2NF, and 3NF are ____.
Respuesta
-
A) normalization stages
-
B) anomalies
-
C) repeating groups
-
D) atomic attributes
Pregunta 3
Pregunta
3. From a structural point of view, 2NF is better than ____.
Respuesta
-
A) 1NF
-
B) 3NF
-
C) 4NF
-
D) BCNF
Pregunta 4
Pregunta
4.____ yields better performance.
Respuesta
-
A) Denormalization
-
B) Normalization
-
C) Atomization
-
D) Compression
Pregunta 5
Pregunta
5. A table that displays data redundancies yields ____.
Respuesta
-
A) consistencies
-
B) anomalies
-
C) fewer attributes
-
D) more entities
Pregunta 6
Pregunta
6. Data redundancy produces ____.
Respuesta
-
A) slower lookups
-
B) robust design
-
C) efficient storage use
-
D) data integrity problems
Pregunta 7
Pregunta
7. Converting a ____ is not an example of denormalization.
Respuesta
-
A) 3NF to 2NF
-
B) 2NF to 1NF
-
C) 3NF to 1NF
-
D) 3NF to BCNF
Pregunta 8
Pregunta
8. Some very specialized applications may require normalization beyond the ____.
Respuesta
-
A) 1NF
-
B) 2NF
-
C) 3NF
-
D) 4NF
Pregunta 9
Pregunta
9. Of the following normal forms,____, is mostly of theoretical interest.
Respuesta
-
A) 3NF
-
B) 1NF
-
C) BCNF
-
D) DKNF
Pregunta 10
Pregunta
10.____ is not a valid normal form.
Respuesta
-
A) 1NF
-
B) BCNF
-
C) 3NF
-
D) MVNF
Pregunta 11
Pregunta
11. A relation is not in 1NF if ____.
Respuesta
-
A) it has multiple candidate keys
-
B) all of the key attributes are defined
-
C) there are repeating groups in the table
-
D) all attributes are dependent on the primary key
Pregunta 12
Pregunta
12. A(n) ____ should not be placed in a relational table.
Respuesta
-
A) entity
-
B) attribute
-
C) relationship
-
D) repeating grouop
Pregunta 13
Pregunta
13. Attribute A ____ attribute B if all of the rows in the table that agree in value for attribute A also agree in value for attribute B.
Respuesta
-
A) determines
-
B) derives from
-
C) controls
-
D) owns
Pregunta 14
Pregunta
14. Dependencies based on only a part of a composite primary key are called ____ dependencies.
Respuesta
-
A) primary
-
B) partial
-
C) imcomplete
-
D) composite
Pregunta 15
Pregunta
15. An attribute that is part of a key is known as a(n) ____ attribute.
Respuesta
-
A) important
-
B) nonprime
-
C) prime
-
D) entity
Pregunta 16
Pregunta
16. Given the table EMP_PROJ (PROJ_NUM, EMP_NUM, PROJ_NAME, EMP_NAME, JOB_CLASS, CHG_HOURS, HOURS),of the following,____, is a partial dependency.
Respuesta
-
A) PROJ_NUM --> PROJ_NAME
-
B) JOB_CLASS --> CHG_HOUR
-
C) PROJ_NUM, EMP_NUM --> HOURS
-
D) PROJ_NUM, EMP_NUM --> CHG_HOURS
Pregunta 17
Pregunta
17. In a(n) ____ diagram, the arrows above the attributes indicate all desirable dependencies
Respuesta
-
A) Chen
-
B) dependency
-
C) functionality
-
D) ER
Pregunta 18
Pregunta
18. A table that has all key attributes defined, has no repeating groups, and all its attributes are dependent on the primary key, is said to be in ____.
Respuesta
-
A) 1NF
-
B) 2NF
-
C) 3NF
-
D) 4NF
Pregunta 19
Pregunta
17. A table that is in 1NF and includes no partial dependencies is said to be in ____.
Respuesta
-
A) BCNF
-
B) 2NF
-
C) 3NF
-
D) 4NF
Pregunta 20
Pregunta
18. If you have three different transitive dependencies, ____ different determinant(s) exist.
Respuesta
-
A) one
-
B) two
-
C) three
-
D) four
Pregunta 21
Pregunta
19. Before converting a table into 3NF, it is imperative the table already be in ____.
Respuesta
-
A) 1NF
-
B) 2NF
-
C) 4NF
-
D) BCNF
Pregunta 22
Pregunta
20. If a table has multiple candidate keys and one of those candidate keys is a composite key, the table can have ____ based on this composite candidate key, even when the primary key chosen is a single attribute.
Respuesta
-
A) Boyce-Codd Normal Form
-
B) redundancy
-
C) time-variance
-
D) partial dependencies
Pregunta 23
Pregunta
21. A table that is in 2NF and contains no transitive dependencies is said to be in ____.
Respuesta
-
A) 1NF
-
B) 2NF
-
C) 3NF
-
D) 4NF
Pregunta 24
Pregunta
22. According to naming conventions described in Chapter 2, ____ would be the best name for a column representing the charges per hour in a table named JOB.
Respuesta
-
a. JOB_CHG_HOUR
-
b. CHARGES_PER_HOUR_FOR_JOB
-
c. CHARGES_PER_HOUR
-
d. CHG_HR
Pregunta 25
Pregunta
23. Improving ____ leads to more flexible queries.
Respuesta
-
A) atomicity
-
B) normalization
-
C) denormalization
-
D) derived
Pregunta 26
Pregunta
24. An atomic attribute ____.
Respuesta
-
A) cannot exist in a relational table
-
B) cannot be further subdivided
-
C) displays multiplicity
-
D) is always chosen to be a foreign key
Pregunta 27
Pregunta
25. The most likely data type for a surrogate key is ____
Respuesta
-
A) Character
-
B) Date
-
C) Logical
-
D) Numeric
Pregunta 28
Pregunta
26. Granularity refers to ____.
Respuesta
-
A) the size of a table
-
B) the level of detail represented by the values stored in a table's tow
-
C) the number of attributes in a table
-
D) the number of rows in a table
Pregunta 29
Pregunta
27. From a strictly database point of view, ____ attribute values can be calculated when they are needed to write reports or invoices.
Respuesta
-
A) derived
-
B) atomic
-
C) granular
-
D) historical
Pregunta 30
Pregunta
28. In a real-world environment, we must strike a balance between design integrity and ____.
Respuesta
-
A) robustness
-
B) flexibility
-
C) uniqueness
-
D) ease of use
Pregunta 31
Pregunta
29. For most business transactional databases, we should normalize relations into ____.
Respuesta
-
A) 1NF
-
B) 2NF
-
C) 3NF
-
D) 6NF
Pregunta 32
Pregunta
30. To generate a surrogate key, Microsoft Access uses a(n) ____ data type.
Respuesta
-
A) surrogate
-
B) sequence
-
C) Autonumber
-
D) identity
Pregunta 33
Pregunta
31. A table where every determinant is a candidate key is said to be in ____.
Respuesta
-
A) BCNF
-
B) 2NF
-
C) 3NF
-
D) 4NF
Pregunta 34
Pregunta
32. BCNF can be violated only if the table contains more than one ____ key.
Respuesta
-
A) primary
-
B) candidate
-
C) foreign
-
D) secondary
Pregunta 35
Pregunta
33. Most designers consider the BCNF as a special case of the ____
Respuesta
-
A) 1NF
-
B) 2NF
-
C) 3NF
-
D) 4NF
Pregunta 36
Pregunta
34. A table is in 4NF if ____.
Respuesta
-
a. all attributes must be dependent on the primary key, and must be dependent on each other
-
b. all attributes are unrelated
-
c. no row can contain two or more multivalued facts about an entity
-
d. no column contains the same values
Pregunta 37
Pregunta
35. A table where all attributes are dependent on the primary key and are independent of each other, and no row contains two or more multivalued facts about an entity, is said to be in ____.
Respuesta
-
A) 1NF
-
B) 2NF
-
C) 3NF
-
D) 4NF
Pregunta 38
Pregunta
36. When designing a database, you should ____.
Respuesta
-
a. make sure entities are in normal form before table structures are created
-
b. create table structures then normalize the database
-
c. only normalize the database when performance problems occur
-
d. consider more important issues such as performance before normalizing
Pregunta 39
Pregunta
37. Normalization represents a micro view of the ____ within the ERD.
Respuesta
-
A) entities
-
B) attributes
-
C) relationships
-
D) forms
Pregunta 40
Pregunta
38. An example of denormalization is using a ____ denormalized table to hold report data. This is required when creating a tabular report in which the columns represent data that is stored in the table as rows.
Respuesta
-
A) transitive
-
B) 3NF
-
C) component
-
D) temporary
Pregunta 41
Pregunta
39. The conflicts between design efficiency, information requirements, and processing speed are often resolved through ____.
Respuesta
-
A) conversion from 1NF to 2NF
-
B) conversion from 2NF to 3NF
-
C) compromises that include denormalization
-
D) conversion from 3NF to 4NF
Pregunta 42
Pregunta
40.____ databases reflect the ever-growing demand for greater scope and depth in the data on which decision support systems increasingly rely.
Respuesta
-
A) Noramlized
-
B) Data warehouse
-
C) Temporary
-
D) Report
¿Quieres crear tus propios Tests gratis con GoConqr? Más información.