1. What does DDL stand for? List the SQL DDL statements.

DDL stands for Data Definition Language which is used for creating tables relationships and other database structures (Kroenke & Auer). DDL is a set of commands that can manupulate tables, indexes and other properties in a database. Following are some of DDL statements that are used by database designers and programers.

Create Table: This command is used to create a table with different constraints like row and columns.

Alter Table: This command is used to alter certain data in a table e.g. change user properties.

Drop Table: This DDL statement is used to delete a table from the database.

Truncate Table: This command is used to remove all the records contained in a certain database table.

Rename: This command can be used to change the name of a database object.