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 over 4 years ago
2
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

Similar

Atoms and Reactions
siobhan.quirk
Developmental Psychology - Freud, Little Hans (1909)
Robyn Chamberlain
Biology AQA 3.1.5 The Biological basis of Heart Disease
evie.daines
Command Words
Mr Mckinlay
Metallic bonding
anna.a.graysmith
Othello content knowledge quiz
rubyduggan
Attachment - Psychology - Flash Cards
Megan Price
Lord of the Flies - CFE Higher English
Daniel Cormack
The Cold War: An Overview
Andrea Leyden
All AS Maths Equations/Calculations and Questions
natashaaaa
8 Motivational Quotes for Students
Andrea Leyden