Checking It

1:You can perform a partition split operation on a list partition.

True/False

2:Hash Partitioning

  1. Automatically spreads the rows across partitions

  2. Uses a RANGE clause

  3. Allows for MAXVALUES

  4. All of the above

3:If you have a partitioned index, the table MUST be partitioned as well.

True/False

4:Which of these options is the easiest for the cost-based optimizer?

  1. Local prefixed index

  2. Local nonprefixed index

  3. Global index

5:Which of these options is the easiest for parallel processing?

  1. Local prefixed index

  2. Local nonprefixed index

  3. Global index

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.

Start your free trial