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

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

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

4. 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).

5. True or False: Without the two-phase locking protocol, locks by themselves do not guarantee serializability.