COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
UPDATE emp SET mobile ____ number = 92745612 WHERE student ____ id=101;
|
|
|
UPDATE emp SET WHERE mobile ____ number = 92745612;
|
|
|
UPDATE emp SET mobile ____ number = 92745612;
|
|
|
UPDATE emp SET student ____ id=101;
|
Detailed explanation-1: -A DML (data manipulation language) refers to a computer programming language that allows you to add (insert), delete (delete), and alter (update) data in a database. A DML is typically a sublanguage of a larger database language like SQL, with the DML containing some of the language’s operators.
Detailed explanation-2: -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-3: -DDL stands for Data Definition Language. DML stands for Data Manipulation Language. DDL statements are used to create database, schema, constraints, users, tables etc. DML statement is used to insert, update or delete the records.
Detailed explanation-4: -DML commands include SELECT, INSERT, UPDATE, and DELETE.