Well that makes no sense. When the FULLSCREEN flag in SDL is not set it simply creates a Window and doesn't touch the physical video mode of your system.

But to asnswer your question; No, it just creates a normal window with a video overlay inside it as per normal SDL.