# Database: Misc

Name __________________________________________
All possible answers are worth one point unless otherwise indicated. Multiple choice questions have only one best answer unless otherwise indicated.

1. What is a trigger? Give an example of where it would be used?
2. What is an index. Give an example of where it would be used?
3. What is PL/SQL?
4. How does a RDBMS usually handle repeating fields associated with the records in a table (called "the original table")?
   1. The field values are attributes of the records in the original table, so additional fields can simply be defined in that table.
   2. One additional table must be created to hold these field values, and a foreign key to this table is added to each record in the original table.
   3. Two additional tables must be created, one to hold the field values, and one to relate the field values to records in the original table.
   4. Three additional tables must be created, a table to hold the field values, a bridge table to hold the relation between the field values and the records in the original table, and an index table that holds the keys to the fields.
5. Indicate which of the following statements are true of normalization. Mark all answers that are correct.
   1. Normalization reduces the number of redundant copies of data.
   2. A normalized database will have fewer tables than an unnormalized database.
   3. The result of a join of normalized tables will also be normalized.
   4. The number of fields of key data (primary and foreign keys) is reduced by normalization.
   5. A risk of unnormalized databases is that update anomalies may be introduced.