A "holds" identifier allows an Artifact to be activated outside of the Artifact pile during your prep phase. This allows cards like Fortresses that hold Artifacts and Magic Charms to activate independent from the Artifact pile.
Apart from those, or abilities that allow you to activate an Artifact (U&T, Queen Maachah, etc), you're only allowed to active one Artifact per turn on your Artifact pile.