Consider the following array of data: ARRAY(“apple”,”banana”). What function do you use to change it to ARRAY(“Apple”,”Apple”)?

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