Multiple choice technology databases

REPLACE

  1. Replaces word by word

  2. Replaces a column with another column

  3. Replaces character by character

  4. Replaces a row with another row

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In SQL, the REPLACE function replaces all occurrences of a specified substring (word or sequence of characters) with another substring, whereas TRANSLATE performs character-by-character substitution.