Final Exam A
1. Redundancy refers to what database condition?
a. A primary key is repeated in another table as a foreign key.
b. All data is stored in tables.
c. The same data is recorded in more than one place in the same database.
d. You have more than one database devoted to the same thing.

2. Which statement best describes the function of a primary key?
a. It uniquely identifies each record.
b. It is always a number.
c. It is the first field in a table.
d. It unlocks the data in a table.

3. Which statement best describes the function of a foreign key?
a. A foreign key is a key that doesn't belong in the table.
b. A foreign key is the primary key of one table repeated in another table in order to create a relationship between the tables.
c. A foreign key is redundant data.
d. A foreign key is a field telling what language the data is in.

4. What is SQL?
a. It is the language relational databases use to query the database.
b. It is the language relational databases use to create database objects and to manipulate and retrieve data.
c. It is a language like Java or C# for creating applications.
d. It is the name of Microsoft's relational database manager.
5. A database entity can best be described as _____________.
a. the person responsible for the database
b. the database itself
c. something the database is concerned with about for which data can be stored
d. something that describes a person or process

6. Which of the following best defines the term “database requirement”?
a. Something a manager wants from the database
b. An exception to a rule or practice
c. Something a database must do to fulfill its business function
d. The amount of RAM needed by the database software

7. Which of these best defines “data integrity”?
a) The accuracy and correctness of the data in the database
b) The honesty of the database