Database Test 1 - Chapters 1, 2, 3

Question 1

A document for gathering data input

Answer 1

Form

Question 2

This key is the primary key repeated in another table to create a link between the tables.

Answer 2

Foreign Key

Question 3

A document including the scope, objectives, and timeline for a given project.

Answer 3

Statement of Work

Question 4

A key based on one or more “natural” attributes of an entity

Answer 4

Natural key

Question 5

This key uniquely identifies each row in the table.

Answer 5

Primary Key

Question 6

The official steps and rules for completing some process

Answer 6

Procedure

Question 7

Refers to the accuracy and the correctness of the data in the database.

Answer 7

Data Integrity

Question 8

Refers to storing the same data in more than one place in the database.

Answer 8

Redundancy

Question 9

These files have some sort of character separating columns of data

Answer 9

Delimited Files

Question 10

A type of database that uses “relations,” tables, to store and relate tables.

Answer 10

Relational Database

Question 11

Something that the database is concerned with, about which data can be stored.

Answer 11

Entity

Question 12

The process of organizing data into tables or entities and then determining the relations
among them.

Answer 12

Relational Design

Question 13

The process of organizing data into tables or entities and then determining the relations
among them.

Answer 13

SQL

Question 14

Limits on what the database will do.

Answer 14

Constraints

Question 15

Files where the length in characters of each column is the same.

Answer 15

Fixed Width Files

Question 16

A short statement of one or more paragraphs that says in clear, but general, terms what the project will do.

Answer 16

Statement of Scope

Question 17

A multiple-choice question

Answer 17

Closed-ended question

Question 18

The purpose or subject of a database

Answer 18

Domain

Question 19

A set of tools for analyzing business trends

Answer 19

Business intelligence

Question 20

Things that define aspects of entities.

Answer 20

Attribute

Question 21

A database optimized for storing and processing real-time transactions

Answer 21

Transaction Database

Question 22

A question that has no set answer

Answer 22

Open-ended question

Question 23

Combining data in a variety of formats for trends and patterns

Answer 23

Data mining

Question 24

A document for displaying summarized data

Answer 24

Report

Question 25

An alternate way of doing a process

Answer 25

Exception

Question 26

Marked up Unicode text that follows a set of a few strict rules

Answer 26

XML

Question 27

A database optimized for queries that summarize transaction data

Answer 27

Management information system

Question 28

Something the database needs to do to be successful

Answer 28

Requirement

Question 29

A collection of all the various types of business information including databases and documents

Answer 29

Data Warehouse

Question 30

Anyone who has a stake in the process

Answer 30

Stakeholder

Question 31

Observing workers handling data on the job

Answer 31

Work shadowing

Question 32

The permissions a user has to use or view database objects and data

Answer 32

User access

Question 33

A program that offers a service to requesting programs

Answer 33

Server

Question 34

An artificial key, often just an incremented number

Answer 34

Surrogate key

Question 35

A person or program that makes some use of the database

Answer 35

Actor

Question 36

A program that requests a service

Answer 36

Client

Question 37

A program in SQL that is triggered by a database event

Answer 37

Trigger

Question 38

A key that consists of more than one attribute

Answer 38

Composite key

Question 39

A rule about how data are acquired, stored, or processed

Answer 39

Business rule

Question 40

The general problem area with which a database is concerned

Answer 40

Problem domain

Question 41

Something a database must do to meet a business need

Answer 41

Requirement