Database Types

Question 1

Database that has single table

Answer 1

Flat file

Question 2

Database type used when managing diverse information that won’t fit into a tabular structure

Answer 2

Non-relational

Question 4

The rigid structure used by Microsoft Registry

Answer 4

Hierarchical

Question 5

Multiple connected tables in a database

Answer 5

Relational

Question 6

You can assign properties, relationships, and actions into this database records

Answer 6

Object oriented

Question 7

Example of relation databases

Answer 7

Microsoft Access

Question 8

Relational databases have___, ___ and ___.

Answer 8

Tables, records and fields.

Question 9

The basis of any relational database is its _____.

Answer 9

Tables (aka relations)

Question 10

What is a table in a relation database?

Answer 10

Row and column grid for storing structured data

Question 11

In a table, in a relational database, each row is called a ______.

Answer 11

Record (collection of facts about one instance of whatever you are keeping track of

Question 12

In a table, of relational database, each COLUMN represents a________

Answer 12

Field (names the type of information)

Question 13

What is a query?

Answer 13

A view of data from one or more tables

Question 14

Contains data from 1 or more tables or queries, arranged and formatted in a print friendly way

Answer 14

Report

Question 15

Show information from multiple tables at once

Answer 15

A form