Contents of the CUSTOMERS table

Note: The ST column name is truncated,this represents the STATE column.
-Which of the following statements will display the value of FL assigned to the state column as FLORIDA?
A) SELECT customer#,city,SUBSTR(state,'FL','FLORIDA')FROM customers WHERE state = 'FL';
B) SELECT customer#,city,SUBSTR( 'FL','FLORIDA')FROM customers WHERE state = 'FL';
C) SELECT customer#,city,REPLACE( 'FL','FLORIDA')FROM customers WHERE state = 'FL';
D) SELECT customer#,city,REPLACE(state,'FL','FLORIDA')FROM customers WHERE state = 'FL';

Question

Contents of the CUSTOMERS table
  ​
Note: The ST column name is truncated,this represents the STATE column.
-​Which of the following statements will display the value of FL assigned to the state column as FLORIDA?
A) SELECT customer#,city,SUBSTR(state,'FL','FLORIDA')FROM customers WHERE state = 'FL'; 
B) SELECT customer#,city,SUBSTR( 'FL','FLORIDA')FROM customers WHERE state = 'FL'; 
C) SELECT customer#,city,REPLACE( 'FL','FLORIDA')FROM customers WHERE state = 'FL'; 
D) SELECT customer#,city,REPLACE(state,'FL','FLORIDA')FROM customers WHERE state = 'FL';

Quizplus · Accepted Answer

Option D will use the REPLACE function to replace the value of "FL" with "FLORIDA" in the STATE column for rows where STATE is equal to "FL". Therefore, it will display the value of FL assigned to the state column as FLORIDA. Option A is incorrect because the SUBSTR function is used to extract a substring from a string, not to replace a substring. Option B is incorrect because it does not include the name of the STATE column in the SELECT statement and does not use the REPLACE function to replace the substring. Option C is incorrect because the REPLACE function requires two arguments, the string to be replaced and the string to replace it with.

Contents of the CUSTOMERS Table