Adults do not have to drink a lot for children to notice changes in their behaviour, a study says.