###Linear independence is not just sufficient but *also* a neccesary condition

*To show that the variance-covariance matrix has eigenvalues equal to zero if and only if the variables are not linearly independent, it only remains to be shown that "if the matrix has eigenvalues equal to zero then the variables are not linearly independent".*

If you have a zero eigenvalue for $C_{ij} = \text{Cov}(X_i,X_j)$ then there is some linear combination (defined by the eigenvector $v$)

$$Y = \sum_{i=1}^n v_i (X_i) $$

such that 

$$\begin{array}{rcl}
\text{Cov}(Y,Y) &=& \sum_{i=1}^n \sum_{j=1}^n v_i v_j \text{Cov}(X_i,X_j) \\ 
&=&\sum_{i=1}^n v_i\sum_{j=1}^n v_j C_{ij}  \\
&= &\sum_{i=1}^n v_i \cdot 0 \\ 
&=& 0 \end{array}$$

which means that $Y$ needs to be a constant and thus the variables $X_i$ *have* to add up to a constant and are either constants themselves (the trivial case) or not linearly independent.

------

###Notes about derivation

 - the first line in the equation with $\text{Cov}(Y,Y)$ is due to the property of covariance $$\scriptsize\text{Cov}(aU+bV,cW+dX) = ac\,\text{Cov}(U,W) + bc\,\text{Cov}(V,W) +ad\, \text{Cov}(U,X) + bd \,\text{Cov}(V,X) $$

 - the step from the second to the third line  is due to the property of a zero eigenvalue $$\scriptsize \sum_{j=1}^nv_jC_{ij} = 0$$


------

### Non-linear constraints

So, since linear constraints are a *necessary* condition (not just sufficient),  non-linear constraints will only be relevant when they indirectly imply a (necessary) linear constraint. 

In fact, there is a direct correspondence between the eigenvectors associated with the zero eigenvalue and the linear constraints. 

$$C \cdot v = 0 \iff Y = \sum_{i=1}^n v_i X_i = \text{const}$$

Thus non-linear constraints leading to a zero eigenvalue must, together combined, generate some linear constraint.

Your example in the comments is an example where the intersections of non-linear constraints become effectively a linear constraint.

With the matrix $$M=\begin{bmatrix} X_1 & X_2 \\ X_3 & X_4\end{bmatrix}$$ the constraint $M \cdot M^T = I$ can be translated to the variables parameterized as: 

$$\begin{array}{rcl} X_1 &=& cos(\alpha) \\
X_2 &=& sin(\alpha) \\
X_3 &=& sin(\alpha +(1+k) \pi) \\
X_4 &=& cos(\alpha +k \pi) \\\end{array}$$

a fourth constraint, like $\det M=1$, this reduces further to:

$$\begin{array}{rcrcr} X_1 &=& cos(\alpha) \\
X_2 &=& sin(\alpha) \\
X_3 &=& -sin(\alpha) &=& -X_2 \\
X_4 &=& cos(\alpha) &=& X_1 \\\end{array}$$