Frag grenades are on a timer, and explode after several seconds, regardless of the surfaces they contact or where they roll. The advantage of the frag is that you can bounce it off of surfaces, and therefore you can do indirect damage to enemies that are around a corner. You can also get a bit more distance between you and a target, as they will bounce and roll on flat terrain.
Plasma grenades stick to surfaces, and then detonate shortly afterwards. This can make them good against enemies that tend to dodge when grenades are thrown at them. If you connect with the throw, it's a guaranteed hit, and in most cases a guaranteed kill. However, without the ability to bounce, they're a bit shorter range and can't be used as effectively for indirect fire.
Pulse grenades are the new Promethean grenade type. When thrown, they detonate when the hit a surface. However, they will spend several seconds creating a shield- and health- draining sphere with a fairly limited radius. It's about as tall as a Spartan, Elite, or Knight. After a couple of seconds, they explode, doing significant damage. Since they're a bit more area-of-effect and damage-over-time, they're good for when you know you have an enemy pinned or stunned. The sphere's area of effect also slows vehicles caught within it.
Based on my own service record and what I remember of the few times that I played Flood, the "Other" weapon is the map itself. So falling to your death without getting shot, and I'm not sure what else would.
Best Answer
Halopedia says,
I am yet to unlock any speciazation to get access to this ability to test it out but if the quote above it to be believe then yes, it does affect stationary guns (MG Turret, Shade).