1. Which of the following is not a valid characteristic of a relational table?
A) All values in a column may have different data formats.
2. Which of the following statements best describes a functional dependency?
A) The value of one or more attributes determines the value of one or more other attributes.
3. Which of the following is not a legitimate DB key in a relational model?
A) Entity key
4. Which of the following statements best defines the purpose of entity integrity?
A) It guarantees each entity has a unique value for the primary key and that there are no null key values.
5. Dr. Codd published a list of 12 relational database rules in 1985; which of the following is not a valid rule?
A) Any database view that is theoretically updatable must be updated outside of the database structure.
6. Which of the following best describes an index?
A) An index is an orderly arrangement used to logically access rows in a table.
7. A composite entity is also referred to as a _____ entity.
A) bridge
8. The proper use of foreign keys _____ data redundancies and the chances that destructive data anomalies will develop.
A) minimizes
9. Which of the following statements best defines a data dictionary?
A) The data dictionary provides a detailed description of all tables in the database created by the user and designer.
10. Which of the following is not a valid relational set operator?
A) ADD operator