Week 2 Notes

Question 1

three categories of SQL statements

Answer 1

Data definition language, data manipulation language, and data control language

Question 2

data definition language

Answer 2

statements create, alter, and drop metadata for tables and many other object in the database. i.e DROP TABLE would remove any raw data stored in that table

Question 3

data manipulation language

Answer 3

statements insert, update, delete, and access the raw data stored in tables.

Question 4

data control language

Answer 4

statements grant and revoke privileges to database users to execute some or all of the DML and DDL statements