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

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