Let's say we have any circuit, with two available terminals, consisting exclusively of ideal constant-resistance resistors, ideal constant-capacitance capacitors, and ideal constant-inductance inductors. We connect the two terminals of the circuit to a sinusoidal independent voltage source. Is there a frequency (or a set of frequencies) for the voltage source where in steady-state resonance occurs (the equivalent reactance of the circuit is exactly zero)?
This is a theoretical question. The frequency can be any (except infinite since we can't achieve exactly that, only approach it, and at infinite frequency capacitors acts as short-circuits and inductors as open-circuits, reducing the circuit to only resistors), and the value of the resistances, inductances and capacitances can be any constant value.
I'm not sure how to proceed to proof the above, i.e. whether there exists or not resonant frequencies for any circuit. Perhaps one way is to set the imaginary part of the equivalent impedance (seen by the source from the circuit) to zero: \$\Im [{\hat Z}_\text{eq}(\omega_0)] = 0\$ where \$\omega_0\$ is the resonant angular frequency. But what guarantees that there exists or not a particular value for the frequency that cancels the equivalent reactance? In other words, what guarantees that the equation \$\Im [{\hat Z}_\text{eq}(\omega_0)] = 0\$ has real solutions for \$\omega_0\$?
Another way is to simply find a counter-example, since that's what it takes to answer "do all circuits". So, in LTspice, I invented an arbitrary circuit, specifying the value of resistances, inductances and capacitances, I connected it to a sinusoidal voltage source with 0° of phase angle, and performed an AC Analysis sweeping the source frequency through a large range (from 1 Hz to 100 kHz). Then, I measured the negative of the current through the voltage source (since that's the current that enters to the circuit satisfying the passive sign convention in the passive circuit, and LTspice measures currents of voltage sources such that they enter into the positive terminal), and saw the plot of its amplitude and phase angle as a function of frequency. If there is a frequency where the phase angle of the current is exactly zero (and the amplitude is not zero), it means the current through the circuit is in phase with the voltage across the circuit, which happens only if the equivalent impedance of the circuit is purely resistive, so the equivalent reactance is zero.
But after doing all of that, surprisingly there was a frequency where the current phase angle was zero (so resonance occurred at that frequency). This is shown in the following figure.
Figure 1.
Figure 2.
As we can see, at \$f \approx\$ 361.415 Hz the phase angle of the current is zero and so resonance occurs as explained above. We can check this by running a phasor analysis at that frequency:
Figure 3.
Or by running a transient analysis at that frequency (notice the circuit voltage is in phase with the circuit current):
Figure 4.