Oracle DBA Assignment 5

Chapter 9

1. An index does not have to be based on a(n) _________________________.

2. An index containing multiple columns is called a(n) ____________________ index.

3. A(n) _________________________ index improves efficiency of Oracle Real Application Clusters.

4. When creating an index, you choose the type of index, the columns to be included in the index, and the ____________________ of the index.

5. One big difference between the _________________________ and the b-tree is that the final values are always found in a leaf node, never in a branch or root node.

6. A(n) ______________________________ takes up a very small amount of storage space compared to a b-tree index.

Chapter 10

7. _________________________ are the statements defined during the design of a database system that inform both the database designer and the application programmer how data is used to support the business.

8. A(n) _________________________ is the name of a relationship between two tables, in which one is the parent and the other is the child.

9. The _________________________ constraint enforces a predefined list of values for a column.

10. A(n) _________________________ that is automatically created enforces the PRIMARY KEY and UNIQUE key constraints.

11. A constraint _________________________ is the attribute that tells Oracle9i how to use the constraint when data is added to the table.

12. A(n) _________________________ is a program that runs when a certain event occurs.