Introduction

Question 1

A database is a _____ of data items which is ________ and _________ so as to be more easily accessed, managed, and updated

Answer 1

collection, structured, organized

Question 2

What does DBMS stand for?

Answer 2

Database Management System

Question 3

A DBMS ______ and manages databases

Answer 3

creates

Question 4

A DBMS mediates _______ between end-users and the database

Answer 4

interaction

Question 5

A DBMS ensures that ____ is consistently organized

Answer 5

data

Question 6

How is data stored in a Relational Database?

Answer 6

Data is organized in tables (relations) with typed attributes

Question 7

How is data stored in Document Stores like XML

Answer 7

Data is organized in text documents structured using tags (or other markers)

Question 8

How is data stored in Graph Databases?

Answer 8

Data is organized in graph structures with nodes and edges

Question 9

How is data stored in a Key-value store?

Answer 9

Data is organized in associative arrays (a.k.a. dictionaries or maps)

Question 10

A _____ _________ is used to ask questions to a database

Answer 10

query language

Question 11

A query language is _______ because it specifies a sequence of steps to obtain a result

Answer 11

procedural

Question 12

A query language is ______ because it specifies what is wanted and not how to get it

Answer 12

declarative