recovery bring the database online and allows full database activity.

norecovery leaves the database in a restoring state ready for the next backup file to be applied (nobody can connect in this state)

Standy puts the database in a read only state and is normally seen in this state during a log shipping scenario.

Why do you ask? do you have a specific problem or is just a general knowledge question?