I mentioned it in another comment, but the most trivial example is:

X ~ Unif(-1,1)

Y = X^2

In this case X and Y have a correlation of 0.