The Confidence-Competence Gap in Large Language Models: A Cognitive Study