Nokia C2-06 - Can I assign different ringing tones for the two SIM cards?

No, it is not supported.