PRELIM Q1

Question 1

is a tool used to organize, store,
retrieve, and communicate (report on) group of
related information.

Answer 1

database

Question 2

4 main Objects

Answer 2

1. Tables – store data in rows and columns
2. Queries – retrieve and process data
3. Forms – control data entry and data views.
   a Form is a customized manner of inputting data into a
   database or representing data on a screen.
4. Reports – summarize and print data.

Question 3

Database software, often called a

Answer 3

database
management system (DBMS)

Question 4

identifies the quality of the data

Answer 4

Data integrity

Question 5

GIGO

Answer 5

Garbage in, garbage out

Question 6

points out the
accuracy of a computer’s output depends on the
accuracy of the input

Answer 6

(GIGO)

Question 7

Valuable information should have the following
characteristics

Answer 7

Accurate
Verifiable
Timely
Organized
Accessible
Useful
Costeffective

Question 8

is one byte
– Numbers, letters, space,
punctuation marks, or
other symbols

Answer 8

A character

Question 9

is a combination
of one or more related
characters
– Field name
– Field size
– Data type

Answer 9

A field

Question 10

is a group of related fields

Answer 10

record

Question 11

uniquely identifies each record

Answer 11

primary key

Question 12

is a collection of related records

Answer 12

data file

Question 13

refers to the procedures that
keep data current

Answer 13

File maintenance

Question 14

compares data with a set of rules or
values to find out if the data is correct

Answer 14

Validation

Question 14

Database approach
* Programs and users share
data
* Reduce data redundancy
* Improve data integrity
* Share data
* Allows easier access
* Reduces development time
* Can be more vulnerable

Question 15

File processing system
* Each department has its
own set of files
* Used for many years
* Have data redundancy
* Isolate data

Question 16

contains data about each file in
the database and each field in those files

Answer 16

A data dictionary

Question 17

provides several tools that allow users
and programs to retrieve and maintain data in the
database

Answer 17

DBMS

Question 18

consists of simple, English-like
statements that allow users to specify the data to
display, print, or store

Answer 18

query language

Question 19

provides a GUI to assist
users with retrieving data

Answer 19

Query by example (QBE

Question 20

is a window on the screen that provides
areas for entering or modifying data in a database

Answer 20

form

Question 21

allows users to design a report
on the screen, retrieve data into the report
design, and then display or print the report

Answer 21

A report generator

Question 22

A DBMS provides means to
ensure that only authorized users
access data at permitted times

Answer 22

Access privileges
Principle of least privilege

Question 23

consists of rules and standards that
define how the database organizes data

Answer 23

data model

Question 24

stores data in tables that consist of rows and columns

Answer 24

relational database

Question 25

is a link within the data

Answer 25

relationship

Question 26

is a query language that allows users to manage, update, and retrieve data

Answer 26

Structured Query Language (SQL)

Question 27

stores data in objects

Answer 27

An object-oriented database (OODB

Question 28

can store data in more than two dimensions of data – Sometimes known as a hypercube – Can consolidate data much faster than a relational database

Answer 28

A multidimensional database

Question 29

is a huge database that stores and manages the data required to analyze historical and current transactions

Answer 29

data warehouse

Question 30

is the process of sorting through large data sets to identify patterns and relationships that can help solve business problems through data analysis

Answer 30

Datamining