Some cars will lock the car in 2nd gear when in D2, but like others said, most will probably just limit you to 2nd.
I don't think it really maters if your tranny doesn't lock into 2nd. Off the line slippage can be somewhat eliminated using soft throttle control.
Going up a hill in 2nd could...