SQL MCQs

Which of the following command will work as per below statement
"We need to replace a string named "foo" with "bar" in a column having ID <= 4"

UPDATE table_name

SET column_name= REPLACE('foo', 'bar')

WHERE ID <= 4;

UPDATE table_name

SET column_name = REPLACE(column_name, 'bar', 'foo')

WHERE ID <= 4;

UPDATE table_name

SET column_name = REPLACE(column_name, 'foo', 'bar')

WHERE ID <= 4;

Answer

Correct Answer:

UPDATE table_name

SET column_name = REPLACE(column_name, 'foo', 'bar')

WHERE ID <= 4;

Explanation:

Note: This Question is unanswered, help us to find answer for this one

SQL Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it