What happens when I die?

What happens when one of you dies? (the couple)
What happens when the sole survivor dies? (sole survivor or single person)
What about life insurance investments?
Power of Attorney (POA) and Executor?