1. The functions of a database administrator are
a. database planning, data input preparation, and database design.
b. data input preparation, database design, and database operation.
c. database design, database operation, and equipment operations.
d. database design, database implementation, and database planning.
e. database operations, database maintenance, and data input preparation.
2. A relational database system contains the following inventory data: part number, description, quantity on hand, and reorder point. These individual items are called
a. attributes.
b. relations.
c. associations.
d. occurrences.
3. Which of the following is a characteristic of a relational database system?
a. All data within the system are shared by all users to facilitate integration.
b. Database processing follows explicit links that are contained within the records.
c. User views limit access to the database.
d. Transaction processing and data warehousing systems share a common database.
4. Partitioned databases are most effective when
a. users in the system need to share common data.
b. primary users of the data are clearly identifiable.
c. read only access is needed at each site.
d. all of the above.
5. Database entities
a. may contain zero or many occurrences.
b. are represented as verbs in an ER diagram.
c. may represent both physical assets and intangible phenomena.
d. are often defined by common attributes that also define other entities.
e. are unique to a specific user view.