1. Which of the following are advantages of declaring primary indexes (indexes on PKs and FKs):

1. Uniqueness of PKs is enforced by the database
2. Referential integrity of FKs is enforced by the database
3. Joins will likely run faster because of the indexes
4. All of the above

2. Which of the following are disadvantages of declaring secondary indexes:

1. Selects with where clauses will run faster because they can use the indexes
2. Updates may be slower because the indexes need to be updated
3. Selects will be forced to use full table scans
4. None of the above

3. True or False: Indexes can be created once when the table is created and can be ignored from then on.
4. Match the following terms with their definitions:

Term	Matching Definition	Definitions
MPP Partitioning		A type of partitioning where a multiprocessor computer has the data partitioned over a number of disks
SMP Partitioning		A type of partitioning where the data is partitioned over a number of computers, each with their own disk An index created on a primary key attribute

5. True or False: A primary goal of partitioning is to bunch the processing as much as possible to a single partition so that most partitions are idle most of the time.

Data Warehouse:

6. True or False: One of the advantages of a data warehouse is that it keeps large analytical queries from interfering with high-speed transaction activity.
7. Which of the following best describes Inmons corporate information factory architecture:

1. Key elements of the architecture are a 3NF core data warehouse with denormalized data marts
2. Key elements of the architecture include a staging area where conformed dimensions are created and data marts that are implemented in some form of star schema.
3. Key elements of the architecture are a 3NF core data warehouse with star schema data marts
4. Key elements of the architecture are data stores that are hypernormalized (sometimes called 6NF).