Question 1

Data warehouse routinely uses ____ structures in its complex, multilevel, multi source data?

Accepted Answer

2NF

Question 2

In a ____ situation, one key determines multiple values of two other attributes and those attributes are independent of each other

Accepted Answer

MULTIVALUED dependency

Question 3

A relational table must not contain a(n) _____

Accepted Answer

REPEATING GROUP

Question 4

From a structure point of view, 3NF is better than ____

Accepted Answer

2NF

Question 5

For most businesses transactional databases, we should normalize relations into ____

Accepted Answer

3NF

Question 6

Dependacies based on only part of a composite primary key are known as ____ dependancies

Accepted Answer

Partial

Question 7

If you have three different transistive dependencies, _____ different determinant(s) exist  a)1  b)2  c)3  d)4

Accepted Answer

c)3

Question 8

an atomic attribute ______  a) cannot exist in a relational table  b) cannot be further subdived  c) displays multiplicity  d) is always chosen to be a foreign key

Accepted Answer

b) cannot be further subdivided

Question 9

a table that is 1NF and includes no partial dependencies is said to be in _____  a)BCNF  b)2NF  c)3NF  d) 4NF

Accepted Answer

b) 2NF

Question 10

_____ yields better performance  a)Denormalization  b)Normaliation  c)Atomization  d)Compression

Accepted Answer

a) Denormalization

Question 11

an example of denormalization is using a ____ denormalization table to hold report data. This is required when creating a tabular report in which the columns represent data that are  a) transitive  b) 3NF  c) component  d) temporary

Accepted Answer

d) temporary

Question 12

Before converting a table into 3NF, it is imperative that the table already be in ____  a) 1NF  b) 2NF  c) 4NF  d) BCNF

Accepted Answer

b)2NF

Question 13

A table that displays data redundancies yields ____  a) consistancies  b) anomalies  c) fewer attributes  d) more entities

Accepted Answer

b) anomalies

Question 14

A table that is in 2NF and contains no transtive dependencies is said to be in _____  a) 1NF  b) 2NF  c) 3NF  d) 4NF

Accepted Answer

c) 3NF

Question 15

Some very specialized applications may require normalization beyond the ____  a) 1NF  b) 2NF   c) 3NF  d) 4NF

Accepted Answer

d) 4NF

Question 16

Normalization works through a series of stages called normal forms. For most purposes in business database design _____ stages are as high as you need to go in the normalization  a) 2  b) 3  c) 4  d) 5

Accepted Answer

b) 3

Question 17

In a(n) _____ diagram the arrows above the attributes indicate all the desirable dependencies  a) Chen  b) dependency  c) functionality  d) ER

Accepted Answer

b) dependency

Question 18

____ databases reflect the evergrowing demand for greater scope and depth in the data on which decision support systems increasingly reply  a)normalized  b) datawarehouse  c) temporary

Accepted Answer

b) datawarehouse

Question 19

an attribute that is part of a key is known as a(n) ____ atrribute  a) important  b) nonprime  c) prime  d) entity

Accepted Answer

c) prime

Question 20

a table where all attributes are dependent on the but are independent of eachother, and no row contains two or more multivalued facts about an entity is said to be in _____  a) 1NF  b) 2NF  c) 3NF  d) 4NF

Accepted Answer

d) 4NF

Question 21

A table where every determinant is a candidate key is said to be in ____  a) BCNF  b) 2NF  c) 1NF  d) 4NF

Accepted Answer

a) BCNF

Question 22

A ____ derives its name from the fact that a collection of multiple entries of the same type can exist for any single key attribute occurrence  a) partial dependency  b) transitive dependency  c) repeating group  d) primary key

Accepted Answer

c) repeating group

Question 23

Improving ____ leads to more flexible queries  a) atomicity  b) Normalization  c) denormalization  d) derived attribute

Accepted Answer

a) atomicity

Question 24

1NF, 2NF, and 3NF are ______  a) normalization stages  b) anomalies  c) repeating groups  d) atomic attributes

Accepted Answer

a) normalization stages

Question 25

To generate a surrogate key, Microsoft Access uses a(n) ______ data type.  a) character  b) sequence  c) AutoNumber  d) Identity

Accepted Answer

c) AutoNumber

Question 26

of the following normal forms, ____ is mostly of theoretical interest.  a) 1NF  b) 3NF  c) BCNF  d) DKNF

Accepted Answer

d) DKNF

Question 27

Most Designers consider the BCNF as a special case of the _____  a) 1NF  b) 2NF  c) 3NF  d) 4NF

Accepted Answer

c) 3NF

Question 28

In the real-world environment, we must strike a balance between design integrity and _____  a) robustness  b) flexibility  c) uniqueness  d) ease of use

Accepted Answer

b) flexibility

Question 29

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  a) determines  b) derives from  c) controls  d) owns

Accepted Answer

a) determines

Question 30

Granularity refers to ______  a) the size of the table  b) the level of detail represented by the values in a table\'s row  c) the number of attributes represented in a table  d) the number of rows in a table

Accepted Answer

b) the level of detail

Question 31

Data redundancy produces data anomalies  True/False

Accepted Answer

True

Question 32

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  a. Boyce-Codd normal forms  b. Redundancies  c. Time-variances  d. Partial dependencies

Accepted Answer

Partial dependencies

Question 33

A good relational DBMS excels at managing denormalized relations  True/False

Accepted Answer

False

Question 34

Atomic attributes are attributes that can be further subdivided  True/False

Accepted Answer

False

7132 Module 06 Chapter 6 Practice Quiz – Flashcards

Unlock all answers in this set

Haven't found what you were looking for?

Search for samples, answers to your questions and flashcards