Copiar e Editar

Chapter 6 (Multiple Choice CIS 3365)

Descrição

asdf Quiz sobre Chapter 6 (Multiple Choice CIS 3365), criado por . . em 22-09-2016.
. .
Quiz por . ., atualizado more than 1 year ago
. .
Criado por . . aproximadamente 8 anos atrás
1236
3
0

Resumo de Recurso

Questão 1

Questão
1. Normalization works through a series of stages called normal forms. Typically ____ stages are processed.
Responda
  • A) two
  • B) three
  • C) four
  • D) five

Questão 2

Questão
2. 1NF, 2NF, and 3NF are ____.
Responda
  • A) normalization stages
  • B) anomalies
  • C) repeating groups
  • D) atomic attributes

Questão 3

Questão
3. From a structural point of view, 2NF is better than ____.
Responda
  • A) 1NF
  • B) 3NF
  • C) 4NF
  • D) BCNF

Questão 4

Questão
4.____ yields better performance.
Responda
  • A) Denormalization
  • B) Normalization
  • C) Atomization
  • D) Compression

Questão 5

Questão
5. A table that displays data redundancies yields ____.
Responda
  • A) consistencies
  • B) anomalies
  • C) fewer attributes
  • D) more entities

Questão 6

Questão
6. Data redundancy produces ____.
Responda
  • A) slower lookups
  • B) robust design
  • C) efficient storage use
  • D) data integrity problems

Questão 7

Questão
7. Converting a ____ is not an example of denormalization.
Responda
  • A) 3NF to 2NF
  • B) 2NF to 1NF
  • C) 3NF to 1NF
  • D) 3NF to BCNF

Questão 8

Questão
8. Some very specialized applications may require normalization beyond the ____.
Responda
  • A) 1NF
  • B) 2NF
  • C) 3NF
  • D) 4NF

Questão 9

Questão
9. Of the following normal forms,____, is mostly of theoretical interest.
Responda
  • A) 3NF
  • B) 1NF
  • C) BCNF
  • D) DKNF

Questão 10

Questão
10.____ is not a valid normal form.
Responda
  • A) 1NF
  • B) BCNF
  • C) 3NF
  • D) MVNF

Questão 11

Questão
11. A relation is not in 1NF if ____.
Responda
  • 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

Questão 12

Questão
12. A(n) ____ should not be placed in a relational table.
Responda
  • A) entity
  • B) attribute
  • C) relationship
  • D) repeating grouop

Questão 13

Questão
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.
Responda
  • A) determines
  • B) derives from
  • C) controls
  • D) owns

Questão 14

Questão
14. Dependencies based on only a part of a composite primary key are called ____ dependencies.
Responda
  • A) primary
  • B) partial
  • C) imcomplete
  • D) composite

Questão 15

Questão
15. An attribute that is part of a key is known as a(n) ____ attribute.
Responda
  • A) important
  • B) nonprime
  • C) prime
  • D) entity

Questão 16

Questão
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.
Responda
  • A) PROJ_NUM --> PROJ_NAME
  • B) JOB_CLASS --> CHG_HOUR
  • C) PROJ_NUM, EMP_NUM --> HOURS
  • D) PROJ_NUM, EMP_NUM --> CHG_HOURS

Questão 17

Questão
17. In a(n) ____ diagram, the arrows above the attributes indicate all desirable dependencies
Responda
  • A) Chen
  • B) dependency
  • C) functionality
  • D) ER

Questão 18

Questão
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 ____.
Responda
  • A) 1NF
  • B) 2NF
  • C) 3NF
  • D) 4NF

Questão 19

Questão
17. A table that is in 1NF and includes no partial dependencies is said to be in ____.
Responda
  • A) BCNF
  • B) 2NF
  • C) 3NF
  • D) 4NF

Questão 20

Questão
18. If you have three different transitive dependencies, ____ different determinant(s) exist.
Responda
  • A) one
  • B) two
  • C) three
  • D) four

Questão 21

Questão
19. Before converting a table into 3NF, it is imperative the table already be in ____.
Responda
  • A) 1NF
  • B) 2NF
  • C) 4NF
  • D) BCNF

Questão 22

Questão
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.
Responda
  • A) Boyce-Codd Normal Form
  • B) redundancy
  • C) time-variance
  • D) partial dependencies

