A real symmetric matrix is always diagonalizable by which specific type of matrix?

Orthogonal matrix

This is a core result of the Spectral Theorem, which guarantees that for every symmetric matrix, there exists an orthonormal basis of eigenvectors. Consequently, $A = Q D Q^T$ where $Q$ is orthogonal and $D$ is diagonal.