Explanation:Partition function defines the number of partitions that the table will have and how the boundaries of the partitions are defined. 4. Designing an nonaligned partitioned index can be useful in the following case :
A. The base table has not been partitioned.
B. The index key is unique and it does not contain the partitioning column of the table
C. You want the base table to participate in collocated joins with more tables using different join columns
D. All of the mentioned
Answer:A
Explanation:Partition function defines the number of partitions that the table will have and how the boundaries of the partitions are defined. 4. Designing an nonaligned partitioned index can be useful in the following case :
A. The base table has not been partitioned. B. The index key is unique and it does not contain the partitioning column of the table C. You want the base table to participate in collocated joins with more tables using different join columns D. All of the mentioned
Explanation:Nonaligned index is an index partitioned independently from its corresponding table. 5. Point out the wrong statement :