For the vast majority of insurance providers, sole accounts are closed. However, if you wish to update the primary sole policy, the provider may either be able to transfer or close and open a new policy for the responsible person.
Joint accounts are usually transferred under the name of the living policy holder. However, some providers may close the primary policy and open a new one for the surviving person.