Question: Is this the only Bond film where the title song is being sung by a character during the film?
Answer: As far as I can tell, yes. Unless you count "Die Another Day," where the singer of the title song (Madonna) appears in a scene, as well as the song being remixed for the party scene in the ice castle.
Question: Who sent Bond the upside-down Queen of Cups?
Chosen answer: Bond just stored the bullet in his own mouth to hide it. As he puts it in Kananga's mouth he presumably pulls a pin, or forces Kananga to bite it.
Soylent Purple