Partitions, Keys, and Ordering

What common mistakes do candidates make around Partitions, Keys, and Ordering, and how do you avoid them?

Answers use simple, clear English.