Answers to Chapter 15
Reviewing It |
1: | What is the difference between a range partition and a list partition? |
A1: | Range works with numeric values and divides across partitions based on a range of values. List works with literals and simply puts the rows in the proper partitions based on a literal value |
2: | Briefly explain the difference between a hash partition and a composite partition. |
A2: | Composite partitioning is a combination of range and hash partitioning |
3: | What is the difference between a local-partitioned index and a global-partitioned index? |
A3: | Local-partitioned indexes have the same partitioning key values, number of tablespaces, and partitioning ... |
Get Oracle9i™ Development by Example now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.