Question

John want to change the default value of discount in the customer table 15 to 20 select the most appropriate command in SQL server to do the same from the following option

Answer 1

Answer:

The SQL data manipulation language (DML) is used to query and modify database data. In this chapter, we will describe how to use the SELECT, INSERT, UPDATE, and DELETE SQL DML command statements, defined below.

SELECT – to query data in the database

INSERT – to insert data into a table

UPDATE – to update data in a table

DELETE – to delete data from a table