|
Answer» DDL- Data Definition Language: - DROP: Used for dropping the OBJECTS of database or database itself.
- ALTER: Properties of database objects can be altered.
- CREATE: Used in the creation of databases and their objects like tables, views, etc.
- TRUNCATE: Using this all RECORDS from the table can be removed.
- RENAME: Used to rename the database objects.
DML- Data Manipulation Language: - SELECT: From the database, specific records or data can be selected.
- INSERT: Used to insert new data or records.
- UPDATE: Existing records can be updated using UPDATE.
- DELETE: Existing records can be deleted.
DQL- Data Query Language: - SELECT: queries fall under this CATEGORY.
DCL- Data Control Language: - GRANT: Used in granting the user access permissions.
- DENY: User permissions can be denied using it.
- REVOKE: User access can be removed using it.
TCL-Transaction Control Language: - COMMIT: Used for writing and storing the changes in the database.
- ROLLBACK: Used to restore the changes to the LAST commit.
|
