The main different is the physical media you're connecting with. Wired is generally going to be faster since there is no collision of data. Wireless has to avoid collisions with other devices, but newer wireless is designed for better handling of this issue.
You can have both enabled. The connections will automatically be assigned a metric and which ever has the lower metric will be used. Windows determines the metric based on network equipment characteristics.