Do Grave Domain clerics get the additional Spare the Dying benefits if they already know the spell?

The Grave Domain Cleric learns the spare the dying cantrip at level 1 via the class feature Circle of Mortality, which also gives them extra benefits relating to it. Part of the description of the feature says (XGtE, pg. 20):

… In addition, you learn the spare the dying cantrip, which doesn’t count against the number of cleric cantrips you know. For you, it has a range of 30 feet, and you can cast it as a bonus action.

However, what if I multiclass into cleric and I already have the spare the dying cantrip (e.g. via having taken Magic Initiate before now or, in my case, via originally being a Warlock with the Undying patron, which also grants this cantrip at level 1)?

Similar bonus cantrips usually have wording more like the Light Domain Cleric (PHB, pg. 61):

When you choose this domain at 1st level, you gain the light cantrip if you don’t already know it.

The Circle of Mortality class feature doesn’t say something like “if you don’t already know it”. Thus, if I already have the cantrip, do the extra benefits still count (i.e. increased range and option to cast it as a bonus action) since this class feature was not the one to grant me this cantrip in the first place?

Benefits of not having a clustered index on tables (Heaps)

What are the benefits of not having a clustered index on a table in SQL server. Will a

SELECT * INTO TABLE_A FROM TABLE_B 

Be faster if TABLE_A is a heap? Which operation will benefit if the table is a heap? I am quite sure UPDATE‘s and DELETE‘s will benefit from a clustered index. What about INSERTS? My understanding is that INSERT "might" benefit from the table being a heap, both in term of speed but also other resources and hardware (I/O, CPU, memory and storage…).

What is the most scarce resource in terms of hardware? In terms of storage is a heap going to occupy less space? Is disk storage not the least expensive resource? If so is it rational to keep table as heap in order to save disk space? How will a heap affect CPU and I/O with SELECT, INSERT, UPDATE and DELETE? What cost goes up when table is a heap and we SELECT, UPDATE and DELETE from it?

Thansk

Would a Minimus Imprisoned Paladin still provide aura benefits to nearby allies?

If you cast imprisonment with the option Minimus Containment on a high-level paladin, can you wear the gem as a necklace and continue to gain paladin buffs? This is assuming that the paladin continues to view you as an ally.

I assume that the paladin is considered to be conscious since the spell does not say otherwise and it mentions that it is possible for the creature trapped inside the gem to view what is going on outside.

Inconsistent spellcasting benefits from prestige classes?

Am I reading these rules right? There seem to be some strange inconsistencies in the benefits some prestige classes grant to the base spellcasting class. Here are some examples, all from the 3.5 DM’s Guide (although the inconsistencies continue in other rulebooks).

Archmage (page 178) buffs spells per day and spells known, but doesn’t mention caster level:

When a new archmage level is gained, the character gains new spells per day (and spells known, if applicable) as if he had also gained a level in whatever arcane spellcasting class in which he could cast 7th-level spells before he added the prestige class level. He does not, however, gain any other benefit a character of that class would have gained (bonus metamagic or item creation feats, and so on).

Eldritch Knight (page 188) buffs spells per day and caster level but doesn’t mention spells known:

From 2nd level on, when a new eldritch knight level is gained, the character gains new spells per day as if she had also gained a level in whatever arcane spellcasting class she belonged to before she added the prestige class. She does not, however, gain any other benefit a character of that class would have gained (bonus metamagic or item creation feats, bard or assassin abilities, and so on). This essentially means that she adds the level of eldritch knight to the level of whatever other arcane spellcasting class the character has, then determines spells per day and caster level accordingly.

Loremaster (page 191) buffs all 3: spells per day, known, and caster level:

A loremaster continues training in magic as well as her field of research. Thus, when a new loremaster level is gained, the character gains new spells per day (and spells known, if applicable) as if she had also gained a level in a spellcasting class she belonged to before she added the prestige class. She does not, however, gain any other benefit a character of that class would have gained (improved chance of controlling or rebuking undead, metamagic or item creation feats, and so on). This essentially means that she adds the level of loremaster to the level of some other spellcasting class the character has, then determines spells per day, spells known, and caster level accordingly.

The possibility of prestige classes that buff all 3 is especially odd in the context of Sorcerers; I see no reason to continue leveling Sorcerer once you qualify for a prestige class. A Sorcerer 10/Loremaster 10 character gets the same spells per day, known, caster level, HD, base attack bonus, and saves (actually, slightly better Will) as a Sorcerer 20, in addition to the Loremaster class features. (By contrast, Wizards get bonus feats, which they’d give up by pursuing Loremaster.)

I misunderstanding the rules somehow?

Benefits of “Bluetooth LE Privacy” feature?

For making an (until now, un-) educated guess about the necessity of spending the effort of including the "Bluetooth LE Privacy" feature in a consumer, embedded device’s BT software, I am seeking information about the "necessity" from an information security standpoint of offering this feature – is it useful? does it really solve a security issue or is it already broken?

The BT SIG itself is fairly quiet about this feature besides well-worded blog posts, so shedding a little light on this would help tremendously in making the decision to "go the extra mile" or just leave it aside.

In Pathfinder 2e, are ability modifier benefits to things like HP and trained skills retroactive?

In Pathfinder 2e, a character’s Constitution bonus affects HP total. A character’s Intelligence bonus grants training in additional skills and languages.

Are these benefits retroactive?

Examples:

  • If a character’s Constitution modifier increases from +2 to +3 as the result of an ability boost, does HP increase by 1 per character level? So a level 5 character going from +2 to +3 Con mod would gain 5 hit points for the ability score increase?
  • If a character’s Intelligence modifier increases from +1 to +2 as the result of an ability boost, does that character gain another trained skill and learned language?

Gigantic Steed class ability gives all the benefits of a Huge mount?

As per title, I’m wondering whether the Gigantic Steed ability of the Mammoth Rider grants your mount all the benefits of a size increase, namely +8 Str. In fact, the text of the ability is:

A mammoth rider’s steed increases to Huge size. […] It also gains a +2 size bonus to its Strength and Constitution.

And then the bonuses to Str and Con increase over time with the Mammoth Rider class. So, for example, a standard Mastodon companion has a base str of 24, so by becoming Huge its str goes up to 26 (and then there are all the size modifiers to CMB, CMD, AC, Attack, etc). Am I correct?

Finally, I recall that a size increase from large to huge means +8 str, but I can’t find any confirmation in the books. Right now all I have is Animal Growth’s text and the fact that PCGen gives it a +8 str. Is there any standard reference for the matter?

Security Benefits of Having a Content Security Policy for a Domain Loaded through iframe

Consider the below scenario:

There’s a checkout webpage that can be accessed at checkout.example.com. This page has decent security policy. But just to prevent any credit card info leakage, credit card information editing panel is in an iframe and this panel can be loaded from cc.example.com.

Now, are there any security benefits for having a good Content Security Policy for cc.example.com when we are loading it in an iframe in checkout.example.com?