A vibration in a string is a wave. A vibrating string mostly produces a sound with constant frequency. As frequency characterizes the pitch, the sound produced is a constant note.
Vibrating strings are the basis of any string instrument like guitar, cello, or piano.