Saved Bookmarks
| 1. |
1. Classify the following SQL commands. Create table, Insert Into, AlterTable, Delete, Up-date, Drop Table, Select.2. List the features of each category |
|
Answer» 1. DDL – Create Table, Alter Table, Drop Table. DML- Insert Into, Delete, Update, Select. 2. DDL – DDL means Data Definition Language. It is used to create the structure of a table, modify the structure of a table and delete the structure of a table. DML -DML means Data Manipulation Language. It is used to insert records into a table, modify the records of a table, delete the records of a table and retrieve the records from a table. |
|