For 90-95% of the time basic MM OM2 or OM3 LC-to-LC will do just for all manner of jobs.
You'll want OM3 for anything =>8Gbps but if it's just for 1Gbps links then OM2 is just fine.
Some manufacturers have stuck with SC and ST longer than logic would suggest they should - Cisco can sometimes be one of these - but basically it all comes down to what transceivers you're using.
In the case of the WS-G5484 it is one of that 5-10% that doesn't use LC, in this case it requires SC connectors and OM3, even though it's a 1Gbps link. So in this case to link two of the same GBIC-based switches you've specified you'll need an SC-to-SC OM3 pair.