What traits make a narrator unreliable?

How would you describe an unreliable narrator, given your experience reading these stories? What traits make a narrator unreliable? How does an unreliable narrator shift the plot and themes? Why are unreliable narrators important in literature and what do they represent? Can you think of an unreliable narrator in TV/Movies/Video Games, or other literature?