Ramifications of changing skill check into attack

What changes when I substitute an attack in place of ability check?

Examples:

Eldritch Bash

You can use a bonus action to try to shove a creature within 5 feet of you with your shield, making Melee Spell Attack instead of Strength (Athletics) check against opponent’s Strength (Athletics) or Dexterity (Acrobatics) check, not their AC.

Percussive Lockpicking

As an action you can make a Melee Weapon Attack against lock, treating lockpicking DC as AC. On hit the lock opens.

(phrasing subject to change)

When substituting one ability for another on a skill check which kind of check does it qualify as?

The Unearthed Arcana Monk tradition Way of the Astral Self has the following ability (page 2 of the PDF):

Arms of the Astral Self

You can use your Wisdom modifier in place of your Strength modifier when making Strength checks and Strength saving throws.

Imagine such a monk took 1 level dip into Barbarian and picked up that class’s rage ability which includes:

You have advantage on all Strength checks and Strength saving throws.

If the monk goes to make a strength check (say, a grapple check), does the monk have advantage on the check because it counts as a strength check (but she’s using her wisdom modifier)?

Or does she roll a normal check with her wisdom modifier because it’s now a wisdom check, as determined by the fact that she’s using wisdom for the check, not strength?

Please check my answer to a pseudocode CASE statement question

This is a pseudocode question in my IGCSE CompSci textbook:

Use a CASE statement to display the day of the week if the variable DAY has the value 1 to 7 and an error otherwise.

This is my answer to it:

CASE Day OF     1 : OUTPUT "Monday"     2 : OUTPUT "Tuesday"     3 : OUTPUT "Wednesday"     4 : OUTPUT "Thursday"     5 : OUTPUT "Friday"     6 : OUTPUT "Saturday"     7 : OUTPUT "Sunday"     OTHERWISE OUTPUT "Day invalid" ENDCASE 

Is this answer correct?

(I realise this is a very rudimentary question for a Year 10/11 CompSci class but I’m homeschooled with no teaching guidance whatsoever. So a big cheers to anyone who would take the time to check my answer for me.)

Local MySQL database check for changes

Me and my friend had a website. Before closing website he dumped MySQL Database from phpmyadmin and stores it locally on his PC. Now he send me sql file. Is there a way to see if he didn’t change/add/remove lines,tables and variables and other stuff from *.sql file ? How he can modify the file so I can’t notice that file is modified ?

What are the degrees by which an Arcana Check can modify or effect the characteristics of a spell being cast by the player?

Sorry if the initial wording seems off, basically what I’m trying to get a bearing for is how or in which ways does the Arcana Skill influence or effect actual spells being cast or other spell-centered details? Ie, is rolling on the Arcana skill able to influence the effect or characteristics of a spell? Or does that fall primarily within relation to magic items and not casted spells?

Check if every prefix sum of subsequence is $>=0$ and sum is $=0$

Lets consider sequences which elements are $ -1,0,1$ .
Subequence $ A[i…j]$ is $ good$ if sum of its elements $ =0$ .
Example: for sequence $ 1,1,0,-1,-1,1$ subsequence $ 1,0,-1,-1,1$ is $ good$ .

Subsequence $ A[i…j]$ is $ supergood$ if it is good and every its prefix-sum is $ >= 0$
Example: for sequence $ 1,1,0,-1,-1,1$ subsequence $ 1,0,-1,-1,1$ is not $ supergood$ but $ 1,0,-1$ is $ supergood$ .

Now I want to have dynamic data structure which allows mi effictielly do these operations:

  • Insert(S,x,i) – inserts $ x$ into $ S$ on $ i$ ‘th position
  • Remove(S,i) – Remove $ i$ ‘th element
  • isSuperGood(S, i, j) – checks if subsequence $ i$ , $ j$ is super good

The solution could be AVL tree with sum of elements in left and right subtree. It is easy for update and allows us to check if subsequence is good in O(log(n)):

  1. Find node i (let say v) O(log(n))
  2. Find node j (let say u) O(log(n))
  3. Check if v.val + vl.lsum – u.lsum + u.val == 0 O(1)

But if it comes to checking supergood condition, I don’t see how.