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

AS English Language
Becky Holland
States of Matter
lauren_nutty
English Techniques
shenaii matlock
CPA Exam Topics and breakdown
joemontin
Villainy In Macbeth
Isaac Evans
Master French
jedimaster3721
physics gcse key terms
lmarine
Mind Maps with GoConqr
croconnor
Fossils and evolution (edexcel)
10ia3416
Část 2.
Gábi Krsková
Métodos y reglas de interpretación jurídica Constitucional y Ordinaria
jose calle