Question

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 SET phone_number = '800-714-8321' WHERE publisher_name = 'Printing Is Us';
b) MODIFY PUBLISHER SET phone_number = '800-714-8321' WHERE publisher_name = 'Printing Is Us';
c) CHANGE phone_number TO '800-714-8321' WHERE publisher_name = 'Printing Is Us' IN PUBLISHER;
d) ALTER PUBLISHER SET phone_number = '800-714-8321' WHERE publisher_name = 'Printing Is Us';

Answer 1

The correct SQL statement to change the phone number for Printing Is Us in the PUBLISHER table is: UPDATE PUBLISHER SET phone_number = '800-714-8321' WHERE publisher_name = 'Printing Is Us'.

Step-by-step explanation:

The correct SQL statement to change the phone number for Printing Is Us in the PUBLISHER table is:

a) UPDATE PUBLISHER SET phone_number = '800-714-8321' WHERE publisher_name = 'Printing Is Us';

This statement uses the UPDATE command to modify the phone_number column in the PUBLISHER table. The WHERE clause specifies the condition that the publisher_name must be 'Printing Is Us'. The new phone number is specified as '800-714-8321'.