. .
Quiz by , created more than 1 year ago

asdf Quiz on Chapter 6 (Multiple Choice CIS 3365), created by . . on 22/09/2016.

1236
3
0
. .
Created by . . about 8 years ago
Close

Chapter 6 (Multiple Choice CIS 3365)

Chapter 6 (Multiple Choice CIS 3365)

Question 1 of 42

1

1. Normalization works through a series of stages called normal forms. Typically ____ stages are processed.

Select one of the following:

  • A) two

  • B) three

  • C) four

  • D) five

Explanation

Question 2 of 42

1

2. 1NF, 2NF, and 3NF are ____.

Select one of the following:

  • A) normalization stages

  • B) anomalies

  • C) repeating groups

  • D) atomic attributes

Explanation

Question 3 of 42

1

3. From a structural point of view, 2NF is better than ____.

Select one of the following:

  • A) 1NF

  • B) 3NF

  • C) 4NF

  • D) BCNF

Explanation

Question 4 of 42

1

4.____ yields better performance.

Select one of the following:

  • A) Denormalization

  • B) Normalization

  • C) Atomization

  • D) Compression

Explanation

Question 5 of 42

1

5. A table that displays data redundancies yields ____.

Select one of the following:

  • A) consistencies

  • B) anomalies

  • C) fewer attributes

  • D) more entities

Explanation

Question 6 of 42

1

6. Data redundancy produces ____.

Select one of the following:

  • A) slower lookups

  • B) robust design

  • C) efficient storage use

  • D) data integrity problems

Explanation

Question 7 of 42

1

7. Converting a ____ is not an example of denormalization.

Select one of the following:

  • A) 3NF to 2NF

  • B) 2NF to 1NF

  • C) 3NF to 1NF

  • D) 3NF to BCNF

Explanation

Question 8 of 42

1

8. Some very specialized applications may require normalization beyond the ____.

Select one of the following:

  • A) 1NF

  • B) 2NF

  • C) 3NF

  • D) 4NF

Explanation

Question 9 of 42

1

9. Of the following normal forms,____, is mostly of theoretical interest.

Select one of the following:

  • A) 3NF

  • B) 1NF

  • C) BCNF

  • D) DKNF

Explanation

Question 10 of 42

1

10.____ is not a valid normal form.

Select one of the following:

  • A) 1NF

  • B) BCNF

  • C) 3NF

  • D) MVNF

Explanation

Question 11 of 42

1

11. A relation is not in 1NF if ____.

Select one of the following:

  • 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

Explanation

Question 12 of 42

1

12. A(n) ____ should not be placed in a relational table.

Select one of the following:

  • A) entity

  • B) attribute

  • C) relationship

  • D) repeating grouop

Explanation

Question 13 of 42

1

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.

Select one of the following:

  • A) determines

  • B) derives from

  • C) controls

  • D) owns

Explanation

Question 14 of 42

1

14. Dependencies based on only a part of a composite primary key are called ____ dependencies.

Select one of the following:

  • A) primary

  • B) partial

  • C) imcomplete

  • D) composite

Explanation

Question 15 of 42

1

15. An attribute that is part of a key is known as a(n) ____ attribute.

Select one of the following:

  • A) important

  • B) nonprime

  • C) prime

  • D) entity

Explanation

Question 16 of 42

1

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.

Select one of the following:

  • A) PROJ_NUM --> PROJ_NAME

  • B) JOB_CLASS --> CHG_HOUR

  • C) PROJ_NUM, EMP_NUM --> HOURS

  • D) PROJ_NUM, EMP_NUM --> CHG_HOURS

Explanation

Question 17 of 42

1

17. In a(n) ____ diagram, the arrows above the attributes indicate all desirable dependencies

Select one of the following:

  • A) Chen

  • B) dependency

  • C) functionality

  • D) ER

Explanation

Question 18 of 42

1

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 ____.

Select one of the following:

  • A) 1NF

  • B) 2NF

  • C) 3NF

  • D) 4NF

Explanation

Question 19 of 42

1

17. A table that is in 1NF and includes no partial dependencies is said to be in ____.

Select one of the following:

  • A) BCNF

  • B) 2NF

  • C) 3NF

  • D) 4NF

Explanation

Question 20 of 42

1

18. If you have three different transitive dependencies, ____ different determinant(s) exist.

Select one of the following:

  • A) one

  • B) two

  • C) three

  • D) four

Explanation

Question 21 of 42

