Multiple choice technology databases

REPLACE('GEORGE' 'GE' NULL);

  1. NULLORNULL

  2. GEGE

  3. OR

  4. 2
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

REPLACE('GEORGE', 'GE', NULL) removes occurrences of 'GE' from 'GEORGE'. When the replacement string is NULL, Oracle's REPLACE removes the matched pattern entirely. Removing 'GE' from 'GEORGE' leaves 'OR'. The question syntax is missing commas but this is the intended logic.

Keep practicing — related questions