Torquing the fastener puts a certain amount of "stretch" in the theads which will "usually" be sufficient.
High vibration etc. loads will probably use a lock washer at a minimum or a thread locker of some degree.
For bicycle use, Green or Blue Locktite. Green is "weaker". I always buy Blue. Both times

Red requires EXTREME heat to remove.