Accepting that all the keyless chucks on hand held power tools are, by proper machine tool standards, pretty rubbish there is some variation in standards and gripping ability.
The better ones have a locking ratchet device built into the chuck. Almost always arranged for one handed operation.
To use the chuck properly it should be tightened up by turning in the usual manner, either by hand or power, and then backed off in the opposite direction by one “click” from the ratchet device. This ratchet is what stops it opening under load. Some varieties, like that on my big 18V Makita click the ratchet a couple or three times as the chuck comes up tight others are silent and only click when backed off. Whatever you have to come back one click.
I’m unsure as to whether I like the Makita click as it comes up tight idea. Reassuring in that it proves things are working but it’s tempting to assume that once sighted hard enough to click the ratchet the lock is on. Which it may or may not be. Assuming that resulted in very inconsistent behaviour when hammer drilling. Sometimes the drill would stay in sometime it would loosen. Back one click and it does stay put.
The two handed type have separate collar below the normal tightening sleeve. Generally a pain to get at which is probably why they have fallen out of favour.
So far as I, along with folk on You-Tube and Reddit, know this back one click to lock feature is not mentioned in any drill manual. Found a You-Tube by a guy who actually rang up the makers technical support for information. Mostly “Yes thats how it works.”.
I have seen the two handed type mentioned in a “why our drill is better” type advert some years back but have long forgotten which brand.
Clive