1. The relational data model portrays data as being stored in __________.
a. hierarchies
b. tables
c. objects
d. files
2. How a user conceptually organizes and understands data is referred to as the __________.
a. physical view
b. logical view
c. data model view
d. data organization view
3. What is each row in a relational database table called?
a. relation
b. attribute
c. anomaly
d. tuple
4. Which of the following is an individual user’s view of the database?
a. conceptual-level schema
b. external-level schema
c. internal-level schema
d. logical-level schema
5. Which of the following would managers most likely use to retrieve information about
sales during the month of October?
a. DML
b. DSL
c. DDL
d. DQL
6. Which of the following attributes would most likely be a primary key?
a. supplier name
b. supplier number
c. supplier Zip code
d. supplier account balance
7. Which of the following is a software program that runs a database system?
a. DQL
b. DBMS
c. DML
d. DDL
8. The constraint that all primary keys must have nonnull data values is referred to as which
of the following?
a. referential integrity rule
b. entity integrity rule
c. normalization rule
d. relational data model rule
