SELECT REPLACE('JACK and JUE','J','BL')FROM DUAL;

  1. jack and jue

  2. JACK and JUE

  3. ACK and UE

  4. BLACK and BLUE


Correct Option: D

AI Explanation

To answer this question, let's go through each option and the result of the REPLACE function:

Option A) jack and jue - This option is incorrect because the REPLACE function replaces all occurrences of 'J' with 'BL', resulting in "BLACK and BLUE".

Option B) JACK and JUE - This option is incorrect because the REPLACE function replaces all occurrences of 'J' with 'BL', resulting in "BLACK and BLUE".

Option C) ACK and UE - This option is incorrect because the REPLACE function replaces all occurrences of 'J' with 'BL', resulting in "BLACK and BLUE".

Option D) BLACK and BLUE - This option is correct because the REPLACE function replaces all occurrences of 'J' with 'BL', resulting in "BLACK and BLUE".

The correct answer is option D.

Find more quizzes: