Contents of the PUBLISHER Table​

Multiple Choice

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