Let $x,y$ be two variables that are functionally related, so that $x$ determines $y$:
$$y = f(x)$$
for some function $f$. We consider a probability distribution on $x$, $p(x)$. The question is:
Is it possible, for some probability distribution $p(x)$, that the correlation between $x$ and $y$ vanishes? That is,
$$\mathrm{cov}(x,f(x)) = \langle x f(x) \rangle - \langle x\rangle \langle f(x) \rangle = \sum_x xf(x)p(x) - \left(\sum_x xp(x)\right) \left(\sum_x f(x)p(x)\right) = 0$$
In other words, given a function $f$, is it possible to select a probability distribution $p$, such that $\mathrm{cov}(x,f(x)) = 0$?
The answer is yes in at least one trivial case, when $f(x) = c$ is a constant number. This case is trivial in the sense that any $p$ will do. Are there more interesting examples? Or general theorems available?