The funds can either be withdrawn as a lump sum, or they can be left invested to provide an income for beneficiaries.
If you do not nominate a beneficiary, the funds are usually paid out to the person deemed to be a financial dependent on you (i.e. your next of kin) in the form of a lump sum only.