Cable operates in RF bands, and frequencies are denoted in MHZ and sometimes GHZ(included in the linked answer)
Fiber operates in optical bands and frequencies are denoted in nanometers(wavelength) -- downstream data, downstream video, and upstream data are all operated on different wavelengths on the same piece of glass, and they are received at both the transmitting end and the receiving end.
They are typically separated and filtered by optical prisms to ensure the correct wavelength hits the correct receiver(most receivers are wide-band and will receive a wide range of optical wavelengths)
The medium is typically shared at a neighborhood level, in that a single optical strand may be split 16 or more times to serve multiple houses. Bandwidth is shared on that strand by the houses served by it, typically via TDM(time division multiplexing)
End users don't typically notice this because the line rates are higher than the maximum bandwidth package sold. IE downstream rate 2.5Gb/s, upstream 1.5Gb/s, max package available is 1Gb/s.
Edit: removed incorrect statement regarding gepon/csma