Question

write one sql statement for each of the ddl and dml action​

Answer 1

Answer:

DDL refers to Data Definition Language , a subset of SQL statements that change the structure of the database schema in some way, typically by creating, deleting, or modifying schema objects such as databases, tables, and views. Most Impala DDL statements start with the keywords CREATE , DROP , or ALTER .

DML stands for Data Manipulation Language. 2. Usage. DDL statements are used to create database, schema, constraints, users, tables etc. DML statement is used to insert, update or delete the records.

Answer 2

Explanation:

DDL is Data Definition Language which is used to define data structures. For example: create table, alter table are instructions in SQL. DML: DML is Data Manipulation Language which is used to manipulate data itself. For example: insert, update, delete are instructions i