UGC NET CSE | June 2019 | Part 2 | Question: 37

Question

Which of the following statements are DML statements?

1. Update [tablename]

   Set [columnname]=VALUE

2. Delete [tablename]

3. Select * from [tablename]

• A.  a and b
• B. a and d
• C. a, b and c
• D. b and c

Answer 1

Data Manipulation Language:  The SQL commands that deals with the manipulation of data present in database belong to DML or Data Manipulation Language.

Examples of DML:

• SELECT – is used to retrieve data from the a database.
• INSERT – is used to insert data into a table.
• UPDATE – is used to update existing data within a table.
• DELETE – is used to delete records from a database table.

So all three a,b,c belongs to DML Commands, So 3 is the correct option.

Reference: SQL Commands

Comments

alter, add, modify, drop.

these are DML or DDL

---

Select is DDL command

https://www.google.com/amp/s/www.geeksforgeeks.org/sql-ddl-dql-dml-dcl-tcl-commands/amp/

---

@pawan kumarln  @Abhisek Tiwari 4

in that link Select is listed under DQL (Data Query Language).

---

SELECT is the most commonly used data manipulation language (DML) command.

Source : https://en.wikipedia.org/wiki/Select_(SQL)

---

@MRINMOY_HALDER

alter, add, modify, drop are DDL