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 about 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

Models For Explaining Human Memory
Matthew Li
AQA Biology A2 Unit 4 Respiration
Gemma Lucinda
Edexcel IGCSE Business Studies Key terms Ch 1-9
minsung.kang
An Inspector Calls - Quiz
Emily Morrison
John Montague
David Caprani
Certification Prep_1
Tonya Franklin
physics gcse key terms
lmarine
Compensation and Benefits PHR Study Guide
Cari Hawthorne
Groups that influence public health policy (A4)
Carina Storm
House of Cards
Maryse VINCENT
1. Noțiuni generale.
Snakey Snakey