Is it possible to enable or disable mods while in-game or must the whole sim be shutdown and restarted, please?

You can;t do it while the sim is running. It loads and initializes the contents of your Community folder on initial load of the sim,