Which of the following is not included in DML(Data Manipulation Language)?
Which of the following is not included in DML(Data Manipulation Language)?
The correct option is C CREATE
Data Manipulation Language:- Data manipulation language (DML) is a computer programming used for adding
(inserting), deleting, and modifying (updating) data in a database. A DML is
often a sub language of a broader database language such as SQL, with the
DML comprising some of the operators in the language.
UPDATE: This command modifies data of one or
more records. An update command syntax is UPDATE [table name] SET [column name
= value] where [condition].
INSERT: This command adds one or more records
to a database table. The insert command syntax is INSERT INTO [table name]
[column(s)] VALUES [value(s)].
DELETE: This command removes one or more
records from a table according to specified conditions. Delete command syntax
is DELETE FROM [table name] where [condition].
Data Manipulation Language:- Data manipulation language (DML) is a computer programming used for adding (inserting), deleting, and modifying (updating) data in a database. A DML is often a sub language of a broader database language such as SQL, with the DML comprising some of the operators in the language.
UPDATE: This command modifies data of one or more records. An update command syntax is UPDATE [table name] SET [column name = value] where [condition].
INSERT: This command adds one or more records
to a database table. The insert command syntax is INSERT INTO [table name]
[column(s)] VALUES [value(s)].
DELETE: This command removes one or more
records from a table according to specified conditions. Delete command syntax
is DELETE FROM [table name] where [condition].
