How do different types of lenses, like prime and zoom lenses, affect creative options in photography, and when might one be preferred over the other?

How do different types of lenses, like prime and zoom lenses, affect creative options in photography, and when might one be preferred over the other?