Question

what is DDL and what are the 2 common statements

Answer 1

A data definition or data description language is a syntax similar to a computer programming language for defining data structures, especially database schemas.DDL statements create, modify, and remove database objects such as tables, indexes, and users.Common DDLstatements are CREATE, ALTER, and DROP.

For example, commands such as SELECT and INSERT are considered part of the Data Manipulation Language (DML), while access commands such as CONNECT and EXECUTE are part of the Data Control Language (DCL). The DDL, DML, and DCL languages includemost of the commands supported by SQL.

Answer 2

DDL statements are used to create, change, and remove objects including indexes, triggers, tables, and views. Common DDL statements include: CREATE (generates a new table)ALTER (alters table)