in Databases edited by
2,526 views
1 vote
1 vote

Which of the following statements are DML statements?

  1. Update [tablename]

    Set [columnname]=VALUE

  2. Delete [tablename]

  3. Select * from [tablename]

  1.  a and b
  2. a and d
  3. a, b and c
  4. b and c
in Databases edited by
by
2.5k views

1 Answer

3 votes
3 votes

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

4 Comments

@pawan kumarln  @Abhisek Tiwari 4

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

0
0

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

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

0
0

@MRINMOY_HALDER

alter, add, modify, drop are DDL

 

0
0
Answer:

Related questions