It depends entirely on the game cartridge. The DS Lite hardware supports two distinct multiplayer modes:
Most action/racing/RPGs need 2 carts + 2 systems. Only niche titles share one DS.