Thanks for the great explanation, Malcom.
I was curious because I saw a few threads mentioning "CCD cameras", and I bought a Canon point-and-shoot camera about a month ago which also has a CCD sensor. It is not the latest model though. The latest models seem to use the CMOS sensor you mention.