Contents of the PUBLISHER table

-Based on the contents of the PUBLISHER table,which of the following SQL statements will change the phone number for Printing Is Us to 800-714-8321?
A) UPDATE publisher REPLACE phone WITH '800-714-8321' WHERE pubid = 1;
B) UPDATE publisher REPLACE phone = '800-714-8321' WHERE pubid = 1;
C) UPDATE publisher SET phone = '800-714-8321' WHERE pubid = 1;
D) none of the above

Question

Contents of the PUBLISHER table​
 
-Based on the contents of the PUBLISHER table,which of the following SQL statements will change the phone number for Printing Is Us to 800-714-8321?​
A) ​UPDATE publisher REPLACE phone WITH '800-714-8321' WHERE pubid = 1; 
B) ​UPDATE publisher REPLACE phone = '800-714-8321' WHERE pubid = 1; 
C) ​UPDATE publisher SET phone = '800-714-8321' WHERE pubid = 1; 
D) ​none of the above

Quizplus · Accepted Answer

The correct SQL statement to change the phone number for Printing Is Us to 800-714-8321 is C) UPDATE publisher SET phone = '800-714-8321' WHERE pubid = 1; This statement uses the correct syntax of UPDATE table_name SET column_name = new_value WHERE condition, and specifically identifies the publisher with pubid = 1 to update the phone number. Option A is incorrect because it does not use the correct syntax for UPDATE statements, and Option B is incorrect because it uses the wrong operator (replace) and does not specify the new value. Option D is incorrect because there is a valid SQL statement to achieve the desired outcome.

Contents of the PUBLISHER Table​

Contents of the PUBLISHER Table