Hi Amith,
Why dont you get a couple of DB9 male and female connectors from the market and solve the doubt yourself.
You can do continuity test using a multimeter to find out which pin of the male connector is in contact with which pin of the female connector when the male pin is plugged into the female pin.