I've never heard "bimodal" in connection with SQL, although there are naturally some gaps in my knowledge. Could you give us some more detail? In what context was the term used?
I've heard "bimodal" used in statistics. It's a distribution that goes contrary to the normal Gaussian distribution in which observations are clustered in predictable patterns around an average value.
In a bimodal distribution there is no clustering around the mean. Instead there are two independent peaks that are widely separated by a region which has very few observations. An example might be a charismatic dictator like Adolf Hitler. There were millions of Germans who admired him, but millions more who loathed him for the mass murderer he was. There was very little middle ground of people who were neutral.
As far as I know, there is no relevance to SQL in statistical meaning of "bimodal".