it isn't if it is unusable, it is if it is below AMDs requirements.
If it produces slightly more heat, if it can't overclock quite as well, if it isn't quite as effecient as they wanted, if it has a maor manufacturing fault causeing problems, they will lock it off. The ones that you can unlock are the ones with minor problems, like producing a little too much heat or aren't quite as efficient or whatever, but only if you have a motherboard which has ACC, which is Advanced Core Control, you need that to be able to unlock the 4th core in the bios
On some though the 4th core doesn't work, it will cause system instability or just won't work at all, and if you get one of those you are unlucky because you can still unlock the 4th core, but obviously if it is hanging or BSODing or won't even post, it isn't usable so you are better sticking with a tri core CPU