All varieties are over $\mathbb{C}$.
Let $S$ be a reduced algebraic surface in $\mathbb{P}^3$ with a singular point $p$ of multiplicity two. The question is local so we reduce to $S \subset \mathbb{A}^3$ and $p=0$. Then $S$ is given as the zero set of a polynomial $f = f_2 + f_3 \ldots$ where $f_i$ is homogeneous of degree $i$ and $f_2$ is nonzero (Hartshorne, exercise I.5.3).
The question in the title is vague, so let me split it into parts:
If the singularity $p$ is isolated, is it necessarily an ordinary quadratic one? (i.e. is it resolved by a single blowup operation, resulting in a rational -2 curve?) If not, what are examples of other possibilities?
Is it true that $p$ is isolated if and only if its two tangent directions (the linear factors of $f_2$, see again Hartshorne exercise I.5.3) are different?
These two questions are based on intuition and not much more, so i hope they are not totally ridiculous. When answering, any elaboration on the concept of multiplicity and tangent directions is highly appreciated! Thanks!
Edit: After learning about Du Val singularities, i realize the first question is pretty stupid.. But then again, the question could be replaced by "Are the Du Val singularities the only surface singularities of multiplicity two?"