PC-100 is mainly Pentium II and Pentium III systems with processors clocked at 50 and 100Mhz intervals such as Pentium II 450Mhz which use a 4.5 multiplier and a Pentium III 700Mhz would use a 7x multiplier. As well as AMD's CPU systems with similar clocked processors of the time. The first generation Pentium 4's I had used mostly PC-133 SDRAM such as my Pentium 4 1.7Ghz.
However if you have a Celeron processor you might be limited to a 66Mhz PC-66 RAM stick if an early socket 370 Celeron, however if a later Celeron that supports PC-100 or PC-133 RAM then you can use PC-100 or PC-133 **ONLY IF** the motherboard supports that CPU and RAM. Some low cost Celeron 500Mhz computers had motherboards that only supported PC-66 66Mhz SDRAM.
DDR RAM is the early AMD Athlon XP and Pentium 4 2nd generation forward. The last series of Pentium 4 with HT, some of them supported DDR2-533Mhz RAM in motherboards designed for DDR2 RAM.
486 computers used either SIMM or DIMM Memory the best board being a DIMM with EDO. SIMM RAM sticks for 486's are not very common they are first generation 486's and early boards as well as bargain boards where manufacturers tapped into the lower cost SIMM memory market to sell a 486 with lesser costing but also lesser performing RAM. Some of the aftermarket boards at the time gave choice of SIMM or DIMM RAM installation which gave option for making a low cost budget friendly 486 DX 33Mhz or AMD 486 equivalent CPU build or an extreme gaming rig using the same motherboard for lesser or greater performance with a 486 DX4 100Mhz etc.
Pentium 1 systems used mainly DIMM's and best to have EDO.
One memory type to mention that you dont have listed is the RAMBUS RDRAM memory that some systems used.
https://en.wikipedia.org/wiki/RDRAM