Hello- Newbie and got a few questions about loading firmware into uno board

The loaded sketch you wrote and uploaded stays there and it runs when the board is powered up. It is only changed when you overwrite it. It need never see a computer again once you've uploaded it.