CIS 241 week 1 homework

1. The following are all examples of a personal database system except
MS Access
Foxpro
Lotus Approach
MySQL

2. Another term to refer to a ROW is:
attribute
field
record
table

3. Another term for column is:
field
record
row
pointer

4. To make a table searchable and maintain each record as unique, you must have a:
foreign key
primary key
composite key
concatenate key

5. Instead of having to type out city and state for a record, it is easier to just ask for the Zip code and automatically determine the city and state. What is the name of the table that would store the Zip, city and state that you would reference?
primary table
cross reference table
lookup table
mahogany table

6. Personal DBMSs are aimed toward _________ database applications.
single-user
web-based
multi-user
enterprise based

7. All database changes are recorded on-the-fly in a ________ just in case of failure.
transaction log
secret list stored in a safe
yule log
scroll

8. The person responsible for administering and maintaining the database is the __________.
MBA
CIA
DBA
NSA

9. To put a database to a prior state is called _______.
state checking
rolling back
prior placement
colonization