What is DML in Apache Cassandra?

Question

I plan to adopt DataStax Cassandra Certification for the developer. I recently took a practice test and I scored 94% out of 100 if 1 answer was flagged incorrectly. The question arises:

Given the following table, which of the following statements is an example of 
Data Modification Language (DML) in CQL? CREATE TABLE comics ( title text, 
issueNumber int, originalPriceDollars float, PRIMARY KEY ( title, issueNumber 
) );

SELECT * FROM comics;
ALTER TABLE comics ADD currentPriceDollars float;
DROP KEYSPACE test;
None of the other answers are DML.

I chose the ALTER TABLE comic book option, and according to DataStax, this answer is incorrect. Then what is DML in Kassandra. Doesn't this expression alter the data? And the correct answer is: None.

Thank.

Answer 1

ALTER it will technically be DDL (Data Definition Language) as it modifies the underlying tables / structures.

DML (Data Manipulation Language) will look something like this:

UPDATE comics SET originalPriceDollars=6.99 
    WHERE title='Star Wars: Darth Maul' AND issueNumber=1;

UPDATE INSERT , ALTER /.