In my experience ... and I will gladly be corrected.
Databases and files located in com.example.youapp are deleted. Regarding the SD card, I doubt that they will be deleted. What if your application created snapshots, then all their snapshots will be deleted when the user is deleted.
Regarding deleting this file when deleting ... this is a good question. There may be some kind of handler that you can call when your application is uninstalled to help do some extra things. Somewhere in the manifesto it sounds like it could be a candidate.
source share