Terribly phrased options to choose.
A clustered index physically rearanges data on disk.
I think this option should look like this: "When created or rebuilded
, a clustered index physically rearranges data on disk".
A quote from the explanation (and from the Delaney's book):
Once created, a clustered index is maintained logically rather than physically.
After that (after creation), maintaining the clustered index is a logical operation.
Another option from the question:
Dropping a rebuilding a clustered index on a partition scheme will move disk to other drives.
Maybe, "Dropping and
"Move disk to other drives" – what is the meaning of this? Sounds like abracadabra for me :-)
Maybe, it means "moving logical disks C:, D:, E: to other hard disk drives"?