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

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.190.156.212