apps and dev quiz

[CISSP_Candidate]

Got this question on the quizz and I am pretty sure the answer is wrong...

Which of the following is used to create and delete views and relations within tables?

A:SQL Data Definition Language
B:SQL Data Manipulation Language
C:SQL Data Relational Language
D:SQL Data Identification Language

I said B but they say A
The SQL Data Definition Language is used to create and delete views and relations (tables).

In the Shon Harris book it says
Data manipulation language (DML) Contains all the commands that enable a user to view, manipulate, and use the database (view, add, modify, sort, and delete commands).

[Jescoi]

I would have been inclined to agree with you, but looked closer at the question and saw the key words "create", "delete". The DML allows you to manipulate the data within a table, but when it comes to manipulating the structure (including creating and deleting), then that's the job for the DDL. I think that the word "views" is what would make you instinctively choose DML, but views are created and deleted by the DDL, as are relations.