Question

Which of the following are DML statements?
Select one or more:
INSERT
CREATE
SELECT
TRUNCATE

Answer 1

DML [Data Manipulation Language] commands are used to manipulate the records of an existing table/to make changes to the records.

From the commands given in the question, INSERT and SELECT are DML commands as they deal with the manipulation of data.

• INSERT is a command used to add data to a table.
• SELECT is a command used to retrieve data/display data from a table.

Examples:

• Insert into School values(1, 'Westminister High', 'Dubai', '1990-04-21');

This command will insert the values [1, 'Westminister High', 'Dubai', '1990-04-21'] into the table School.

• Select * from School;

This command will retrieve/display all the data from the table School.

Answer 2

DML, or Data Manipulation Language, is a subset of database operations used to insert, delete, and update data.

DML commands , are used to manipulate or change the records of an existing table.

1. INSERT

• Insert is a DML statement.
• The insert command is used to insert one or more rows with specified table column values into a database table.

2. CREATE

• The CREATE TABLE statement is a DDL statement used to create tables in a database.
• As soon as the CREATE TABLE script is executed, the table is created and ready to hold data.

3. SELECT

• A DQL statement  is used to obtain some schema relation based on the query passed to it.
• It contains the SELECT statement which allows you to extract data from the database in order to perform operations on it.
• When a SELECT statement is executed against a table or tables, the result is compiled into a new temporary table.

4. TRUNCATE

• TRUNCATE TABLE is similar to DELETE, but it is a DDL statement rather than a DML statement.
• Truncate statements drop and recreate tables, which is much faster than manually deleting rows, particularly for large tables.

Hence, INSERT is a DML statement.

#SPJ2