As others have said, yes, the ability will exist twice on each of your Sliver creatures, and each of those creatures will trigger it twice upon attacking.
In what situations would a creature be allowed to have two copies of the same ability (if ever)?
There is no limit to the number of copies of the same ability a creature can have. They are each added to the list of things that creature can do, and triggered abilities will each trigger separately. If you have 4 Thorncaster Slivers on the field, each sliver's attack will cause it to deal 1 damage 4 times. Notably, this allows you to distribute your damage however you like--you are not limited to dealing damage in packets of 4.
This doesn't mean that multiple copies of the same ability are always useful. For example, it's stated in the rules that multiple copies of flying, haste, lifelink, and many other keyword abilities are redundant, so a creature that gains flying twice doesn't have any advantages over a creature that has it once, and a creature with two instances of lifelink doesn't gain you twice as much health (although cards like Armadillo Cloak, which don't use the keyword but have similar effects, will stack with lifelink). See this list for which abilities stack and which don't.
Also worth noting that in cases where the duplicated abilities have a cost, such as Prodigal Pyromancer being enchanted with Arcane Teachings, it doesn't simply increase the effectiveness of the ability. Prodigal Pyromancer will have 2 copies of the "{t}: deal 1 damage" ability, but each of those costs must be paid separately--tapping once will allow you to activate either the innate ability or the one granted by the enchantment, but not both. Triggered abilities which have a cost (e.g. "When X happens, you may pay Y. If you do, Z.") must also be paid for separately.