Q.Write the full form of the following abbreviations:

Concept: Database language categories in SQL

SQL commands are organized into sublanguages based on their function. Two fundamental categories handle different aspects of database management.

Essential reasoning:

1. DDL stands for commands that define and modify the structure (schema) of database objects like tables, indexes, and constraints — operations such as CREATE, ALTER, DROP. …

Database management systems organize commands into distinct categories based on what they do. Understanding these categories helps you grasp how databases are structured versus how data within them is actually used.

Data Definition Language (DDL) handles the skeleton of your database. It defines the structure—creating tables, altering their schema, setting up constraints, and establishing relationships. When you need to build or modify the architecture itself, you're working with DDL. Common DDL commands include CREATE, ALTER, DROP, and TRUNCATE.

Data Manipulation Language (DML), on the other hand, works with the actual data inside those structures. Once your tables exist, DML lets you insert records, update values, delete entries, and retrieve information. The classic DML commands are SELECT, INSERT, UPDATE, and DELETE. …