SMP - Symmetric Multiple Processors
MPP - Massive Parallel Processors.

In SMP, a machine has multiple processors, and allocation of CPU is determined based on the load at that time. This is suitable for Parallel Query Option.

In MPP, there are many machines clustered, and each one will do certain job (task). This is an example for Parallel Server option.