Each college will be different with their foreign language requirements for transfer admission and graduation. And it varies by major. Identify a few you are interested in and research their requirements.
My liberal arts major son had to take four semesters of his foreign language to meet the graduation requirements. My engineering daughter does not need any foreign language courses to graduate from her college.
If you are interested in Mandarin, then you can take 101 at community college.
If you will transfer from the community college to an in state public university many of them have credit transfers already built in. Your advisor will be able to help you.