Kopieren und bearbeiten

Chapter 6 (Multiple Choice CIS 3365)

Beschreibung

asdf Quiz am Chapter 6 (Multiple Choice CIS 3365), erstellt von . . am 22/09/2016.
. .
Quiz von . ., aktualisiert more than 1 year ago
. .
Erstellt von . . vor etwa 8 Jahre
1236
3
0

Zusammenfassung der Ressource

Frage 1

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

Frage 2

Frage
2. 1NF, 2NF, and 3NF are ____.
Antworten
  • A) normalization stages
  • B) anomalies
  • C) repeating groups
  • D) atomic attributes

Frage 3

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

Frage 4

Frage
4.____ yields better performance.
Antworten
  • A) Denormalization
  • B) Normalization
  • C) Atomization
  • D) Compression

Frage 5

Frage
5. A table that displays data redundancies yields ____.
Antworten
  • A) consistencies
  • B) anomalies
  • C) fewer attributes
  • D) more entities

Frage 6

Frage
6. Data redundancy produces ____.
Antworten
  • A) slower lookups
  • B) robust design
  • C) efficient storage use
  • D) data integrity problems

Frage 7

Frage
7. Converting a ____ is not an example of denormalization.
Antworten
  • A) 3NF to 2NF
  • B) 2NF to 1NF
  • C) 3NF to 1NF
  • D) 3NF to BCNF

Frage 8

Frage
8. Some very specialized applications may require normalization beyond the ____.
Antworten
  • A) 1NF
  • B) 2NF
  • C) 3NF
  • D) 4NF

Frage 9

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

Frage 10

Frage
10.____ is not a valid normal form.
Antworten
  • A) 1NF
  • B) BCNF
  • C) 3NF
  • D) MVNF

Frage 11

Frage
11. A relation is not in 1NF if ____.
Antworten
  • 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

Frage 12

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

Frage 13

Frage
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.
Antworten
  • A) determines
  • B) derives from
  • C) controls
  • D) owns

Frage 14

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

Frage 15

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

Frage 16

Frage
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.
Antworten
  • A) PROJ_NUM --> PROJ_NAME
  • B) JOB_CLASS --> CHG_HOUR
  • C) PROJ_NUM, EMP_NUM --> HOURS
  • D) PROJ_NUM, EMP_NUM --> CHG_HOURS

Frage 17

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

Frage 18

Frage
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 ____.
Antworten
  • A) 1NF
  • B) 2NF
  • C) 3NF
  • D) 4NF

Frage 19

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

Frage 20

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

Frage 21

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

Frage 22

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

Frage 23

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

Frage 24

Frage
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.
Antworten
  • a. JOB_CHG_HOUR
  • b. CHARGES_PER_HOUR_FOR_JOB
  • c. CHARGES_PER_HOUR
  • d. CHG_HR

Frage 25

Frage
23. Improving ____ leads to more flexible queries.
Antworten
  • A) atomicity
  • B) normalization
  • C) denormalization
  • D) derived

Frage 26

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

Frage 27

Frage
25. The most likely data type for a surrogate key is ____
Antworten
  • A) Character
  • B) Date
  • C) Logical
  • D) Numeric

Frage 28

Frage
26. Granularity refers to ____.
Antworten
  • 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

Frage 29

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

Frage 30

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

Frage 31

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

Frage 32

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

Frage 33

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

Frage 34

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

Frage 35

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

Frage 36

Frage
34. A table is in 4NF if ____.
Antworten
  • 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

Frage 37

Frage
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 ____.
Antworten
  • A) 1NF
  • B) 2NF
  • C) 3NF
  • D) 4NF

Frage 38

Frage
36. When designing a database, you should ____.
Antworten
  • 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

Frage 39

Frage
37. Normalization represents a micro view of the ____ within the ERD.
Antworten
  • A) entities
  • B) attributes
  • C) relationships
  • D) forms

Frage 40

Frage
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.
Antworten
  • A) transitive
  • B) 3NF
  • C) component
  • D) temporary

Frage 41

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

Frage 42

Frage
40.____ databases reflect the ever-growing demand for greater scope and depth in the data on which decision support systems increasingly rely.
Antworten
  • A) Noramlized
  • B) Data warehouse
  • C) Temporary
  • D) Report
Zusammenfassung anzeigen Zusammenfassung ausblenden

Möchten Sie mit GoConqr kostenlos Ihre eigenen Quiz erstellen? eigenen Mehr erfahren.

ähnlicher Inhalt

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
Bibliothek durchsuchen