The camera dictates what type of memory card you can use since all cameras come pre-configured with dedicated memory card slots. Higher-featured cameras may have two card slots; sometimes with both accepting the same type of card but at other times one slot is designed for a different type of card.
The market has changed in the past 10-12 years. CompactFlash (CF) cards predominated in the late 1990s and early 2000s but, since the technical specifications were last updated in November 2010, they’ve fallen out of favour. Fortunately for owners of older cameras, they’re still being sold,