COMPUTER SCIENCE AND ENGINEERING
SQL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
UPDATE is a ____ command
|
DML
|
|
DDL
|
|
DCL
|
|
None of the above
|
Explanation:
Detailed explanation-1: -The update command is a DML command used to update a table’s records. The SET keyword is used in the update command. The WHERE clause is also used in the update command for updating single or multiple columns of the table.
Detailed explanation-2: -1. It is a Data Definition Language (DDL). It is a Data Manipulation Language (DML).
Detailed explanation-3: -The UPDATE statement is used to modify the existing records in a table.
Detailed explanation-4: -Update command is a data manipulation command which is used to edit the records of a table. It may be used to update a single row based on a condition, all rows or set of rows based on the condition given by the user.
There is 1 question to complete.