What does tiene sueno mean?

As an interrogative, ¿Tiene sueño? means "Are you sleepy/tired?"

As a regular sentenec, Tiene sueño means "(S)he/it is tired/sleepy."