1

19. Before converting a table into 3NF, it is imperative the table already be in ____.

Select one of the following:

  • A) 1NF

  • B) 2NF

  • C) 4NF

  • D) BCNF

Explanation

Question 22 of 42

1

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.

Select one of the following:

  • A) Boyce-Codd Normal Form

  • B) redundancy

  • C) time-variance

  • D) partial dependencies

Explanation

Question 23 of 42

1

21. A table that is in 2NF and contains no transitive dependencies is said to be in ____.

Select one of the following:

  • A) 1NF

  • B) 2NF

  • C) 3NF

  • D) 4NF

Explanation

Question 24 of 42

1

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.

Select one of the following:

  • a. JOB_CHG_HOUR

  • b. CHARGES_PER_HOUR_FOR_JOB

  • c. CHARGES_PER_HOUR

  • d. CHG_HR

Explanation

Question 25 of 42

1

23. Improving ____ leads to more flexible queries.

Select one of the following:

  • A) atomicity

  • B) normalization

  • C) denormalization

  • D) derived

Explanation

Question 26 of 42

1

24. An atomic attribute ____.

Select one of the following:

  • A) cannot exist in a relational table

  • B) cannot be further subdivided

  • C) displays multiplicity

  • D) is always chosen to be a foreign key

Explanation

Question 27 of 42

1

25. The most likely data type for a surrogate key is ____

Select one of the following:

  • A) Character

  • B) Date

  • C) Logical

  • D) Numeric

Explanation

Question 28 of 42

1

26. Granularity refers to ____.

Select one of the following:

  • 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

Explanation

Question 29 of 42

1

27. From a strictly database point of view, ____ attribute values can be calculated when they are needed to write reports or invoices.

Select one of the following:

  • A) derived

  • B) atomic

  • C) granular

  • D) historical

Explanation

Question 30 of 42

1

28. In a real-world environment, we must strike a balance between design integrity and ____.

Select one of the following:

  • A) robustness

  • B) flexibility

  • C) uniqueness

  • D) ease of use

Explanation

Question 31 of 42

1

29. For most business transactional databases, we should normalize relations into ____.

Select one of the following:

  • A) 1NF

  • B) 2NF

  • C) 3NF

  • D) 6NF

Explanation

Question 32 of 42

1

30. To generate a surrogate key, Microsoft Access uses a(n) ____ data type.

Select one of the following:

  • A) surrogate

  • B) sequence

  • C) Autonumber

  • D) identity

Explanation

Question 33 of 42

1

31. A table where every determinant is a candidate key is said to be in ____.

Select one of the following:

  • A) BCNF

  • B) 2NF

  • C) 3NF

  • D) 4NF

Explanation

Question 34 of 42

1

32. BCNF can be violated only if the table contains more than one ____ key.

Select one of the following:

  • A) primary

  • B) candidate

  • C) foreign

  • D) secondary

Explanation

Question 35 of 42

1

33. Most designers consider the BCNF as a special case of the ____

Select one of the following:

  • A) 1NF

  • B) 2NF

  • C) 3NF

  • D) 4NF

Explanation

Question 36 of 42

1

34. A table is in 4NF if ____.

Select one of the following:

  • 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

Explanation

Question 37 of 42

1

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 ____.

Select one of the following:

  • A) 1NF

  • B) 2NF

  • C) 3NF

  • D) 4NF

Explanation

Question 38 of 42

1

36. When designing a database, you should ____.

Select one of the following:

  • 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

Explanation

Question 39 of 42

1

37. Normalization represents a micro view of the ____ within the ERD.

Select one of the following:

  • A) entities

  • B) attributes

  • C) relationships

  • D) forms

Explanation

Question 40 of 42

1

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.

Select one of the following:

  • A) transitive

  • B) 3NF

  • C) component

  • D) temporary

Explanation

Question 41 of 42

1

39. The conflicts between design efficiency, information requirements, and processing speed are often resolved through ____.

Select one of the following:

  • A) conversion from 1NF to 2NF

  • B) conversion from 2NF to 3NF

  • C) compromises that include denormalization

  • D) conversion from 3NF to 4NF

Explanation

Question 42 of 42

1

40.____ databases reflect the ever-growing demand for greater scope and depth in the data on which decision support systems increasingly rely.

Select one of the following:

  • A) Noramlized

  • B) Data warehouse

  • C) Temporary

  • D) Report

Explanation

Previous
Check answer
Next