Team Fly 

Page 323

Progress Check Image

1. List at least three DML commands that can be applied to partitions as well as tables.

2. What does partition pruning mean?

3. How many table attributes can be used to define the partition key in list partitioning?

4. Which type of partitioning is most commonly used with a date-based partition key?

5. Which partitioning types cannot be combined together for composite partitioning?

6. How many partition keys can be defined for a partitioned table?

7. Which type of partitioned index has a one-to-one relationship between the data and index partitions?

8. What is meant by a prefixed partitioned index?

CRITICAL SKILL 9.3
Compress Your Data

As you load more and more data into your database, performance and storage maintenance can quickly become concerns. Usually at the start of an implementation of a database, data volumes are estimated and projected a year or two ahead. However, often times these estimates turn out to be on the low side and you find yourself

Progress Check Answers

1. The following DML commands can be applied to partitions as well as tables: delete, insert, select, truncate, and update.

2. Partition pruning is the process of eliminating data not belonging to the subset defined by the criteria of a query.

3. Only one table attribute can be used to define the partition key in list partitioning.

4. Range partitioning is most commonly used with a date-based partition key.

5. List and hash partitioning cannot be combined for composite partitioning.

6. Only one partition key may be defined.

7. Local partitioned indexes have a one-to-one relationship between the data and index partitions.

8. A partitioned index is prefixed when the leftmost column of the index key is the same as the leftmost column of the index partition key.

Team Fly 
0342-CRITICAL SKILL 9.3 Compress Your Data