Consider the following array of data: ARRAY(“apple”,”banana”). What function do you use to change apple to *pple AND banana to b*n*n*?

  • SUBSTITUTE
  • SUBSTITUTE_REGEX
  • REPLACE OR SUBSTITUTE
  • REPLACE
  • All of the above