My example is pretty simplified. But yes, in essence, the program has a list of objectionable sites (regularly updated from the Spy bot site online), so your poor computer knows not to go there.
As does Norton. When I scan....I see it looking for certain viruses.