Cosmas Zachos's answer is completely correct, but it took me a while to fully understand it, so I'll give a slightly different more basic perspective on the same idea.
In my opinion, it's not particularly useful to frame the question as whether neutrinos "are" Dirac or Majorana fermions: as Srednicki points out, the "old" Standard Model with massless neutrinos can be equivalently formulated with the neutrino physics being expressed in terms of either Dirac or Majorana bispinors, so that's really just a question of semantics. The better way to frame the question is whether neutrinos have Majorana mass terms, Dirac mass terms, both, or neither.
In the "old" Standard Model (considering only a single lepton generation for simplicity), neutrinos are characterized by a single two-spin-component (left-chiral) Weyl field $\nu$. (Before electroweak symmetry breaking, this field is $SU(2)$-symmetric with another left-chiral Weyl field $e$. Electroweak symmetry breaking breaks this symmetry, and $\nu$ describes the massive neutrino while $e$ makes up the left-chiral half of the massive electron bispinor.) If we want to express $\nu$ in terms of a four-spin-component bispinor $\mathcal{N}$, then we have two options: we can either form a Majorana bispinor
$$\mathcal{N} := \left( \begin{array}{c} \nu \\ \nu^\dagger \end{array} \right),$$
or a different bispinor
$$\mathcal{N}_L := \left( \begin{array}{c} \nu \\ 0 \end{array} \right).$$
$\mathcal{N}_L$ (which Cosmas Zachos calls $\psi_L$ in his answer) is kind of like a Dirac field, but it's nonstandard one because it only consists of one independent Weyl field rather than the usual two (and there is no $U(1)$ symmetry). Which scheme you prefer is a matter of personal opinion; the latter is more common because it's more mathematically convenient, but the former is arguably conceptually clearer because it manifestly demonstrates that the field only has two independent spin components, rather than four as for a general Dirac bispinor.
The minimal way to modify the old Standard Model to incorporate neutrino masses is to introduce a completely new independent left-chiral Weyl field $\bar{\nu}$ which is uncharged under any of the gauge fields (i.e. in the singlet represtation). This new field simply isn't a part of the postulated matter content of the old Standard Model. It indirectly couples to the Higgs field via a three-point Yukawa coupling with the Higgs field and the $SU(2)$ doublet Weyl field $(\nu, e)$ (note that this ordered pair ranges over $SU(2)$ indices, not spin indices).
(I believe that Cosmas Zachos's answer is embedding $\bar{\nu}$ into a four-spin-component bispinor
$$\psi_R := \left( \begin{array}{c} 0 \\ \bar{\nu}^\dagger \end{array} \right),$$
but I personally find it more straightforward to work directly with the two-spin-component Weyl spinor fields. Depending on your perspective, either $\bar{\nu}$ or $\psi_R$ "is" the sterile neutrino.)
From the two Weyl fields $\nu$ and $\bar{\nu}$, we can form three different times of quadratic combinations, which are the three different types of mass terms that Cosmas Zachos describes in his answer. The term that mixes $\nu$ and $\bar{\nu}$ (Cosmas Zachos's "$D$" term) is the Dirac mass term, which conserves lepton number. The $A$ and $B$ terms are Majorana masses that violate lepton number. (As Cosmas Zachos discusses, the $A$ term has some subtleties regarding renormalizability.) As Cosmas Zachos points out, the question of whether neutrinos "are" Majorana fermions is more precisely the question of the $A$ and $B$ terms are nonzero. The alternatives are either (a) $A$ and $B$ are fined-tuned to zero for some unknown reason, which is rare but not unheard of (see the theta angle), or (b) the entire premise of introducing a new sterile-neutrino $\bar{\nu}$ is wrong, and we need a more convoluted explanation for the neutrino masses.
My only quibble with Cosmas Zachos's answer is his claim that "in the Standard Model, you only have $D$". I would perhaps call perhaps the "new Standard Model", which accomodates neutrino masses with the mimimal number of additional new nonzero parameters. In the "old Standard Model", where neutrinos are completely massless, then all three of the terms in Cosmas Zachos's answer are zero, because $\psi_R$ simply isn't a part of the theory.
I've frankly never understood why the presence of Majorana mass terms is described as the neutrino "being" a Majorana fermion - there are still Dirac mass terms as well. I'd welcome any comments in this issue.