The VVDS-VLA deep field. IV. Radio-optical properties.