No, Spybot does not automatically disable the DNS client. Personally, I have never experienced any problems using Spybot's HOSTS file on a Windows XP Home that would indicate that I should even consider disabling the DNS Client.
When the Spybot Hosts file is used, does Spybot automatically disable the DNS client, or is it necessary to disable it manually?