Question

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 Inmon’s 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.

Answer 1

2. SMP Partitioning - a. A type of partitioning where a multiprocessor computer has the data partitioned over a number of disks

(SMP (symmetric multiprocessing) is the processing of programs by multiple processors that share a common operating system and memory.)

1. MPP Partitioning - b. A type of partitioning where the data is partitioned over a number of computers, each with their own disk

(MPP (massively parallel processing) is the coordinated processing of a program by multiple processor s that work on different parts of the program, with each processor using its own operating system and memory )

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

(The main of goal of partitioning is to aid in maintenance of large tables and to reduce the overall response time to read and load data for particular SQL operations.)

4. Data Warehouse : One of the advantages of a data warehouse is that it keeps large analytical queries from interfering with high-speed transaction activity. => true

5. Inmon’s corporate information factory architecture:
c. Key elements of the architecture are a 3NF core data warehouse with star schema data marts

Data is stored in 3NF with structure that closely resembles source system with addition of timestamp keys that allow capturing of changes over time in Inmon's architecture

6. true

In databases and transaction processing, two-phase locking (2PL) is a concurrency control method that guarantees serializability.

By the 2PL protocol, locks are applied and removed in two phases:

1. Expanding phase: locks are acquired and no locks are released.
2. Shrinking phase: locks are released and no locks are acquired.