C192 / Data Storage

Description

College C192 Databases Quiz on C192 / Data Storage, created by Craig Willey on 29/06/2020.
Craig Willey
Quiz by Craig Willey, updated more than 1 year ago
Craig Willey
Created by Craig Willey almost 5 years ago
4
0
1 2 3 4 5 (0)

Resource summary

Question 1

Question
The hierarchical database model is based on a ____.
Answer
  • tree structure
  • lack of a parent segment
  • lack of a child segment
  • matrix

Question 2

Question
Database models can be grouped into two categories: conceptual models and ____ models.
Answer
  • implementation
  • logical
  • physical
  • query

Question 3

Question
A(n) ____ model is independent of both hardware and software.
Answer
  • conceptual
  • external
  • developmental
  • logical

Question 4

Question
Which model represents the end user’s view of the database?
Answer
  • Internal
  • Conceptual
  • Physical
  • External

Question 5

Question
What type of relationship is expressed with the phrase “Employee manages Store”?
Answer
  • 1:M
  • 1:1
  • M:1
  • M:N

Question 6

Question
The key's role is based on a concept known as ____.
Answer
  • consistency
  • availability
  • determination
  • uniqueness

Question 7

Question
The ERD is used to graphically represent the ____ database model.
Answer
  • condensed
  • physical
  • logical
  • conceptual

Question 8

Question
A ____ relationship exists when an association is maintained within a single entity.
Answer
  • unary
  • ternary
  • binary
  • weak

Question 9

Question
A ____ relationship exists when two entities are associated.
Answer
  • unary
  • binary
  • ternary
  • weak

Question 10

Question
The extended entity relationship model (EERM) is sometimes referred to as the ____.
Answer
  • entity relationship model
  • enhanced entity relationship model
  • entity clustering relationship model
  • extended entity relationship diagram

Question 11

Question
The property of ____ enables an entity subtype to inherit the attributes and relationships of the supertype.
Answer
  • subtype discriminator
  • inheritance
  • specialization hierarchy
  • entity supertype
Show full summary Hide full summary

0 comments

There are no comments, be the first and leave one below:

Similar

Forces and Acceleration
Adam Collinge
An Inspector Calls: Characters
bexjrutherford
Chemistry C1
Chloe Winn
Checking out me History by John Agard
Eleanor Simmonds
Camera Angles
saradevine97
Pathos in Battle
mouldybiscuit
4 Lesson Planning Tips for Teachers
Micheal Heffernan
CCNA Security 210-260 IINS - Exam 1
Mike M
SFDC App Builder 1 (1-25)
Connie Woolard
Topic
TEL Bath