Consider The Following Array Of Data: ARRAY(“Apple”,”Orange”,”EggPlant”,”Apple”,”Zucchini”,”Carrot”,”Orange” ,”EggPlant”,”Kale”,”Bananas”). What Function Would You Use To Replace “EggPlant” With “Brinjal” AND “Kale” With “SomeGreenThing”?

Certification Answers
Consider The Following Array Of Data: ARRAY(“Apple”,”Orange”,”EggPlant”,”Apple”,”Zucchini”,”Carrot”,”Orange” ,”EggPlant”,”Kale”,”Bananas”). What Function Would You Use To Replace “EggPlant” With “Brinjal” AND “Kale” With “SomeGreenThing”?
  • REPLACE
  • SUBSTITUTE
  • SUBSTITUTE_REGEX
  • REPLACE OR SUBSTITUTE
  • All of the above