Copy and Edit

Chapter 6 (Multiple Choice CIS 3365)

Description

asdf Quiz on Chapter 6 (Multiple Choice CIS 3365), created by . . on 22/09/2016.
. .
Quiz by . ., updated more than 1 year ago
. .
Created by . . over 7 years ago
1160
3
0

Resource summary

Question 1

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

Question 2

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

Question 3

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

Question 4

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

Question 5

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

Question 6

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

Question 7

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

Question 8

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

Question 9

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

Question 10

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

Question 11

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

Question 12

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

Question 13

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

Question 14

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

Question 15

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

Question 16

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

Question 17

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

Question 18

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

Question 19

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

Question 20

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

Question 21

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

Question 22

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

Question 23

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

Question 24

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

Question 25

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

Question 26

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

Question 27

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

Question 28

Question
26. Granularity refers to ____.
Answer
  • 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

Question 29

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

Question 30

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

Question 31

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

Question 32

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

Question 33

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

Question 34

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

Question 35

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

Question 36

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

Question 37

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

Question 38

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

Question 39

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

Question 40

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

Question 41

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

Question 42

Question
40.____ databases reflect the ever-growing demand for greater scope and depth in the data on which decision support systems increasingly rely.
Answer
  • A) Noramlized
  • B) Data warehouse
  • C) Temporary
  • D) Report
Show full summary Hide full summary

Want to create your own Quizzes for free with GoConqr? Learn more.

Similar

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
Effective Citizens
Lauren Petrouleas
asdfas
bevan7
Funciones Polinomiales
Julieta Maya
10.THE VALUATION PROCESS AND PRICING PROPERTIES
Brigita Safyra
S C I E X
guohao.lam
Perspectives of learning
nilemon
Mind Idea
rodrigo.cespedes
Browse Library