2. |
Which of the following answers describes why you might want to allow row movement in a partitioned table?
Please select all the correct answers.
|
|
A.
|
Your partition key is an updateable field and you wish to avoid errors when updating the value.
|
|
B.
|
Two of your partitions contain few rows, so you wish to combine all the rows in the two partitions.
|
|
C.
|
You have run out of space in the one of your partitions and wish to move some of the rows to a different partition.
|
|
D.
|
You wish to move rows that contain data in their LOB column to a different partition.
|