C192 / Data Storage

Question 1 of 11

1

The hierarchical database model is based on a ____.

Select one of the following:

tree structure
lack of a parent segment
lack of a child segment
matrix

Explanation

Question 2 of 11

1

Database models can be grouped into two categories: conceptual models and ____ models.

Select one of the following:

implementation
logical
physical
query

Explanation

Question 3 of 11

1

A(n) ____ model is independent of both hardware and software.

Select one of the following:

conceptual
external
developmental
logical

Explanation

Question 4 of 11

1

Which model represents the end user’s view of the database?

Select one of the following:

Internal
Conceptual
Physical
External

Explanation

Question 5 of 11

1

What type of relationship is expressed with the phrase “Employee manages Store”?

Select one of the following:

1:M
1:1
M:1
M:N

Explanation

Question 6 of 11

1

The key's role is based on a concept known as ____.

Select one of the following:

consistency
availability
determination
uniqueness

Explanation

Question 7 of 11

1

The ERD is used to graphically represent the ____ database model.

Select one of the following:

condensed
physical
logical
conceptual

Explanation

Question 8 of 11

1

A ____ relationship exists when an association is maintained within a single entity.

Select one of the following:

unary
ternary
binary
weak

Explanation

Question 9 of 11

1

A ____ relationship exists when two entities are associated.

Select one of the following:

unary
binary
ternary
weak

Explanation

Question 10 of 11

1

The extended entity relationship model (EERM) is sometimes referred to as the ____.

Select one of the following:

entity relationship model
enhanced entity relationship model
entity clustering relationship model
extended entity relationship diagram

Explanation

Question 11 of 11

1

The property of ____ enables an entity subtype to inherit the attributes and relationships of the supertype.

Select one of the following:

subtype discriminator
inheritance
specialization hierarchy
entity supertype

	Created by Craig Willey over 4 years ago

College C192 Databases Quiz on C192 / Data Storage, created by Craig Willey on 29/06/2020.

C192 / Data Storage

C192 / Data Storage

Question 1 of 11

The hierarchical database model is based on a ____.

Select one of the following:

Explanation

Question 2 of 11

Database models can be grouped into two categories: conceptual models and ____ models.

Select one of the following:

Explanation

Question 3 of 11

A(n) ____ model is independent of both hardware and software.

Select one of the following:

Explanation

Question 4 of 11

Which model represents the end user’s view of the database?

Select one of the following:

Explanation

Question 5 of 11

What type of relationship is expressed with the phrase “Employee manages Store”?

Select one of the following:

Explanation

Question 6 of 11

The key's role is based on a concept known as ____.

Select one of the following:

Explanation

Question 7 of 11

The ERD is used to graphically represent the ____ database model.

Select one of the following:

Explanation

Question 8 of 11

A ____ relationship exists when an association is maintained within a single entity.

Select one of the following:

Explanation

Question 9 of 11

A ____ relationship exists when two entities are associated.

Select one of the following:

Explanation

Question 10 of 11

The extended entity relationship model (EERM) is sometimes referred to as the ____.

Select one of the following:

Explanation

Question 11 of 11

The property of ____ enables an entity subtype to inherit the attributes and relationships of the supertype.

Select one of the following:

Explanation