The Confidence Paradox: Can LLM Know When It's Wrong