I have no idea what M3 Perfect is using, but NAND memory and NOR memory are two types of flash memories, and thus non-volatile (but very slow to write to). NAND is short for NOT-AND logic gates and NOR is NOT-OR logic gates which they are built by. You can build any logic using only NAND or only NOR gates because the right combination of NAND or NOR can make any type of logic gate (using the same type of gate for the whole circuit can make it cheaper).
RAM is volatile unless you connect a battery to it. But for uploading games you don't need volatile memory unless you need to power cycle (M3 Perfect does not support any kind of direct boot as far as I remember). The M3 Perfect kept the save in battery-backed RAM though, and copied it to SD card the next time you started the OS. My battery ran out and I lost my save. The stock batteries are of poor quality rechargeable type, and I guess the RTC is what kills them.
EPROM is Erasable Programmable Read-Only Memory, game developers used cartridges with EPROMs to test games when developing for older systems. To erase them you need to expose the little window on the chip to UV-light. You cook them in a UV-eraser for several minutes, so each erase and write cycle takes time.
EEPROM is Electrically Erasable Programmable Read-Only Memory, it can be erased by the program in-circuit so the erase and write cycle is much faster. Playstation memory cards, N64 games and GBA games among other things often uses EEPROM for the save and thus don't need a battery.
My friends got M3 Real and I remember I was jealous because Download Play worked fine on it but not on my M3 Perfect. I have no idea if NDS-GBA Linkage means it can link to rom images and save files though. Also the M3 team stopped long before DSTWO stopped so I think compatibility with games may be worse. I think they stopped releasing updates while new DS games was still being released.
The RAM cartridge is needed to play GBA games and for the Opera browser since both use a slot-2 cartridge that needs to be executed from. I don't think that means it necessarily has NOR though. Isn't the EZ daughter card doing the same thing except without GBA support? RAM and rumble are separate cartridges on the M3 Real though.