Hey there,
May be of some help but not sure as is FAA orientated.
We teach an Accelerated stall which is a stall in steep turn, this is usually to CFI candidates and demonstrated to PPL and Commercial pilots.
The accelerated stall would be in a steep turn usually 45deg to show that as you increase bank angle and thus load factor you will in turn increase the indicated speed at which the aircraft stalls.
It is used to help them avoid that lovely situation where they get slow and low, examples would be a forced landing or even ordinary landing if they get too slow. They try to get the aircraft lined up with where they want to land and over bank and stall spin the aircraft on final when they overshoot final and try to bring it back onto centre-line.
You obviously do this demo at above 3000AGL.
The other stall you mentioned is the Power on stall, this goes by a variety of names, Power on, after take-off, go-around.
As the names suggest the stall occurs when the aircraft has been made to do something with full power, as stated by one of the other posters this will usually mean that the trim has been set for a landing or forced landing and as full power is set the pilot is unable to hold the aircraft at the desired attitude the nose comes up and the aircraft stalls.
You would be amazed or not depending on your experience how much force will be required to hold the nose as required when you go from no power and glide trim to full power.
Hope that is of some help
-273