Which things are compiled in the main exe?
Normally everything is built into the EXE.
If you enable Split Resource Files, then the sprites, rooms and theora videos are compiled into split resource files instead.
Hmm with rooms you mean room script, room background or both?
Both.