Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

ITC114 MCQ > Topic 5 > Flashcards

Topic 5 Flashcards

1
Q

From a structural point of view, 3NF is better than _____

a. 2NF
b. 3NF
c. 5NF
d. 6NF

A

2NF

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

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 process

a. two
b. three
c. four
d. five

A

three

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

From a structural point of view, 2NF is better than _____

a. 1NF
b. 3NF
c. 4NF
d. BCNF

A

1NF

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

An attribute that is part of a key is known as a (n) _____ attribute

a. important
b. nonprime
c. prime
d. entity

A

prime

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

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

A

determines

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Some very specialized applications may require normalization beyond the _____

a. 1NF
b. 2NF
c. 3NF
d. 4NF

A

4NF

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Of the following normal forms, _____ is mostly of theoretical interest

a. 1NF
b. 3NF
c. BCNF
d. DKNF

A

DKNF

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

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 _____

a. 1NF
b. 2NF
c. 3NF
d. 4NF

A

1NF

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

A (n) _____ exists when there are functional dependencies such that Y is functionally dependent on X, Z is functionally dependent on Y, and X is the primary key

a. partial dependency
b. repeating group
c. atomic attribute
d. transitive dependency

A

transitive dependency

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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

A

repeating group

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

A relational table must not contain a (n) _____

a. entity
b. attribute
c. relationship
d. repeating group

A

repeating group

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

In a (n) _____ diagram, the arrows above the attributes indicate all desirable dependencies

a. Chen
b. dependency
c. functionality
d. ER

A

dependency

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Dependencies based on only a part of a composite primary key are known as _____ dependencies

a. primary
b. partial
c. incomplete
d. composite

A

partial

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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

A

partial dependencies

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

A table that is in 2NF and contains no transitive dependencies is said to be in _____

a. 1NF
b. 2NF
c. 3NF
d. 4NF

A

3NF

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Improving _____ leads to more flexible queries

a. atomicity
b. normalization
c. denormalization
d. derived attribute

A

atomicity

17
Q

An atomic attribute _____

a. cannot exist in a relational table
b. cannot be further subdivided
c. displays multiplicity
d. is always chosen to be a foreign key

A

cannot be further subdivided

18
Q

The most likely data type for a surrogate key is _____

a. character
b. date
c. logical
d. numeric

A

numeric

19
Q

Granularity refers to _____

a. the size of a 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

A

the level of detail represented by the values in a table’s row

20
Q

From a system functionality point of view, _____ attribute values can be calculated when they are needed to write reports or invoices

a. derived
b. atomic
c. granular
d. historical

A

derived

21
Q

In a real-world environment, we must strike a balance between design integrity and _____

a. robustness
b. flexibility
c. uniqueness
d. ease of use

A

flexibility

22
Q

To generate a surrogate key, Microsoft Access uses a (n) _____ data type

a. character
b. sequence
c. AutoNumber
d. identity

A

AutoNumber

23
Q

BCNF can be violated only if the table contains more than one _____ key

a. primary
b. candidate
c. foreign
d. secondary

A

candidate

24
Q

When a table contains only one candidate key, _____ are considered to be equivalent

a. the 1NF and the 2NF
b. the 3NF and the BCNF
c. the 4NF and the 3NF
d. the BCNF and the DKNF

A

the 3NF and the BCNF

25
Q

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

a. multivalued dependency
b. transitive dependency
c. partial dependency
d. functional dependency

A

multivalued dependency

26
Q

A table where all attributes are dependent on the primary key but are independent of each other, 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

A

4NF

27
Q

A table is in 4NF if it is in 3NF, and _____

a. all attributes must be dependent on the primary key and must be dependent on each other
b. all attributes are unrelated
c. it has no multivalued dependencies
d. no column contains the same values

A

it has no multivalued dependencies

28
Q

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 are stored in the table as rows.

a. transitive
b. 3NF
c. component
d. temporary

A

temporary

29
Q

Data warehouse routinely uses _____ structures in its complex, multilevel, multisource data environment.

a. 1NF
b. 2NF
c. 3NF
d. 4NF

A

2NF

30
Q

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

a. Normalized
b. Data warehouse
c. Temporary
d. Report

A

Data warehouse

ITC114 MCQ (7 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions