When a cat's tail is curled like a question mark, it typically indicates that the cat is curious, attentive, or in a playful mood. This tail position is often seen when a cat is investigating something new or interacting with their surroundings in a lively manner.