Do Windows/Automatic updates happen when a PC is sleeping/standby?

Solution 1:

Yep, you can configure the "Enabling Windows Update Power Management to automatically wake up the system to install scheduled updates" GPO setting. It requires Vista or higher: GPO setting requires Vista or higher to work

Allowing scheduled wakeup will need to be supported and enabled in your BIOS too.