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 SET Phone='800-714-8321' WHERE Publisher_Name='Printing Is Us';
b) MODIFY PUBLISHER SET Phone='800-714-8321' WHERE Name='Printing Is Us';
c) ALTER PUBLISHER Phone='800-714-8321' WHERE Publisher_Name='Printing Is Us';
d) CHANGE PUBLISHER SET Phone='800-714-8321' WHERE Name='Printing Is Us';

Answer 1

The correct SQL statement to change the phone number for the publisher 'Printing Is Us' to 800-714-8321 is 'UPDATE PUBLISHER SET Phone='800-714-8321' WHERE Publisher_Name='Printing Is Us';'.

Step-by-step explanation:

The question asks which SQL statement will correctly change the phone number for the publisher Printing Is Us in the PUBLISHER table to 800-714-8321. The correct SQL statement to achieve this is:

UPDATE PUBLISHER SET Phone='800-714-8321' WHERE Publisher_Name='Printing Is Us';

The UPDATE statement is used to modify existing records in a table in SQL. The SET clause specifies the column to be updated and the new value, while the WHERE clause specifies which rows should be updated. In this case, we're targeting the row where the Publisher_Name is 'Printing Is Us', and we're setting the Phone column to '800-714-8321'.