Single-mode or multimode? Your optic decides, not the cable. An LR, ER or BiDi optic belongs on single-mode (OS2), an SR optic on multimode (OM3 or OM4). Mixing them doesn't work, even if the connector fits.
Our OS2 cords are G.657.A, so they cope with a tight bend in a full rack. Besides LC/UPC to LC/UPC there's SC/UPC to LC/UPC, for example for the blue fiber wall socket (FTU) at home; the fiber internet guide tells you which one you need. Not sure about the length? Work it out with the patch cable calculator.