I use fork in my db-stress program. The purpose is to put a heavy load on a DBMS and this is best done by several processes.

Apart from that I use fork for servers that must be able to accept more than one connection at a time.