Whether your question is closed by a diamond moderator, or by the community, it can be re-opened with five community votes (or another moderator stepping in an re-opening it, which happens).
If your question is deleted by the community, it can be undeleted by the community. The only time a question cannot be undeleted by the community is when it's deleted by a moderator.
There's a difference between moderators, and community moderation. I see people using the word 'moderator' when they mean that five members of the community closed their question, and this isn't really correct (it makes it seem like a band of 12 people runs Stack Overflow, which is the furthest thing from the truth).
In your particular case, if you improve your question to address why it was closed, it will automatically be placed into the review queue to be re-opened. If five members of the community agree, it will be re-opened. If it still doesn't get re-opened, you can always open a meta question about it ( http://meta.stackoverflow.com ).
I wanted to address this because it's incorrect to say, "When a moderator closes a topic, it stays closed." That's just not the case.
If you link me to the question, I'll be happy to take a look at it and re-open it if it should be re-opened.