It totally depends on your manager. My first manager encouraged me to do good work and make sure I got customer feedback for it. My new manager starts every one-on-one meeting with phrases like "not everybody gets promoted" or "the reality is that you will be compared to your peers"...
A manager I had at Amazon met his new team/underlings for the first time, and decided that a good way to start things off would be to explain in detail the process by which people are fired. I suppose he was trying to "motivate" them?
This same manager also later became notorious for angrily declaring that "<productName> has no technical debt!" in a meeting, despite the product being unable to meet any reasonable SLA for years (bad architecture, bad code quality, >100% annual turnover). Not sure I'd use him as an example of management there, but pockets like this certainly exist.
You can guess which one I prefer.