Unit 2, 3.5 Data analysis tools

Which of the following is a common database program?

• Access

• Excel

• SQL

• Publisher

What causes most errors in a database?

• SQL

• Humans

• Servers

• Internet access

Which is the best example of a primary key?

• Driving License Number

• Home Runs Hit

• Price

• First and Last Name

A column name in a database is known as a ______ .

• Field

• Table

• Row

• Record

Data _____ helps ensure that incorrect data is not entered.

• Integrity

• Checks

• Accuracy

• Validation

A quick way to find data in a database is to use _____.

• Questions

• Quandries

• Queries

• File folders

What must be common between two tables to create a relationship?

• Names

• Characters

• Files

• Fields

The front-end of a database is known as a _____.

• Report

• Query

• Form

• Website

SQL stands for _____.

• Sustainable Query Language

• Structured Query Language

• Structured Question Language

• Sustainable Question Language

A spreadsheet program is used to store data in:

• A database

• A text document

• Rows and columns

• Letters and numbers