Lesson 10: Databases

Question 1

A ____________________ (DBMS) or database program is a software that allows you to create, access, and manage a database

Answer 1

database management system

Question 2

A __________ is a field that uniquely identifies each record in a table, such as Student ID

Answer 2

primary key

Question 3

__________ occurs when you store the same data in more than one place

Answer 3

Data redundancy

Question 4

1. Reduced data redundancy
2. Improved data integrity
3. Shared data
4. Easier access
5. Reduced development time

Answer 4

Advantages of database approach

Question 5

A __________ extracts data from a database based on specified criteria, or conditions, for one or more fields

Answer 5

query

Question 6

1. Fields
2. Records
3. Tables
4. Queries
5. Forms
6. Reports

Answer 6

Elements of a Database

Question 7

1. Text
2. Numbers
3. AutoNumber
4. Currency
5. Date
6. Memo
7. Yes/No
8. Hyperlink
9. Object
10. Attachment

Answer 7

Common Data Types

Question 8

Unique number automatically assigned by the DBMS to each added record, which provides a value that identifies the record (such as student ID)

Answer 8

AutoNumber

Question 9

Also called BLOB (binary large object)

Answer 9

Object

Question 10

A __________, sometimes called a repository, contains data about each table in the database and each field in those tables

Answer 10

data dictionary

Question 11

__________ is the process of comparing data with a set of rules or values to determine if the data meets certain criteria

Answer 11

Validation

Question 12

____________________ (SQL) is a popular query language that allows users to manage, update, and retrieve data

Answer 12

Structured query language

Question 13

A __________ consists of simple, English-like statements that allow users to specify the data they want to display, print, store, update, or delete

Answer 13

query language

Question 14

Most DBMSs include __________, a feature that has a graphical user interface to assist users with retrieving data

Answer 14

query by example (QBE)

Question 15

A __________, also called a report generator, allows users to design a report on the screen, retrieve data into the report design, and then display or print the report.

Answer 15

report writer

Question 16

A listing of activities that modify the contents of the database

Answer 16

Log

Question 17

In a __________, also called forward recovery, the DBMS uses the log to reenter changes made to the database since the last save or backup

Answer 17

rollforward

Question 18

In a __________, also called the backward recovery, the DBMS uses the log to undo any changes made to the database during a certain period

Answer 18

rollback

Question 19

A backup plan in which changes are backed up as they are made

Answer 19

Continuous backup

Question 20

__________ or nonrelational databases resolve many of the weaknesses of relational databases

Answer 20

NoSQL databases

Question 21

__________ (also called key-value stores) create any number of key-value pairs for each record

Answer 21

Key-value databases

Question 22

A __________ consists of two related items: a constant that defines the set (the key) and a variable that belongs to the set (the value)

Answer 22

key-value pair

Question 23

____________________ (RDBMS) is a software program in which data is organized as a collection of tables, and relationships between tables are formed through a common field

Answer 23

Relational database managment system

Question 24

__________ (DBaaS) means the DBMS runs on servers owned by a cloud provider, and users access the database remotely through a browser

Answer 24

Database as a service

Question 25

An __________ is a database object that is created based on a field or combination of fields

Answer 25

index

Question 26

A __________ is a series (or chain) of records stored in encrypted blocks across a network

Answer 26

blockchain