Multiply Choice

1. 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.

2. 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.

3. A transitive dependency
a. Is a database condition that is resolved through special monitoring software?
b. Is a name given to one of the three anomalies that result from unnormalized database tables?
c. Can exist only in a table with a composite primary key.
d. Cannot exist in tables that are normalized at the2NF level.
e. Is none of the above?

4. A partial dependency
a. Is the result of simultaneous user requests for the same data in a partitioned database environment?
b. Is a name given to one of the three anomalies that result from unnorrnalized database tables?
c. Can exist only in a table with a composite primary key.
d. May exist in tables that are normalized at the 2NF level.
e. Is none of the above?

5. Repeating group data
a. Is a form of data redundancy common to replicated databases in a distributed database environment?
b. Is a name given to one of the three anomalies that result from unnormalized database tables?
c. Can exist only in a table with a composite primary key.
d. Cannot exist in tables that are normalized at the 2NF level.
e. Is none of the above?

6. The database model most likely to be used in the development of a modern (not legacy) system is
a. Hierarchical
b. Structured
c. Relational
d. Network
e. Navigational

7. Typical DBMS features include all of the following EXCEPT
a. Database interface design and development.
b. Backup and recovery.
c. Program development.
d. Database access.
e. All of these are typical DBMS features.

8. Which of the following is least likely to be an attribute of an employee table in a normalized database?
a. Employee name
b. Employee address
c. Employee number
d. Employee supervisor’s name
e. All of these would be attributes of the employee table in a normalized database.

9. The advantages to using a partitioned database approach include all of the following EXCEPT
a. The possibility for the deadlock phenomenon is reduced.
b. User control is increased.
c. Transaction processing time is decreased.
d. The potential for wide-scale disaster is reduced.
e. These are all advantages of partitioned databases.

10. Of the following, select the attribute that would be the best primary key in an inventory table.
a. ITEM NAME
b. ITEM LOCATION
c. ITEM COST
d. ITEM NUMBER
e. ITEM SUPPLIER