Which of the following statements are DML statements?

(a) Update [tablename] = Set [ columnname] VALUE

(b) Delete [tablename]

(c) Select * from [tablename]

1. A(a) and (b)
2. B(a) and (d)
3. C(a), (b) and (c)
4. D(b) and (c)

Pick an option to check yourself, or open the answer below.

Show answer & explanation

Correct answer: C. (a), (b) and (c)

Explanation

UPDATE, DELETE and SELECT all manipulate or query data, so they are DML.