Craig Willey
Quiz by , created more than 1 year ago

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

2
0
0
Craig Willey
Created by Craig Willey about 4 years ago
Close

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

Explanation