Feeling scared after waking from a frightening dream or aroused after an erotic dream is extremely common among healthy young adults, according to a new study.