Questão 23

Questão
21. A table that is in 2NF and contains no transitive dependencies is said to be in ____.
Responda
  • A) 1NF
  • B) 2NF
  • C) 3NF
  • D) 4NF

Questão 24

Questão
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.
Responda
  • a. JOB_CHG_HOUR
  • b. CHARGES_PER_HOUR_FOR_JOB
  • c. CHARGES_PER_HOUR
  • d. CHG_HR

Questão 25

Questão
23. Improving ____ leads to more flexible queries.
Responda
  • A) atomicity
  • B) normalization
  • C) denormalization
  • D) derived

Questão 26

Questão
24. An atomic attribute ____.
Responda
  • A) cannot exist in a relational table
  • B) cannot be further subdivided
  • C) displays multiplicity
  • D) is always chosen to be a foreign key

Questão 27

Questão
25. The most likely data type for a surrogate key is ____
Responda
  • A) Character
  • B) Date
  • C) Logical
  • D) Numeric

Questão 28

Questão
26. Granularity refers to ____.
Responda
  • 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

Questão 29

Questão
27. From a strictly database point of view, ____ attribute values can be calculated when they are needed to write reports or invoices.
Responda
  • A) derived
  • B) atomic
  • C) granular
  • D) historical

Questão 30

Questão
28. In a real-world environment, we must strike a balance between design integrity and ____.
Responda
  • A) robustness
  • B) flexibility
  • C) uniqueness
  • D) ease of use

Questão 31

Questão
29. For most business transactional databases, we should normalize relations into ____.
Responda
  • A) 1NF
  • B) 2NF
  • C) 3NF
  • D) 6NF

Questão 32

Questão
30. To generate a surrogate key, Microsoft Access uses a(n) ____ data type.
Responda
  • A) surrogate
  • B) sequence
  • C) Autonumber
  • D) identity

Questão 33

Questão
31. A table where every determinant is a candidate key is said to be in ____.
Responda
  • A) BCNF
  • B) 2NF
  • C) 3NF
  • D) 4NF

Questão 34

Questão
32. BCNF can be violated only if the table contains more than one ____ key.
Responda
  • A) primary
  • B) candidate
  • C) foreign
  • D) secondary

Questão 35

Questão
33. Most designers consider the BCNF as a special case of the ____
Responda
  • A) 1NF
  • B) 2NF
  • C) 3NF
  • D) 4NF

Questão 36

Questão
34. A table is in 4NF if ____.
Responda
  • 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

Questão 37

Questão
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 ____.
Responda
  • A) 1NF
  • B) 2NF
  • C) 3NF
  • D) 4NF

Questão 38

Questão
36. When designing a database, you should ____.
Responda
  • 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

Questão 39

Questão
37. Normalization represents a micro view of the ____ within the ERD.
Responda
  • A) entities
  • B) attributes
  • C) relationships
  • D) forms

Questão 40

Questão
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.
Responda
  • A) transitive
  • B) 3NF
  • C) component
  • D) temporary

Questão 41

Questão
39. The conflicts between design efficiency, information requirements, and processing speed are often resolved through ____.
Responda
  • A) conversion from 1NF to 2NF
  • B) conversion from 2NF to 3NF
  • C) compromises that include denormalization
  • D) conversion from 3NF to 4NF

Questão 42

Questão
40.____ databases reflect the ever-growing demand for greater scope and depth in the data on which decision support systems increasingly rely.
Responda
  • A) Noramlized
  • B) Data warehouse
  • C) Temporary
  • D) Report

Quer criar seus próprios Quizzes gratuitos com a GoConqr? Saiba mais.

Semelhante

El Perdón
Alonso Linares
Investiga las transformaciones de la cultura y de la vida cotidiana a lo largo del tiempo.
Sherlyn Muñoz
Irene
i.biza
Sean doce balines (a,b,c,d,e,f,g,h,i,j,k,l)
andres parra
Funciones Polinomiales
Julieta Maya
10.THE VALUATION PROCESS AND PRICING PROPERTIES
Brigita Safyra
Effective Citizens
Lauren Petrouleas
asdfas
bevan7
S C I E X
guohao.lam
Perspectives of learning
nilemon
Mind Idea
rodrigo.cespedes
Explore a Biblioteca